Install the Couchbase Analytics Connector on Tableau Server

how-to

The Couchbase Analytics Connector can be installed on Tableau Server.

This enables publishing of reports and workbooks that are created on Tableau Desktop to a Tableau Server project. The connector also allows users to publish the data sources they created on Tableau Desktop with the Couchbase Analytics Connector to Tableau Server. Other users with access to the project can build their own reports and workbooks using the same data sources.

Install the Couchbase Analytics Connector on Tableau Server for Windows

On Windows running Tableau Server, copy the couchbase-analytics-<version>.taco file to the C:\ProgramData\Tableau\Tableau Server\data\tabsvc\vizqlserver\Connectors folder.
Next, copy the couchbase-jdbc-driver-<version>.jar to the C:\Program Files\Tableau\Drivers folder.

To apply the changes and install the connector run the following commands.

tsm configuration set -frc -k native_api.connect_plugins_path -v "C:\ProgramData\Tableau\Tableau Server\data\tabsvc\vizqlserver\Connectors"
tsm configuration set -k JdbcDriverCustomLoad -v false --force-keys
tsm pending-changes apply

Install the Couchbase Analytics Connector on Tableau Server for Linux

On Linux running Tableau Server, copy the couchbase-analytics-<version>.taco file to the /var/opt/tableau/tableau_server/data/tabsvc/vizqlserver/Connectors folder.
Next, copy the couchbase-jdbc-driver-<version>.jar to the /opt/tableau/tableau_driver/jdbc folder.

To apply the changes and install the connector, run the following commands.

tsm configuration set -frc -k native_api.connect_plugins_path -v /var/opt/tableau/tableau_server/data/tabsvc/vizqlserver/Connectors
tsm configuration set -k JdbcDriverCustomLoad -v false --force-keys
tsm pending-changes apply

Verify the Couchbase Analytics Connector for Tableau Server Installation

Once the changes have been applied, launch Tableau Server and go to Home New Workbook Connect to Data Connectors. Here, you should now see the option to select Couchbase Analytics by Couchbase.

Set Up SSL Support — Tableau Connector 1.1.x

Tableau Connector 1.1.x

This section only applies to Tableau Connector 1.1.0 and later.

Usually, you won’t need to follow this section. There is no need to provide a certificate if you are connecting to Couchbase Capella, or using a certificate from a public certificate authority. Certificates of well-known public certification authorities as well as Couchbase Capella are trusted by default.

To configure SSL support for Tableau 1.1.0 and later:

Make sure you know the absolute paths to the certificate or keystore. You should only supply one of the certificate path or the keystore path, not both.
Create a file called couchbase-analytics.properties and save it in the following directory, depending on whether you are running MacOS or Windows:

Windows

Save the file to ProgramData\Tableau\Tableau Server\data\tabsvc\vizqlserver\Datasources

MacOS

Save the file to /var/opt/tableau/tableau_server/data/tabsvc/vizqlserver/Datasources/
To provide the Certificate file path, add the following line in the properties file.
```
sslCertPath=<path to your certificate file>
```

To provide the keystore path, add the following lines in the properties file.

sslKeystorePath=<path to your keystore>
sslKeystorePassword=<your keystore password>

To configure SSL support for Tableau Connector 1.0.x, see Set Up SSL Support — Tableau Connector 1.0.x.