Heroku Postgresql与Google Datastudio [英] Heroku Postgresql with Google Datastudio

问题描述

我有麻烦将现有的heroku数据库连接到Google Datastudio。我试图添加连接，并得到以下内容：

访问被拒绝，请检查您的用户名和密码。

现在，我100％确定我对这些凭证是正确的，而问题来自其他地方。

我尝试过不同的设置，无论是免费还是付费PSQL实例，没有任何效果。

我还设置了一个虚拟帐户在 elephantsql 上，并且连接第一次无任何问题。

编辑：

刚刚找到 https：// www .en.advertisercommunity.com / t5 / Data-Studio / Heroku-Postgres-lt-gt-Google-Data-Studio / mp / 1031729 ，这在写这篇文章时没有帮助ost。

解决方案

问题是Heroku Postgres需要SSL连接，而目前Data Studio似乎不可能。希望Google能很快添加这个选项。

I'm having troubles to connect an existing heroku database to Google Datastudio. I'm trying to add the connection and I get the following:

Access denied, please check your username and password.

Now, I'm 100% sure that I'm correct on those credentials and the problem comes from somewhere else.

I've tried with different setup, either a free or a paid PSQL instance, nothing works.

I've also setup a dummy account on elephantsql and the connection worked the first time without any issue.

Do you have any idea of the cause of that problem?

Edit:

Just found https://www.en.advertisercommunity.com/t5/Data-Studio/Heroku-Postgres-lt-gt-Google-Data-Studio/m-p/1031729 which is not helpful at the time of writing this post.

解决方案

The problem is that Heroku Postgres requires an SSL connection which doesn't seem possible with Data Studio at the moment. Hopefully Google will add that option soon.

这篇关于Heroku Postgresql与Google Datastudio的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！