1

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.

Improve this question

1 Answer 1

Reset to default
3

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.

Improve this answer
Sign up to request clarification or add additional context in comments.

2 Comments

Also, for others who still struggle with this, make sure you added the GDS ip addresses to your firewall. support.google.com/datastudio/answer/…
Hey, is this currently still working for you? I get errors with the Server cert which is supposedly replacing the Baltimore one. :/

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.