Connecting to a mysql database via SSH

[Anonymous]

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

[vapukov]

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

[Anonymous]

Thanks for the reply.

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

[vapukov]

Not exactly

Just before, for example in PreJob

[Anonymous]

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.