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.