KNOWLEDGE BASE

Unable to connect to Google Cloud SQL Postgres with SSL enabled


Published: 22 May 2019
Last Modified Date: 27 Jul 2021

Issue

Unable to connect to Google Cloud SQL Postgres with SSL enabled

 

Environment

  • Tableau Desktop 
  • Google Cloud SQL Postgres

Resolution

1. Download the Server-ca, the Client Certificate and Client Key from Google Cloud SQL Postgres Database
2. Copy the attached TDC file to "My Tableau Repository/Datasources"
3. Edit the TDC file to configure correctly the path to the downloaded Certificate files (please note that a double backslash is required)
4. Connect from Tableau Desktop using the Postgres native connector
 

Cause

When SSL is enabled in Google Cloud SQL, it requires a mutual SSL handshake, therefore Tableau Desktop is requested to provide the Client Certificate.

Google Cloud SQL connector allows to add the Client Certificate but it uses the MySQL driver, even when connecting to Postgresql via port 5432
The Tableau Desktop Postgres native connector does not allow to add the client certificate.
Did this article resolve the issue?