Show Table of Contents
When you start Tableau, you can see the file and database types that are supported by Tableau Desktop listed under Connect. Select More to see the complete list. For supported files and databases, Tableau provides built-in connectors that are built for and optimized for those data sources.
If your file or database type is not listed on under Connect, you might be able to connect to it using ODBC. ODBC (Open Database Connectivity) is a standard way to connect to a database. If the database driver you want to connect with implements the ODBC standard, you can connect Tableau to your data using the ODBC driver for your database and the Tableau Other Databases (ODBC) connector.
Note: This data source option works for Windows computers only.
To connect to your data using the ODBC driver, do the following:
Start Tableau and under Connect, select Other Databases (ODBC). For a complete list of data connections, select More under To a Server.
Enter the information required to make the connection.
If table or schema names are not listed, click the search icon or enter the name in the text box and click the search icon, and then select the name.
Important: When you use an ODBC driver to connect to a database, the outcome may vary and compatibility with Tableau Desktop features is not guaranteed.
If your connection works as you need it to, you can begin your analysis. If, however, you need to customize your ODBC connection to improve functionality and performance, refer to the articles below, under "See also."
Tableau provides limited customer support for connections using Other Databases (ODBC). Tableau supports the Other Databases (ODBC) connector functionality, for example, Support will help you with the sample code provided in Tableau documentation, or if your connection works in Tableau Desktop, but doesn't work in Tableau Server. However, Tableau does not support creating or debugging custom TDC files. For help, you can review the documentation listed under "See also," and you can submit questions and ask for help on the Tableau Developer Community forums.
Tableau and ODBC – Provides background information about ODBC, describes how Tableau determines the functionality of an ODBC driver, and lists frequently asked questions.
Customize and Tune ODBC Connections – Describes how to fine tune the ODBC connection information for improved functionality and performance.
Tableau Capability Customizations Reference – Lists customizations you can use to define which Tableau capabilities are supported by the data source.
ODBC/SQL Customizations Reference – Lists customizations that represent the parts of the ODBC and SQL standards that the ODBC driver reports supporting.