Connecting to a mysql database via SSH

Highlighted
Four Stars

Connecting to a mysql database via SSH

Pls can anyone help with the process of using the tMySqlInput to connect to a database via SSH connection. 

Thirteen Stars

Re: Connecting to a mysql database via SSH

Hi

 

you can not do this from tMySQLInput component, but you can create ssh tunnel outside of Talend (with several gui tools) or right from Talend with tSystem component:

ssh -L 1234:localhost:3306 mysql.server.remote

after this you need use new localhost and new port (1234 in example) in tMySQLInput settings

 

UPDATE:

of course you must have installed/enabled ssh command in case of Windows machine if choose command-line (tSystem) way

-----------
Four Stars

Re: Connecting to a mysql database via SSH

Thanks for the reply.

 

However for the tSystem option will it need to be connected to the tMySqlInput ???

Thirteen Stars

Re: Connecting to a mysql database via SSH

Not exactly

Just before, for example in PreJob
-----------
Four Stars

Re: Connecting to a mysql database via SSH

Tried doing it on my system (MacOs)
did a quick connection to ssh and tried to connect to the mysql via the tmysqlinput and I got connection failed.

Cloud Free Trial

Try Talend Cloud free for 30 days.

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.