How to Set SSL When Connecting to MySQL in Tableau Prep

Published: 04 Feb 2022
Last Modified Date: 05 Feb 2022


How to set SSL when connecting to MySQL in Tableau Prep?
SSL checkbox did not appear in the login window in Tableau Prep.

User-added image


However, the "Require SSL" option appears in Tableau Desktop.


User-added image


  • Tableau Prep Builder
  • MySQL


SSL is not supported in Tableau Prep for now.
Consider the possible workaround: Use an xml TDC file to set SSL.

The steps are as follows:
1. Close Tableau Prep, create a text file with the following contents, and rename the file to "mysql.tdc". (Bolded parts need to be changed).
    Note1: The "version" is the version of the MySQL driver installed on your terminal.
    Note2: The "value" is the SSL information you need to add.

<?xml version='1.0' encoding='utf-8' ? >
<connection-customization class='mysql' enabled='true' version='8.0.27'>
<vendor name='mysql' />
<driver name='mysql' />
<customization name='odbc-connect-string-extras' value='SSLKEY={C:\MySQL_SSL\client-key.pem};SSLCERT={C:\MySQL_SSL\client-cert.pem};SSLCA={C:\MySQL_SSL\ca-cert.pem}'/>'

2. Move "mysql.tdc" to "C:\ Users\<UserName>\Documents\My Tableau Prep Repository\Datasources".

3. Open Tableau Prep and connect to MySQL.
    Note: Tableau does not test or support .tdc files. 

Did this article resolve the issue?