KNOWLEDGE BASE

How To Use Tdc To Connect To Ssl Enabled Databricks Data Source


Published: 13 May 2021
Last Modified Date: 14 May 2021

Question

How to use tdc to connect to ssl enabled Databricks data source.
Entering certificate path every time user connects to data source is not desired. tdc is a preferred option to enter ODBC options.  

Environment

  • Tableau Server
  • Tableau Desktop
  • Databricks

Answer

New versions of Tableau like 2021.1 provides "Advanced" option to enter extra ODBC options such as ssl and certificate path. 
For versions that do not have this feature or if using tdc file is preferred, the following tdc files can be used as template and copied to Datasources paht in Tableau Desktop or Server:

<?xml version='1.0' encoding='utf-8' ?>
<connection-customization class='databricks' enabled='true' version='10.4'>
  <vendor name='databricks'/>
  <driver name='databricks'/>
  <customizations>
    <customization name='odbc-connect-string-extras' value='SSL=1;TrustedCerts={file path}' />
  </customizations>
</connection-customization>



Example of {file path} can be C:\Tableau\DatabricksCert\databricksSSL.cer
Run as user account in Tableau server should have access to certificate location.


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