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.
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables