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”...
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema