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.
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.
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.
.tacofile to the following location:
~/Documents/My Tableau Repository/Connectors/
/My Documents/My Tableau Repository/Connectors/
/My Tableau Repository/Connectors/
.jarfile to one of these locations on your operating system.
You may now add Dremio as a connector from the Tableau Desktop interface.
If you would like to connect to your Dremio datasets from Tableau, perfor the following steps.
Your Dremio datasets may now be accessed from Tableau Desktop.
If you’ve enabled SSL/TLS for JDBC connections for your Dremio server, additional steps must be performed to fully enable secure communications.
cacertstruststore, which comes with your Java 8 runtime.
.dercertificate, 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
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.
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.
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
If you are running Java v9+, set the following environment variable on the machine running Tableau: