topic Re: Simple solution for connecting to a Postgres database over ssh tunnel in Talend Studio

Simple solution for connecting to a Postgres database over ssh tunnel

suttong — Sat, 16 Nov 2024 01:51:32 GMT

Hi There,

I need to use a tunneled ssh connection from our lan to the remote database in aws. It seems that the Talend connection component (metadata>database connections>) does not include a simple interface for creating a tunneled connection. Given tunneled connections are a common security requirement (particularly when database is hosted in aws) I would have thought there is a very simple solution? Can anybody provide a simple config solution to allow me to define a tunneled connection in Talend Open Studio (Version: 7.2.1)?

For example. See attached. This is how I connect to database using a tunnel in dbvis. Surely it's this simple in Talend right?

Thanks

Glenn

Re: Simple solution for connecting to a Postgres database over ssh tunnel

manodwhb — Wed, 05 Aug 2020 02:44:37 GMT

@Glenn Sutton , since when your job run on AWS server you no need to connect to tunnel,since that data base would be local to that AWS server. when you are running your running from you local machine, you can connect to using command prompt to o connect that DB using SSH command . you can specify the user and password same but port if your using forward post that you need to specify as a port and host would be 127.0.0.1

the above way i have connected and working fine from local talend.

Thanks,

Manohar

Re: Simple solution for connecting to a Postgres database over ssh tunnel

suttong — Mon, 10 Aug 2020 23:33:05 GMT

Thanks Manohar!

Here's what I did.

1. Created a tunneled connection using pUtty with particulars

Host Name: <my Amazon application server host>

Port: 22 (ssh)

Auth: (selected my private key location here

Tunnels:

Source Port: 19999 (nominal - pick one > 19000)

Destination: <my Amazon database server - RDS instance>:<port> (postgres was 5432 e.g. <my database server name>:5432

2. Start the tunnel

3. Logon to host using my linux account and paraphrase for my private key

4. In Talend specify the connection as:

Host: localhost

Port: 19999

The rest of the database connection particulars as normal

All good!

Next step is for me to see if I can use a Talend job to start the tunnel before any other job runs. For now, I just start the tunnel in pUtty and then define connections (as above) and/or run my Talend jobs.

Thanks for your help.

Re: Simple solution for connecting to a Postgres database over ssh tunnel

HChandran1595899298 — Sat, 28 Aug 2021 10:29:19 GMT

could you help with some screenshots how it got configured? I am trying to connect hadoop cluster using ssh tunnel, but not able to connect from talend.