Dremio Tableau (macOS) integration requires:
Copy the .tdc
file at: /Library/Dremio/ODBC/Resources/DremioConnector.tdc
into
~/Documents/My Tableau Repository/Datasources
.
More information on managing .tdc
files can be found on
Tableau’s website.
The following instructions are used to make a connection from Dremio to Tableau and open a specific dataset in Tableau.
In the Dremio UI, click on the dataset that you want to work with.
From the dataset’s Action dropdown menu, select Analyze With > Tableau.
This action downloads a file.
Click on the file that just downloaded and enter your Dremio credentials.
Your virtual dataset is now viewable in Tableau.
The following instructions are used to make a connection from Tableau to Dremio.
Open the Tableau Desktop, select Add Connection.
Select Other Databases (ODBC) as the connection type for a new connection.
In the popup configuration menu, provide:
Press Sign In.
Press Enter in the text field of the next screen’s Schema dropdown to see what’s available to explore on your cluster.
Your Dremio datasets are now accessible from within Tableau.
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.
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.
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
SSL=1;DisableHostVerification=1;DisableCertificateVerification=1;UseExactTLSProtocolVersion=1;TLSProtocol=tlsv12