I am trying to run an stand-alone job on an EC2 instance, which needs to connect to database through ssh tunneling.
Any guide on how to use the tssh component for this?
Are your ssh host and DB server on the same machine?
Here is a document that Karaf pertains ssh:TalendHelpCenter:Connecting and disconnecting remotely
Hope it will help.
You can refer to https://stackoverflow.com/questions/53941259/talend-tsshtunnel-usage/55346159#55346159 for a complete explanation I posted today.
A question for the Talend team : this is a pretty common use case; can we see in the short term a correction for the error below?
javax.crypto.ShortBufferException: Cannot store MAC in output buffer
This is triggered by a long URL (as is the case for RDS databases) in the 'L Tunnel String' field for the tSshTunnel component. A workaround is to find the database server URL in the ec2-xx-xx-xx-xx format, which involves the use of tracing tools and is not a good solution as the IP addresses are normally dynamic.
Watch the recorded webinar!
Create systems and workflow to manage clean data ingestion and data transformation.
Introduction to Talend Open Studio for Data Integration.
Test drive Talend's enterprise products.