Dremio Community

Tableau Desktop (Windows)

Prerequisites

Dremio Tableau integration requires:

Configuration

64-bit

Copy the .tdc file at: C:\Program Files\Dremio Connector\Resources\DremioConnector.tdc into
C:\Users\<username>\Documents\My Tableau Repository\Datasources.

32-bit

Copy the .tdc file at: C:\Program Files (x86)\Dremio Connector\Resources\DremioConnector.tdc into
C:\Users\<username>\Documents\My Tableau Repository\Datasources.

More information on managing .tdc files can be found on Tableau’s website.

Creating a Live Connection to a Dataset from Dremio

To open a dataset in Tableau from within Dremio, you can use the Analyze button in the upper right-hand corner of a dataset view. Just follow these steps:

  1. In Dremio UI, go to a dataset you want to work with and click on the dataset.

  1. Select Tableau from the Analyze button’s dropdown menu.

  1. Click on the file that you just downloaded and enter your Dremio credentials.

  1. Dataset is ready to be used in Tableau.

How does it work?

When you click the Analyze (Tableau) button, Dremio generates a Tableau Datasource (.tds) file that represents a “live connection” to your Dremio dataset. No actual data is stored in this file, and you can think of it as a shortcut to a Tableau session with a preconfigured view of your data.

Creating a Dremio Source in Tableau

  1. Open Tableau Desktop and select Other Databases (ODBC) as the connection type for a new connection:

  1. Select Dremio Connector from the DSN dropdown and press Connect.

Your Dremio datasets will now be accessible from within Tableau. Press Enter in the text field of the next screen’s Schema dropdown to see what’s available to explore on your cluster.

Exporting a Dremio Dataset with SSL

If you have SSL enabled on Dremio, and you want to export a Dremio dataset to Tableau TDS format, you can do so by setting the export.tableau.extra-odbc-connection-properties support key in Advanced Settings. This property allows you to set the ODBC connection string when exporting a Dremio dataset to Tableau TDS format. The default is an empty string.

Availability

The export.tableau.extra-odbc-connection-properties property is available as of Dremio version 3.1.8.

To know how to set the export.tableau.extra-odbc-connection-properties support key, see Support Keys.

Changing the Hostname

You can use the export.bi.hostname support key to change the default hostname of the SQL endpoint for generating TDS files. The export.bi.hostname property is available from Dremio version 13.0.0.

To know how to set the export.bi.hostname support key, see Support Keys.

Example: SSL setting

In the following example, SSL (for generating a self-signed certificate with an ODBC/JDBC Dremio configuration) is enabled in the dremio.conf file. See Using Wire Encryption for more information.

services.coordinator.client-endpoint.ssl.enabled: true
services.coordinator.client-endpoint.ssl.auto-certificate.enabled: true

Example: export.tableau.extra-odbc-connection-properties value

SSL=1;DisableHostVerification=1;DisableCertificateVerification=1;UseExactTLSProtocolVersion=1;TLSProtocol=tlsv12