Stream Data from Couchbase Capella
- how-to
To continuously update Enterprise Analytics with data hosted on a Couchbase Capella operational cluster, create a link and collection.
For an example, see Create Remote beer-sample Collections. |
Requirements for Couchbase Capella Links
You need to take the following steps on your Couchbase Capella operational cluster:
-
To allow Enterprise Analytics to connect to a Couchbase Capella operational cluster, you must add the IP address of the Enterprise Analytics server to the Capella cluster’s "Allowed IP" list. For more information, see Add an Allowed IP Address.
-
Get the hostname or external IP address for 1 of the Couchbase Capella cluster nodes. You supply this value to Enterprise Analytics as the hostname/IP address.
-
Create a user and password for Enterprise Analytics to use when connecting. Give this user read/write permissions for all buckets and scopes you want to stream. For more information, see Create Cluster Access Credentials.
-
Save a copy of the Couchbase Capella cluster root certificate. You can find the certificate on the Capella UI at the Security Certificate page under Settings.
-
Note the names of the bucket, scope, and collection you want to stream to Enterprise Analytics.
Create a Link to Couchbase Capella
-
In the UI, select the Workbench tab.
-
. Select + new link.
-
In the Link Name field, enter a name for the link.
-
In the Link Type field, select Couchbase.
-
In the Remote IP/Hostname list, select the hostname or IP address of a node in the remote cluster you want to link. IPv6 addresses need to be enclosed in square brackets.
-
In the Encryption Type field, select Full:
- Full (using credentials)
Remote Username
Enter the required username.
Remote Password
Enter the required password.
Remote Cluster Certifcates(s)
Paste a trusted root certificate.
For more information, see Use Your Capella Root Certificate and Create Cluster Access Credentials.
-
Select Prevents Redirects to prevent HTTP connections for the remote link.
-
Click Save.
Create a Collection
-
In the UI, select the Workbench tab.
-
Next to the link you created in Create a Link to Couchbase Capella, click + collection.
-
In the Collection Name field, enter a name for the collection.
-
In the Database list, select the required database and in the Scope list, select the required scope or verify the supplied database and scope if you’re adding it to a specific scope.
-
In the Source bucket.scope.collection field, select the source bucket, scope and collection.
-
In the Where (optional) field, you can add an optional WHERE clause to filter documents in the dataset. Make sure you do not include the WHERE keyword.
-
Click Save.
Connect the Link
To start streaming data from your Couchbase Capella operational cluster to Enterprise Analytics, use the explorer and locate the link you want to connect. Click the link icon.