Using the Couchbase Connection Manager

The Couchbase Connection Manager is an SSIS connection manager component that can be used to establish connections with Couchbase.

To add a Couchbase connection to your SSIS package, right-click the Connection Manager area in your Visual Studio project, and choose "New Connection..." from the context menu. You will be prompted the "Add SSIS Connection Manager" window. Select the "Couchbase" item to add the new Couchbase connection manager.

New Connection

Add SSIS Couchbase Connection Manager

The Couchbase Connection Manager contains the following two pages to connect to your Couchbase server.

  • Authentication
  • Advanced

Authentication Page

The Authentication page of the Couchbase Connection Manager allows you to specify the server addresses and credentials for authentication.

Couchbase Connection Manager

Service Endpoint

This option allows you to specify the endpoint to which you are connecting to.

Username

The Authorization username that would be used to access the Couchbase instance.

Password

The password that would be used to access the Couchbase instance.

Test Connection

After all the connection information has been provided, you may click the "Test Connection" button to test if you can connect successfully.

Advanced Page

This page contains all possible settings for a Couchbase connection. Clicking on a specific setting will display a description for the selected property at the bottom of The Advanced page.

Couchbase Connection Manager - Advanced