Pls can anyone help with the process of using the tMySqlInput to connect to a database via SSH connection.
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
of course you must have installed/enabled ssh command in case of Windows machine if choose command-line (tSystem) way
Try Talend Cloud free for 30 days.
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.