Customizing JDBC Connections
Published: 06 Feb 2018
Last Modified Date: 09 Sep 2020
QuestionSome Tableau named connectors, such as Amazon Athena and SAP HANA, use the JDBC standard instead of ODBC. There are two ways to connect using JDBC, Use a TDC file, or Use a PROPERTIES file.
How can users modify JDBC connections and gather driver logs?
- Tableau Desktop
- Tableau Server
- Amazon Athena
- SAP HANA on Mac OS X
AnswerJDBC connection options can be modified through the use of a .properties file. This is a plain text document containing key-value pairs for each connection parameter. However, please note that this file should not be saved in a UTF-8 with BOM character encoding - this encoding adds characters to the beginning of a file and interferes with Tableau applying the customizations.
Each key-value pair should be on its own line with no delimiter - refer to the examples attached to this article. After saving the document as either saphana.properties or athena.properties (as appropriate), place it in the My Tableau Repository/Datasources folder.
To enable a .properties file for Tableau Server, it must be place on all Server nodes in the following directory:
Further connections to that data source type will have the option values included in the query URL.
- tabsvc/vizqlserver/Datasources for Windows
- /var/opt/tableau/tableau_server/data/tabsvc/vizqlserver/Datasources/ for Linux