topic Re: MySQL db Connections in Talend Studio

MySQL db Connections

Anonymous — Mon, 04 Mar 2019 14:36:42 GMT

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.

Re: MySQL db Connections

Anonymous — Mon, 04 Mar 2019 15:50:08 GMT

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/80247

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 🙂

Re: MySQL db Connections

Anonymous — Sun, 05 Apr 2020 20:23:15 GMT

this answer is a tunnel

Re: MySQL db Connections

Anonymous — Sun, 05 Apr 2020 20:46:43 GMT

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/