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

Machiel Treffers shared this question 6 months ago
Answered

Hi all,

According to https://wiki.yellowfinbi.com/display/yfcurrent/Google+Cloud+SQL Yellowfin supports connections to Google Cloud SQL (Postgres) after loading the appropriate drivers through Plugin Manager.

Can someone please advice on which drivers to use?

Thanks!

Best regards,

Machiel

Comments (5)

photo
1

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

photo
1

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

photo
1

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

photo
1

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

photo
1

Hi Machiel,

That's great to hear!

Enjoy the rest of your week :)

Kind regards,

Chris