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.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Create systems and workflow to manage clean data ingestion and data transformation.