Install the Couchbase Tableau Connector on Tableau Server

  • how-to
You can install the Couchbase Tableau Connector 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 Tableau 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 Connector on Tableau Server for Windows

On Windows:

  1. Copy the .taco file into C:\ProgramData\Tableau\Tableau Server\data\tabsvc\vizqlserver\Connectors.

  2. Copy the .jar file into C:\Program Files\Tableau\Drivers.

  3. To apply the changes and install the connector, run the following command.

    tsm pending-changes apply

Install the Connector on Tableau Server for Linux

On Linux:

  1. Copy the .taco file into /var/opt/tableau/tableau_server/data/tabsvc/vizqlserver/Connectors.

  2. Copy the .jar into /opt/tableau/tableau_driver/jdbc.

  3. To apply the changes and install the connector, run the following command.

    $ tsm pending-changes apply

Verify the Connector Installation

To verify if the Couchbase Tableau Connector is installed correctly:

  1. Log in to Tableau Server.

  2. Go to Home  New Workbook  Connect to Data  Connectors.

Here, you should now see the option to select Operational Insights by Couchbase.

Configure SSL Certificates for Tableau Server

If you use a certificate from a trusted public certificate authority (CA), no manual SSL configuration is required.

If you use a certificate from a private CA or require client certificate authentication, you must configure a properties file as follows.

  1. Create a file named couchbase-operational-insights.properties and save it in the following directory:

    Windows

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

    Linux

    Save the file to /var/opt/tableau/tableau_server/data/tabsvc/vizqlserver/Datasources/

  2. To trust a certificate from a private CA, specify the path to the certificate using sslCertPath.

    The certificate must be a PEM-encoded file. sslCertPath replaces the default trust store instead of adding to it.

    sslCertPath=<path to your PEM-encoded CA certificate>
    The connector does not support the sslKeystorePath and sslKeystorePassword properties and ignores them if specified.
  3. To authenticate using a client certificate, configure either PEM files or a keystore.

    PEM Files
    clientCertPath=<path to client certificate pem>
    clientKeyPath=<path to client key pem>
    # Optional; required only if the private key is encrypted
    clientKeyPassword=<private key password>
    Keystore
    clientCertKeystorePath=<path to keystore file>
    clientCertKeystorePassword=<keystore password>

    The keystore must contain exactly one entry.