Tableau-supported connector (Link opens in a new window), you can click the name of that connector to create a connection. On the start page under Connect, click Other Databases (ODBC). To create an ODBC connection, you connect to the Northwind database using the SQLite3 ODBC driver, and then save the connection as a Tableau Data Source (TDS) file.
#Tableau mac odbc install#
Download and install the following (select the SQLite 2 drivers):Ī sample SQLite database created from the Microsoft example Northwind database.
The SQLite 32-bit ODBC driver (required for 32-bit or 64-bit Windows). This example is not an endorsement of this product over any other competing products. You need to download the following two items:ĭisclaimer: This information refers to a third-party product. The ODBC connection in this article is based on SQLite ( ), an open-source database. In the example, you connect to a SQLite database using the SQLite ODBC driver.
#Tableau mac odbc how to#
This section shows you how to create an ODBC connection using an example. Note: Tableau will provide reasonable levels of customer support to assist in troubleshooting connections with ODBC drivers, but can't create or customize a connector to work with a specific ODBC driver. Before you begin, you should be familiar with the content in Tableau and ODBC. In this article, you will make an ODBC connection, examine the resulting Tableau Data Source (TDS) file and use part of it to create a Tableau Data source Customization (TDC) file that you can then use to customize your ODBC connection. If a driver reports incorrect or incomplete information about the SQL dialect it supports, you can use Tableau customizations to fine tune this connection information in order to improve functionality and performance. Because Tableau has no representation of the SQL dialect used by an ODBC data source, it must infer the supported syntax through a variety of tests. When you use a connector for a database that supports SQL, Tableau generates SQL statements that are tuned for that database.
0 kommentar(er)
