This article helps: Connecting to Relational Databases on Heroku with Java | Heroku Dev Center
I am able to let SquirrelSQL connect to Heroku Postgres by changing the URL to: jdbc:postgresql://<host>:5432/<db>?ssl=true&sslfactory=org.postgresql.ssl.NonValidatingFactory , which makes it connect using SSL.
Now the question becomes: How to let Tableau Desktop connect to PostgreSQL with SSL (especially Heroku Postgres)?
I have successfully connected to a Heroku Postgres database. The method I used is not officially supported by Tableau.
Try this "Quick Fix" article's suggestion of using an "Other Database Connection" (ODBC) and allowing SSL with the PostgreSQL Unicode driver:
That solution is not working for me because my (production level) Heroku Postgres database has a port other than the default and the ODBC options dialog does not seem to be editable.
Anyone gotten around this issue?
Sorry to say I don't have a solution for you Mark, but you can submit a ticket to Tableau's Support team:
I believe it might depend on which version of Tableau you're using. I believe I was able to edit the ODBC port using version 8.04. Don't hold me to that! It's been a while since I set mine up.
Although secure PostgreSQL connections aren't officially supported right now, if customers demand it it'll become a high priority for our development team. Tableau listens closely to customer feedback and feature requests -- as a Heroku user and data geek, this is a connection type I'd love to see officially supported, so I hope other users who want it are vocal about it.
I do have 8.0.4 so I will submit a support request. Thanks.