You should have an idea of how you need to adjust your ODBC connection to perform as you expect in your environment. The following articles contain a complete reference for the customizations. You can use customization to modify and shape Tableau's behavior when connecting to an ODBC data source. The list of customizations might be incomplete or incorrect. These customizations represent the values that Tableau was able to detect by querying the driver when you connected. The saved data source file contains examples of both types of customizations. These customizations are made of name/value pairs, with the names following a convention of CAP_ for Tableau capabilities and SQL_ for the SQLGetInfo API calls. Tableau permits two types of customizations: Tableau-specific capabilities, and ODBC API calls to SQLGetInfo. Tableau uses this information to associate a specific connection customization with a The connection customization section begins with the names Tableau detected for the ODBC driver and theĭatabase vendor. Within the section, find the element, which contains elements that you can edit. This is an XML document describing the SQLite connection to the Northwind Orders table. Or Users\\Documents\My Tableau Repository (Beta)\Datasources By default, the file you created above is named and is in the following path: Users\\Documents\My Tableau Repository\Datasources Open the saved Tableau Data Source (TDS) file in a text editor to view its XML structure. Now you can open the TDS file to examine the SQLite connection. Select Data > Orders > Add to Saved Data Sources.Ĭlose the workbook. For more information, see How Tableau determines the capabilities of the ODBC driver. You can review the details or dismiss the dialog box and continue. On the data source page, in the Table text box, enter Orders.ĭrag the Orders table to the canvas, and then click the sheet tab.Ī "Tableau identified limitations for the ODBC data source" dialog box opens. Next to the Database Name text box, click Browse, navigate to the location of your Northwind.sl3 file, and then click Open.Ĭlick OK to close the dialog box, and then click Sign In. Under Connect Using, select Driver, and then from the drop-down list, select SQLite3 ODBC Driver. 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. 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. 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 Comments
Leave a Reply. |