Connecting MySQL with talend

Hi,

In this blog we are going to see how to connect MySQL with talend hope it will be useful for you guys

• Create a job in talend go to metadata 
• Right click on the Db connection and select the Create connection

• Specify the name , purpose and description

• Select the Dbtype

• Select the Db version
• Login: Mysql workbench user name 
• Password: Mysql workbench password
• Server:The server on which your Mysql workbench has been connected
• Click on the check

 

• Go to the connected DB right click on that and select the retrieve schema

• Select the table which you want to use from the database

• Click on finish

That's it guys you have connected you mysql workbench with talend. Hope this blog will be useful for you guys. Best of luck.

Regards,

Jerin P