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.
Join us at the Community Lounge.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Learn how to make your data more available, reduce costs and cut your build time
Read about OTTO's experiences with Big Data and Personalized Experiences
Take a look at this video about Talend Integration with Databricks