Simple solution for connecting to a Postgres database over ssh tunnel
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?
@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.
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.
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.
