Connecting Tableau to TDV Using ODBC
Connecting to TDV Server through Tableau varies depending on the development tool used to develop your client application. Typically, all you need to do is install and use ODBC to establish the connection.
These instructions are included as a guideline; your system and the necessary steps might vary. Refer to your development tool documentation and perform thorough testing of your system after establishing the connection between TDV Server and Tableau.
Tableau connects to TDV through the TDV ODBC driver.
Limitations
For the greatest amount of flexibility, TDV supports the standard SQL functions. Because Tableau supports several custom non-standard SQL functions, you might not be able to run certain functions against your TDV data that is displayed in Tableau.
TDV supports using CAST(TIME as TIMESTAMP). The date 1900-01-01 will be added to the TIME so that the TIME value can qualify as a TIMSTAMP data type. For example, if your time value is 12:05, your converted TIMSTAMP will be 1900-01-01 12:05.
To connect TDV to Tableau using an ODBC 32-bit driver
1. Install the 32-bit TDV ODBC driver on the same system that Tableau machine.
The 32 bit ODBC manager is typically located in the %WINDIR%\sysWOW64 folder and named odbcad32.exe. For more information, see
Installing the ODBC Driver.
Tableau allows for the customization of the ODBC connection. Those instructions are at: http://kb.tableau.com/articles/knowledgebase/customizing-odbc-connections. There are two TDC files that install with TDV, their default location is <TDV_install_dir>\docs\tableau.
3. Launch Tableau and login.
4. Click Data > Connect to Data.
5. Click Other Databases (ODBC).
6. Select or type the DSN that was defined for TDV. For example, select for_tableau_system.
7. Click Connect.
Resources and data published through TDV should be viewable through your Tableau client.
For example, using the Tableau client, you can select a TDV published table and click View data to see the data displayed in Tableau.