KNOWLEDGE BASE

How to connect to PostgreSQL via SSH from Tableau Desktop


Published: 25 Nov 2020
Last Modified Date: 25 Nov 2020

Question

How to connect to PostgreSQL via SSH from Tableau Desktop

Environment

  • Tableau Desktop
  • PostgreSQL

Answer

The answer is that two tunnels need to be built, first an SSH tunnel from localhost to server, and then from the server port to the database port. A possible solution is to set up an SSH tunnel like this: 5432:localhost:5432 username@hostserverdomain

The first 5432 is the local port(Tableau or PGAdmin), the second localhost actually refers to the server(because once log in localhost means the server itself), the second 5432 is the database on the server. And in order to get access to the database, one has to log in to the server that hosts the database. The above is just the syntax to connect through two tunnels using SSH.
 

Did this article resolve the issue?