I am trying to move mysql db's, but when i try to add tMySqlInput and fill in the user name, password and database name, i get this error :-
Exception in component tMysqlInput_2
I have already tried adding the missing jar (mysql-connector-java-5.1.22). to TOS-BD/lib folder, i tried adding the jar by manually pasting it in the lib folder, and also through the add module functionality.
I checked some of the other question on the forum related to the same error, and just want to add that using TOD-DI is not really an option for me, as we are trying to move the database from mysql to redshift, which is not available in TOS-DI. When i click on guess schema for the db connection, i get an error saying db connection failed :-
Database connection is failed.
We are trying to move our databases from mysql to Amazon Redshift using talend. Is there a work around for it using talend 5.2.2.
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.