Tableau Connector

A Dremio user must install the Dremio Tableau Connector to allow the transfer of data between services. This is accomplished one of two ways: through the Tableau Marketplace (recommended) or via manual installation using the process described below.

NOTE

This is the recommended process for configuring Dremio to interface with Tableau. If you’re using a version of Tableau earlier than the one specified below, you’ll need to follow this process to add the Tableau connecter for Dremio.

Prerequisites:

  • Tableau Desktop 2019.4 or later
  • Java 8 Runtime

Configuring the Tableau Connector

In order to successfully integrate Tableau with your Dremio server and view datasets with Tableau Desktop, the following steps must be completed as part of the initial configuration process.

  1. Download the Dremio Tableau SDK connector.
  2. Move the connector .taco file to the following location:
    • MacOS: ~/Documents/My Tableau Repository/Connectors/
    • Windows: /My Documents/My Tableau Repository/Connectors/
    • Linux: /My Tableau Repository/Connectors/
  1. Download the Dremio JDBC driver, or copy it from your Dremio installation at $DREMIO_HOME/jars/jdbc-driver/dremio-jdbc-driver-<version>.jar.
  2. Create the following directory if it does not already exist:
    • MacOS: ~/Library/Tableau/Drivers/
    • Windows: /Program Files/Tableau/Drivers/Dremio/
    • Linux: /opt/tableau/tableau_driver/jdbc/
  1. Move the .jar file to one of these locations on your operating system.
  2. Restart Tableau.

You may now add Dremio as a connector from the Tableau Desktop interface.

Enabling the Dremio Connector in Tableau

If you would like to connect to your Dremio datasets from Tableau, perfor the following steps.

  1. Open Tableau Desktop.
  2. Select the More… button below the To a Server section on the left-hand menu bar.
  3. Select Dremio by Dremio.
  4. Click Install. This adds Dremio as an option.
  5. Click Dremio Connector by Dremio.
  6. In the dialog window that displays, provide the following information:
    • Under Server, the Dremio DNS configured on your system
    • Under Port, the value 31010
    • Under Username and Password, your Dremio credentials
  1. Select the Require SSL option if you are configured for secure connections. The steps for setting up SSL are outlined in the next section below.
  2. Click Sign In.

Your Dremio datasets may now be accessed from Tableau Desktop.

Enabling SSL for MacOS

If you’ve enabled SSL/TLS for JDBC connections for your Dremio server, additional steps must be performed to fully enable secure communications.

  1. Obtain the certificate from your Dremio server.
  2. Install the certificate in the cacerts truststore, which comes with your Java 8 runtime.
    • The location of the truststore is typically $JAVA_HOME/jre/lib/security/cacert/.
    • To install the .der certificate, perform a command like the following:
sudo keytool -importcert -alias dremio -keystore $JAVA_HOME/jre/lib/security/cacerts -storepass changeit -file /path/to/dremioServerCert.der
  1. Verify that the certificate has been added.
keytool -keystore cacerts -storepass changeit -list | grep -A1 dremio
dremio, Dec 16, 2019, trustedCertEntry,Certificate fingerprint (SHA1): 2B:2B:F6:D4:79:64:33:59:AB:43:3E:D9:17:C9:FD:A7:5E:C1:6D:42

Once complete, you must ensure that the Require SSL option is selected when adding your Dremio server to Tableau Desktop.

Troubleshooting Tableau Client Connections

Dremio users may need to perform one of the following workarounds if they are using the specified version of Tableau to access a Dremio deployment.

Tableau 2019.4

Start Tableau from the command line with the -DDisableVerifyConnectorPluginSignature=true option. For example:

cd /Applications/Tableau Desktop 2019.4.app/Contents/MacOS
./Tableau -DDisableVerifyConnectorPluginSignature=true

Tableau 2020.3

If you are running Java v9+, set the following environment variable on the machine running Tableau:

JAVA_TOOL_OPTIONS=-Dcdjd.io.netty.tryReflectionSetAccessible=true