topic Re: Connecting to database via ssh in Talend Studio

Connecting to database via ssh

Anonymous — Sat, 16 Nov 2024 05:45:47 GMT

Hello, I want to connect to a database via SSH to use a mysqldump command (following this tutorial: https://help.talend.com/reader/bgDZH2_Zl1aEY93rMEYliw/tVrAjMFoQR~7HEYnaNP_pQ).

I have to connect to a remote server. How can I connect to a specific database with a tSSH component? Or is there another method to get the dump working?

I can't connect to the server directly, because this is forbidden (I think, I get an IOException saying "There was a problem while connecting to XY"). A connection to the database via tDBInput works.

Re: Connecting to database via ssh

Anonymous — Thu, 23 May 2019 15:13:20 GMT

Hi,

The steps mentioned in the backing up of MySQL need to be completed through terminal commands and you will have to use components like tSSH or tSystem.

So either you will have to get the access to the system to get exception to perform these operations or your administrators need to do this operation for you (you can create the job and give them as a shell script for execution).

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 🙂