I am trying to create a job that opens an SSH tunnel & then connects to MySQL.
The configuration of the tSSH are shown in the picture, as well as, the job format.
The issue is that I cannot connect to MySQL at the end, because the tSSH is exiting.
How do you work with this component? I couldn't find a proper guide for it.
Thanks a lot,
This is not correct usage. The tSSH component will print "Talend" and close the connection. This is expected behaviour.
Please check this component:
Hope it helps.
See the screenshots below.
Also in a review of the component is written:
...ALL field values in quotes (including password if blank, and port number), and do not include “-L” in the port forwarding - for example you can use “12345:127.0.0.1:3306”...
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.