You can work with your data in Tableau through an ODBC connection.
The following procedures are written for Tableau 9. Simba ODBC drivers also support Tableau 8 and Tableau 7.
Make sure that the bitness of the driver that you are using matches the bitness of Tableau. If you are using the 32-bit version of Tableau, then you need to use the 32-bit version of the driver. If you are using the 64-bit version of Tableau, then you need to use the 64-bit version of the driver. For more information about diagnosing the issue, see Architecture Mismatch Problems.
Tableau provides native support for the Simba Spark ODBC Driver with SQL Connector. For information about using the Simba Spark ODBC Driver in Tableau, see Using the Simba Spark ODBC Driver.
For information about using any other Simba ODBC driver in Tableau, see Using Other Simba ODBC Drivers.
You can work with Spark data in Tableau by using the Spark SQL data source option, which uses the Simba Spark ODBC Driver to connect to the data store.
To connect to your Spark data store using Tableau:
By default, Spark uses port 10000.
For detailed information about configuring authentication, see the Simba Spark ODBC Driver with SQL Connector Installation and Configuration Guide.
The specified data store is loaded in Tableau. You can now use that data to create reports.
For more information about connecting to a Spark server through Tableau, see the "Spark SQL" reference topic in the Tableau online help system.
Some Simba ODBC drivers include a Tableau Datasource Connection (TDC) file for Windows that helps configure Tableau to operate more efficiently using the driver. If the installation directory of your driver contains a
.tdc file, it is strongly recommended that you install the file before using the driver in Tableau.
To install the .tdc file:
.tdcfile from the driver installation directory to the
Documents\My Tableau Repository\DataSourcesdirectory.
If you are using the Simba Drill ODBC Driver with SQL Connector, the
.tdc file can be found in the
\Resources subfolder instead of the root level of the driver installation directory.
To connect to your data store using Tableau:
When connected to a Drill data store, you can also select other data objects that are made available through your specified schema. For example, when using a DFS schema, you can select SQL views that have been created through the Drill Explorer.
Tableau retrieves the specified data and loads it into a worksheet, listing columns as dimensions or measures depending on the data type.
If you did not install a
.tdc file for the driver, then the following warning might display:
Click OK to dismiss the warning. It displays because Tableau sees only a generic driver and attempts to determine the capabilities of the driver. The warning does not affect how the driver will operate in Tableau.
You can now use your data to create reports.