Last Modified Date: 08 Jan 2019
- Tableau Server
- Using a text editor, copy and paste the entire
<connection-customization>section of your saved data source file. For reference, see the Sample SQLite TDC file.
Name the file
odbc-sqlite.tdcand save it to the following location:
In Tableau Server versions prior to 2018.2:
Program Files\Tableau\Tableau Server\<version>\bin
Starting in Tableau Server version 2018.2:
Program Files\Tableau\Tableau Server\packages\bin.<build number>
Or for all Tableau Server versions:
To save the file, you must be a Windows Administrator on the server computer.
.tdcextension, but the name does not matter. The
.tdcfile must be saved on all server nodes for consistent behavior.
4. In Tableau Desktop, create a new connection to SQLite as described in Create a connection.
5. Go to and open the Tableau Server log file, and look for a record similar to the example below to verify that this customization file was applied to your new connection.
|LOG FILE LOCATION||EXAMPLE OF RECORD|
|C:\ProgramData\Tableau\Tableau Server\data\tabsvc\vizqlserver\Logs||Found matching TDC 'C:\\ProgramData\\Tableau\\Tableau Server\\data\\tabsvc\\vizqlserver\\Datasources\\odbc-sqlite.tdc for class='genericodbc', vendor='SQLite', and driver='SQLite3 ODBC Driver'|
- A .tdc file must be placed on each computer running vizqlserver or backgrounder (if applicable for extract refreshes).
- The bin directory is checked first, and then the Datasources directory.
- A .tdc file in the Datasources directory will override one in the bin directory.
- A backup does not back up .tdc files.
- A restore deletes existing .tdc files.
- A .tdc file in the bin folder will not be retained across an upgrade because the bin directory is removed during uninstall.
- A .tdc file in the Datasources folder will not be retained across upgrades because a restore is part of the upgrade process.
- The .tdc file used in Tableau Desktop should be uploaded to Tableau Server without changes. Non-matching .tdc files will cause errors and will not work correctly.
Discuss this article...