CODEWITHSUNDEEP
db2cdcdebezium
Dan Sullivan
Dan Sullivan

Reputation: 1

Does Debezium DB2 connector support IBMi?

I am working on capturing data changes in a DB2 database running on an iSeries with IBM i operating system. The documentation notes the connector works with "Db2/Linux 11.5.0.0, but our expectation is that the model would work for Windows, AIX and zOS as well." There is no mention of IBM i. Have there been any successful uses with IBM i DB2 or would you expect it to work as well?

Thanks.

Upvotes: 0

Views: 2322

Answers (3)

Marius
Marius

Reputation: 1

Not sure if that is entirely true.

Their is open source options (in terms of a Java Plugin) that is supported. see: https://github.com/debezium/debezium-connector-ibmi?tab=readme-ov-file

Upvotes: 0

Glenn Steffler
Glenn Steffler

Reputation: 1

The Debezium connector for Db2 requires a license to IBM Data Replication to run the capture program. The capture that Debezium uses does not have an IBM i support.

Whereas IBM Data Replication itself can directly source from all Db2 varieties including IBM i, as well as many other databases such as SQL Server, Oracle, Informix, Sybase, MySQL and PostgreSQL along with mainframe IMS and VSAM.

Upvotes: 0

Sunny Patel
Sunny Patel

Reputation: 117

I'm a developer with the IBM Data Replication product.

IBM Data Replication (https://www.ibm.com/analytics/data-replication) can source from a variety of relational databases hosted on different operating systems, one of them being DB2 database running on iSeries with IBM i OS.

We have a number of clients who are leveraging this capability to produce data with high throughput to target databases as well as streaming platforms such as Apache Kafka.

Feel free to reach out to me and we can discuss how IBM Data Replication can solve your business use case.

Thanks,

Sunny

Upvotes: 0

Related Questions