https://community.qlik.com/t5/Talend-Studio/How-to-create-DB-Connection-over-SSH/m-p/2363681#M127529 <P>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?<BR />Thnx Remco</P> Tue, 07 Jul 2015 13:12:18 GMT Remco1 2015-07-07T13:12:18Z https://community.qlik.com/t5/Talend-Studio/How-to-create-DB-Connection-over-SSH/m-p/2363681#M127529 <P>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?<BR />Thnx Remco</P> Tue, 07 Jul 2015 13:12:18 GMT https://community.qlik.com/t5/Talend-Studio/How-to-create-DB-Connection-over-SSH/m-p/2363681#M127529 Remco1 2015-07-07T13:12:18Z https://community.qlik.com/t5/Talend-Studio/How-to-create-DB-Connection-over-SSH/m-p/2363682#M127530 hi,<BR /><BR />I use putty to forward port throught ssh connection&nbsp; and query 'normally' in Talend.<BR /><BR /><IMG src="https://community.talend.com/legacyfs/online/1813/1.png_20150707-1449.png" /><BR /><BR />queries on port 9999 will be redirect via ssh tunnel to port 3306.<BR />So in Talend component you indicated port = 9999<BR /><BR />hope it help Tue, 07 Jul 2015 13:54:00 GMT https://community.qlik.com/t5/Talend-Studio/How-to-create-DB-Connection-over-SSH/m-p/2363682#M127530 Anonymous 2015-07-07T13:54:00Z