'how to connect with a live database in tableau using ssh tunneling?
I have a PostgreSQL database hosted in private network. i have bastion id, username ,database credentials. how can I connect the database with tableau using ssh key? so far i did not find any viable solution for this problem. I need a solution where tableau with get connected with the database and get live data.
Solution 1:[1]
If Tableau doesn't have integrated tools to create the tunnel (and as far as I know it doesn't) then you can create a tunnel yourself using ssh or putty or some python module, for example. Then tell Tableau Desktop to connect to the database at the address of the local end of the tunnel, likely 127.0.0.1:5432.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | jjanes |