Which driver to use for connecting to PostgreSQL on Google Cloud SQL?

Hi Machiel,

You may want to refer to this document that covers driver connectors for Cloud SQL: https://cloud.google.com/sql/docs/mysql/connect-connectors

Specifically you'll want to upload a JDBC type plugin to Yellowfin's plug-in manager.

Kind regards,

Chris

Hi Chris,

Thanks for your reply. I did try the "cloud-sql-jdbc-socket-factory" driver, which seems to work fine indeed. But after uploading, it didn't enable the "Google CloudSQL" option under "Database type".

That got me in doubt a little on whether I was actually using the appropriate driver.

Best regards,

Machiel

Hi Machiel,

Apologies if there was some confusion here. From following through the link on Google's website for the JDBC driver, it links to a Github page that states you need the MySQL to JDBC driver, which you can find here https://dev.mysql.com/downloads/connector/j/

I tested this myself by downloading and adding it as a plugin and Google Cloud SQL is now available as a datasource option.

Kind regards,

Chris

Hi Chris,

No problem, I got the "cloud-sql-jdbc-socket-factory" driver working, using "Generic JDBC data source".

Thanks for your help!

Best regards,

Machiel

Hi Machiel,

That's great to hear!

Enjoy the rest of your week :)

Kind regards,

Chris