How do I use Tableau to connect to my database using SSL?
This document only applies to customers that have enabled SSL on their account. Click HERE for information on enabling SSL on your account.
1. What is SSL and why is it beneficial to me?
MySQL supports secure (encrypted) connections between clients and the server using the Secure Sockets Layer (SSL) protocol. SSL uses encryption algorithms to ensure that data received over a public network can be trusted. It has mechanisms to detect data change, loss, or replay. SSL also incorporates algorithms that provide identity verification using the X509 standard.
SSL should be used anywhere where you are communicating information that should not be public. The security of your data can be compromised easily if someone is listening to traffic between your computer and the remote server. SSL works to solve that problem.
2. Download the SSL cert files for your account:
Click HERE for a tutorial on how to download your SSL certification files.
3. Create a new ODBC Connection in Tableau 9
3.1. Under 'More Servers' Select 'Other Databases' (ODBC)
4. Select 'MySQL' from the 'Driver' dropdown.
5. Expand the 'Details' menu
6. Select the 'SSL' tab
7. Set SSL Certificate Authority File.
7.1. Browse for Certificate Authority File by clicking '...' button beside 'SSL Certificate Authority'.
7.2. Select file ending in '_ca.pem' and click 'Open'.
8. Set SSL Client Certificate File.
8.1. Browse for Client Certificate File by clicking '...' button beside 'SSL Certificate'.
8.2. Select file ending in '_cc.pem' and click 'Open'.
9. Set SSL Client Key File.
9.1. Browse for Client Key File by clicking '...' button beside 'SSL Key'.
9.2. Select file ending in '_ck.pem' and click 'Open'.
10. Verify that configuration is correct by clicking 'Test'.
*Note that you will be prompted for your Password, it is the same as your login password.
11. If you have set up everything correctly you should receive a message stating that the test was successful.
Click 'OK' to close message.