KNOWLEDGE BASE

Using a .tdc File with Tableau Server


Published: 24 Jul 2014
Last Modified Date: 08 Jan 2019

Question

How to use a .tdc file with Tableau Server.
 

Environment

  • Tableau Server

Answer

Important: Tableau does not test or support .tdc files. These files should be used as a tool to explore or occasionally address issues with your data connection. Creating and maintaining .tdc files requires careful manual editing, and there is no support for sharing these files.
  1. 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.
  2. Name the file odbc-sqlite.tdc and save it to the following location:

For Windows:

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:

ProgramData\Tableau\Tableau Server\data\tabsvc\vizqlserver\Datasources

To save the file, you must be a Windows Administrator on the server computer.

For Linux:

/var/opt/tableau/tableau_server/data/tabsvc/vizqlserver/Datasources/

Note: The file must be saved using a .tdc extension, but the name does not matter. The .tdc file must be saved on all server nodes for consistent behavior.
 
3. Restart Tableau Server to apply the change.

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 LOCATIONEXAMPLE OF RECORD
C:\ProgramData\Tableau\Tableau Server\data\tabsvc\vizqlserver\LogsFound matching TDC 'C:\\ProgramData\\Tableau\\Tableau Server\\data\\tabsvc\\vizqlserver\\Datasources\\odbc-sqlite.tdc for class='genericodbc', vendor='SQLite', and driver='SQLite3 ODBC Driver'

Additional Information

  • 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... Feedback Forum
Did this article resolve the issue?