Hi Team,
In our team we are planning to use JDBC Multitable Consumer for DB2 database to implement CDC ,does JDBC Multitable Consumer works for DB2 or is there any other origin that supports DB2 connectivity.
Thanks,
Rani!
Solved
JDBC Multitable Consumer for DB2 Database
- Roadie
- 7 replies
Best answer by Dimas Cabré i Chacón
JDBC Multitable origin supports DB2, as it relies on standard JDBC.
- StreamSets Employee
- 38 replies
- Answer
JDBC Multitable origin supports DB2, as it relies on standard JDBC.
- Fan
- 2 replies
Dimas Cabré i Chacón wrote:
JDBC Multitable origin supports DB2, as it relies on standard JDBC.
- StreamSets Employee
- 38 replies
You would only need to add proprietary IBM DB2 JDBC drivers (https://www.ibm.com/support/pages/db2-jdbc-driver-versions-and-downloads). Please choose db2jcc4.jar as Data Collector runs on Java 8. JDBC drivers are usually back-compatible. Thus, you can either pick driver for your specific IBM DB2 version, or the latest version. In some situations you might need additional IBM jar files, but normally this is not necessary. If you encounter any issue related to missing classes, you should check IBM’s official documentation for additional potentially missing JARs.
- Fan
- 2 replies
Dimas Cabré i Chacón wrote:
You would only need to add proprietary IBM DB2 JDBC drivers (https://www.ibm.com/support/pages/db2-jdbc-driver-versions-and-downloads). Please choose db2jcc4.jar as Data Collector runs on Java 8. JDBC drivers are usually back-compatible. Thus, you can either pick driver for your specific IBM DB2 version, or the latest version. In some situations you might need additional IBM jar files, but normally this is not necessary. If you encounter any issue related to missing classes, you should check IBM’s official documentation for additional potentially missing JARs.
Thanks Dimas for your prompt response. Will check it out.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.