CODEWITHSUNDEEP
postgresqlssllooker-studio
Thomas Beauvais
Thomas Beauvais

Reputation: 1656

How to connect a Google Data Studio Data Source to Azure Postgres with SSL

There are not really good tutorials on Google Data Studio to use SSL with non-Google setups.

Azure is even less documented.

I found this for Azure. https://learn.microsoft.com/en-us/azure/postgresql/concepts-ssl-connection-security

There they provide the sslrootcert for the server BaltimoreCyberTrustRoot.crt.pem for download.

This doesn't help with the setup of the Data Source. Where normally I would expect a SSL = true feature, Google Data Studio requires a full certificate offering rather than figuring it out itself.

There are no useful error messages.

Flipping of SSL on the Postgres server works just fine.

Upvotes: 1

Views: 1379

Answers (1)

Thomas Beauvais
Thomas Beauvais

Reputation: 1656

After a few hours if trial and error and reading outdated forum posts, I have realized that Google Data Studio is just asking for a client key. You can really use whatever you want.

I followed the instructions on this post Heroku Postgresql with Google Datastudio

openssl req -newkey rsa:2048 -nodes -keyout client.key -x509 -days 365 -out client.crt

enter image description here

Then it will export a client.crt and a client.key that you can upload to the Google Data Studio. This is along with the BaltimoreCyberTrustRoot.crt.pem that was referenced in the Azure documentation.

NOTE you will want to create a new/unique client.crt and client.key for each Data Source.

Upvotes: 3

Related Questions