How to create DB Connection over SSH?

[Remco1]

How can I create a mysql DB Connection over SSH so I can execute queries? I've done some testing with tSSH and can connect to the remote server over SSH but how to query the mysql server to use it in my Talend Job?
Thnx Remco

[Anonymous]

hi,

I use putty to forward port throught ssh connection  and query 'normally' in Talend.



queries on port 9999 will be redirect via ssh tunnel to port 3306.
So in Talend component you indicated port = 9999

hope it help