HOW TO MIGRATE A DB FROM ACCESS TO MYSQL WORKBENCH THROUGH TALEND??

Anonymous — Fri, 10 May 2019 12:14:26 GMT

Hi,

I am trying to migrate a whole DB from Access to MySQL workbench.

How to migrate DB from Access to MySQL workbench.????

And I connected both the DB connection separately and when I tried to map directly I got this error

[statistics] connecting to socket on port 3514
[statistics] connected
Fri May 10 16:32:27 IST 2019 WARN: Establishing SSL connection without the server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements, SSL connection must be established by default if an explicit option isn't set. For compliance with existing applications not using SSL the verify server certificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Exception in component tDBInput_1 (db_toDB)
net.ucanaccess.jdbc.UcanaccessSQLException: unexpected end of statement
at net.ucanaccess.jdbc.UcanaccessStatement.executeQuery(UcanaccessStatement.java:202)
at local_project.db_todb_0_1.db_toDB.tDBInput_1Process(db_toDB.java:781)
at local_project.db_todb_0_1.db_toDB.runJobInTOS(db_toDB.java:1511)
at local_project.db_todb_0_1.db_toDB.main(db_toDB.java:1362)
Caused by: java.sql.SQLSyntaxErrorException: unexpected end of statement
at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.JDBCStatement.executeQuery(Unknown Source)
at net.ucanaccess.jdbc.UcanaccessStatement.executeQuery(UcanaccessStatement.java:199)
... 3 more
Caused by: org.hsqldb.HsqlException: unexpected end of statement
at org.hsqldb.error.Error.parseError(Unknown Source)
at org.hsqldb.ParserBase.unexpectedToken(Unknown Source)
at org.hsqldb.ParserCommand.compilePart(Unknown Source)
at org.hsqldb.ParserCommand.compileStatements(Unknown Source)
at org.hsqldb.Session.executeDirectStatement(Unknown Source)
at org.hsqldb.Session.execute(Unknown Source)
... 6 more
[statistics] disconnected

Kindly get me out of this issue. Thanks in advance.

Re: HOW TO MIGRATE A DB FROM ACCESS TO MYSQL WORKBENCH THROUGH TALEND??

Anonymous — Mon, 20 May 2019 09:22:31 GMT

Hello,

Is your Access DB connection OK with you? Are you able to use tAccessInput to load your data into tLogRow instead of tMySqlOutPut?

Best regards

Sabrina

topic Re: HOW TO MIGRATE A DB FROM ACCESS TO MYSQL WORKBENCH THROUGH TALEND?? in Talend Studio

HOW TO MIGRATE A DB FROM ACCESS TO MYSQL WORKBENCH THROUGH TALEND??

Re: HOW TO MIGRATE A DB FROM ACCESS TO MYSQL WORKBENCH THROUGH TALEND??