Migrate IBM DB2 Db to Mongo DB using Talend. Is it possible? Need advise and pointers

[Anonymous]

I am trying to migrate IBM DB2 tables from a schema, can it dynamically pick tables from Soruce DB and create a collection and build a schema in Mongo DB.

I tried to transfer data from a specific table to mongo db that is working fine if I predefine my schema from DB2, if not no data is transferred

Requirement is like i need to fetch schema and table name dynamically and create a collection name in Mongo db.

Need advise and inputs on its feasibility.

[Anonymous]

Thanks for the reply, I will try these steps and let u know how it pans out.

[Anonymous]

Hi ,

I am trying to migrate a simple db2 table in mongoDB using talend. Getting an error message in tdb2input component. 

Exception in component tDB2Input_1
com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-551, SQLSTATE=42501, SQLERRMC=DB2ADMIN;SELECT;PROFESSIONAL.CUSTOMER, DRIVER=4.13.127
at com.ibm.db2.jcc.am.id.a(id.java:677)
at com.ibm.db2.jcc.am.id.a(id.java:60)
at com.ibm.db2.jcc.am.id.a(id.java:127)
at com.ibm.db2.jcc.am.no.c(no.java:2653)
at com.ibm.db2.jcc.am.no.d(no.java:2641)
at com.ibm.db2.jcc.am.no.a(no.java:2090)
at com.ibm.db2.jcc.t4.cb.h(cb.java:141)
at com.ibm.db2.jcc.t4.cb.b(cb.java:41)
at com.ibm.db2.jcc.t4.q.a(q.java:32)
at com.ibm.db2.jcc.t4.sb.i(sb.java:135)
at com.ibm.db2.jcc.am.no.ib(no.java:2059)
at com.ibm.db2.jcc.am.no.a(no.java:3130)
at com.ibm.db2.jcc.am.no.a(no.java:688)
at com.ibm.db2.jcc.am.no.executeQuery(no.java:672)
at local_project.db2tomongodb_0_1.db2toMongoDB.tDB2Input_1Process(db2toMongoDB.java:964)
at local_project.db2tomongodb_0_1.db2toMongoDB.tMongoDBConnection_1Process(db2toMongoDB.java:402)
at local_project.db2tomongodb_0_1.db2toMongoDB.runJobInTOS(db2toMongoDB.java:1443)
at local_project.db2tomongodb_0_1.db2toMongoDB.main(db2toMongoDB.java:1300)
[statistics] disconnected

Please help me !

0.PNG

[vapukov]

You choose wrong forum for ask about DB2 problem 🙂

https://stackoverflow.com/questions/1588687/db2-connection-problem-with-java

http://www-01.ibm.com/support/docview.wss?uid=swg21681677

https://developer.ibm.com/answers/questions/189550/getting-sqlcode-551-sqlstate42501-in-the-log-file...

http://www-01.ibm.com/support/docview.wss?uid=swg22005935