Customizing JDBC Connections

Published: 06 Feb 2018
Last Modified Date: 07 Feb 2018


Unlike all other Tableau native connectors, the Amazon Athena connector uses the JDBC standard instead of ODBC, as does the SAP HANA connector on Mac. This means that connections cannot be customized through the use of a .tdc file and the 'odbc-connect-string-extras' parameters, nor can driver logs be gathered using the ODBC Administrator utility. JDBC connection options are usually set by appending them to the query URL, but that method is not available when connecting from Tableau Desktop.

How can users modify JDBC connections and gather driver logs?


  • Tableau Desktop
  • Tableau Server
  • Amazon Athena
  • SAP HANA on Mac OS X


JDBC 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. Each pair should be on its own line with no delimiter - refer to the examples attached to this article. After saving the document as either or (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  tabsvc/vizqlserver/Datasources directory.

Further connections to that data source type will have the option values included in the query URL.
Did this article resolve the issue?