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
. Here, you should now see the option to select Couchbase Analytics by Couchbase.Set Up SSL Support for Tableau Server
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 Connector:
-
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>