Last Modified Date: 25 Nov 2020
- Tableau Desktop
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.