MySQL db Connections

[Anonymous]

I need to create a mySql db connections.

I got the general information, e.i. host, port, database,user & password 

plus

ssh tunnel info: proxy host, proxy user & private key file. 

Could you please advise how I can create the connection using Talend Open Studio for Data Integration 7.1.1?

Thank you very much in advance and looking forward to your reply. 

[Anonymous]

Hi,

    Could you please refer one of the earlier Talend community posts?

https://community.talend.com/t5/Design-and-Development/Connect-through-ssh-tunnel-to-mysql/td-p/8024...

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[Anonymous]

this answer is a tunnel

[Anonymous]

You have to establish a ssh connection to the proxy server with a given user and the key file (you need also a passphrase for the key file).

In the configuration of the ssh connection you have to add a tunnel.

All this must be established before you start the job. The host for the MySQL server in this scenario is localhost!

https://www.howtogeek.com/168145/how-to-use-ssh-tunneling/