postgreSQL, Apps Script & datastudio

[Emeric HOCHART]

Hello !

Is it possible to connect to a database postgreSQL ? 

Otherwise

I know that's possible to connect to a database postgreSQL with datastudio. 

Can we get the datas catched from datastudio with GAS ?

[Dimu Designs]

Currently, the closest you can get to native support for PostgreSQL on Google's Cloud Platform is Cloud PostgreSQL, but its still in beta and last I checked it is not natively supported by Apps Script's JDBC API (at least not yet). 

However, its possible set up a Google Cloud function to act as an intermediary between Apps Script and your PostgreSQL database. But you'll have to create a custom community connector to integrate it with Datastudio.

[Alex]

Hi!

As I can understand your DB have to have JDBC connection property. If it is installed/enabled you can connect to the DB via jdbc.

Best, Alex.

[Dimu Designs]

@Alex Unfortunately, Apps Script's JDBC API does not natively support PostgreSQL...see documentation.

[Emeric HOCHART]

There is an npm module which allows you to connect to a database in postgresql.

https://www.npmjs.com/package/pg

It seems to me that we can integrate npm modules into an apps script project

Do you think that in theory I could then establish a connection using this npm module directly in a server-side script?

[Wilson Galter]

Interesting topic. I have not tried this yet but I will soon.
Maybe this article coul help us.
https://www.cdata.com/kb/tech/postgresql-odbc-mysql-apps-script.rst

[Emeric HOCHART]

I know this link. Unfortunately it requires using SQL Gateway for PostgreSQL.

I try to use the npm pg module and I come back to you but I already have several errors related to the dns in particular.

Le mardi 17 décembre 2019 13:55:32 UTC+1, Emeric HOCHART a écrit :

[Alex]

@Dimu thank you!

[Aume RRPMP]

Hi, I found this group convo and I was wondering if someone could recommend an up to date path towards querying postgres data into a app script.

Thank you in advance.