From Thursday, July, 9, 3:00 PM Pacific,
our Community site will be in
read-only mode
through Sunday, July 12th.
Thank you for your patience.

How to use the tssh component

Highlighted
Four Stars

How to use the tssh component

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? 

Tags (1)
Highlighted
Moderator

Re: How to use the tssh component

Hello,

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.

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Highlighted
Six Stars

Re: How to use the tssh component

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.

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog