{"id":13264,"date":"2022-05-27T15:36:03","date_gmt":"2022-05-27T22:36:03","guid":{"rendered":"https:\/\/www.couchbase.com\/blog\/?p=13264"},"modified":"2023-06-08T13:41:13","modified_gmt":"2023-06-08T20:41:13","slug":"talend-couchbase-capella-connector","status":"publish","type":"post","link":"https:\/\/www.couchbase.com\/blog\/talend-couchbase-capella-connector\/","title":{"rendered":"Talend Introduces Couchbase Capella Support on Talend Big Data Platform 8.0"},"content":{"rendered":"

Many organizations looking to modernize their legacy databases are evaluating fully managed hosted DBaaS offerings that provide flexibility, performance and scale without compromising the trusted strengths of relational databases (RDBMS). With the introduction of Couchbase Capella DBaaS<\/a>, customers can now benefit from exceptional price-performance to bring down their total cost of ownership (TCO). <\/span><\/p>\n

However, ensuring that established data integration tools and processes can be used to move data into Couchbase Capella<\/a> can be an important dependency in transitioning to cloud services<\/a>. This is why we are excited to introduce the support of Couchbase 7.x in Talend Big Data Platform 8.0, covering both Couchbase Server and Capella.<\/span><\/p>\n

Talend offers a range of data management capabilities, ranging from business process management to ETL and master data management. Talend’s new Big Data Platform 8.0 release contains an updated Couchbase connector, enabling the modernization and migration of business-critical applications.<\/span><\/p>\n

Creating an ETL workflow for Couchbase Capella<\/b><\/h2>\n

This blog shows how to connect Talend with Couchbase Capella and perform a simple ETL workflow. Talend Big Data Platform<\/a> will be leveraged to export relational data from a MySQL database into Couchbase using the JSON document format. <\/span><\/p>\n

The workflow will read from a MySQL database table and create corresponding JSON documents in Couchbase Server. You can build upon this example and augment it to support more complex scenarios involving data transformations, complex mappings, etc. <\/span><\/p>\n

The following steps have been tested on macOS but can be adapted for other systems.<\/span><\/p>\n

Couchbase Capella offers a free 30-day trial and allows you to create your first cluster in a few clicks in just minutes. You can start your trial with a single click<\/a>.<\/span><\/p>\n

\"talend-couchbase-connector10\"<\/p>\n

Just enter your name<\/em>, email<\/em>, and organization name<\/em>. Once your email is verified, you can begin your trial. Simply select your preferred AWS region<\/em> and click “Start Trial”.<\/span><\/p>\n

\"Couchbase<\/p>\n

The trial will create a single node Couchbase cluster in AWS. Once your cluster is created, we need to configure a data bucket for this example. <\/span><\/p>\n

Navigate to Clusters<\/strong> > Trial-Cluster <\/strong>> Buckets <\/strong>> Create Bucket<\/strong>.\u00a0 We will name the bucket world<\/em>.<\/span><\/p>\n

\"\"<\/p>\n

Click Next<\/strong> to continue, accept the defaults and click Create Bucket<\/strong>. Also, create the travel-sample<\/em> bucket by navigating to Tools<\/strong> > Import<\/strong> and scroll down to Travel Sample<\/em> and select Import<\/strong>.<\/span><\/p>\n

\"Import<\/p>\n

We will now need to configure access to the cluster from a remote workstation. <\/span><\/p>\n

Navigate to Clusters<\/strong> > Trial-Cluster<\/strong> > Connect<\/strong> and scroll down to Database Access<\/strong> > Manage Credentials<\/strong>, then +Create Database Credential<\/strong>.<\/span><\/p>\n

\"Create<\/p>\n

Make sure to use the dropdown under Bucket Level Access<\/strong> and enter world<\/em>, All Scopes, <\/em>and Read\/Write<\/em> for the settings, then click Create<\/strong>. Repeat for the travel-sample<\/em>\u00a0bucket.<\/span><\/p>\n

Allowing local IP access to Capella<\/h3>\n

Next, we need to configure access to your local workstation as we will be running Talend Studio locally. Navigate to Connect<\/strong> > Manage Allowed IP<\/strong>. From there, you can click + Add My IP<\/strong>.<\/span><\/p>\n

\"Add<\/p>\n

The Couchbase Capella configuration is complete for now.<\/span><\/p>\n

Install MySQL sample database<\/h3>\n

Next, we need to install and\/or configure the MySQL server which is also running on the local workstation. I am using macOS and <\/span>Homebrew<\/span><\/a> to install additional packages.<\/span><\/p>\n

To install MySQL via Homebrew, open a terminal and type: brew install mysql <\/em>.<\/span>\u00a0<\/span><\/p>\n

Download and import the world<\/em> database:<\/span><\/p>\n