Configuring the Change Data Capture node
Configure the Change Data Capture node to capture all the changed data from your database into IBM® App Connect Enterprise.
Before you begin
Your installed version of IBM App Connect Enterprise must be 12.0.10.0 or later to be able to use this function.
Watch the following video, which demonstrates how to stream changes from a Postgres database: How to use the Change Data Capture node to stream changes from a Postgres database.
If you need to capture data from Db2, obtain a license for IBM InfoSphere Data Replication (IIDR) For more information, see InfoSphere Data Replication.
The Change Data Capture node requires an integration server to run Java 11. For more information about using a specified version of the Java Runtime Environment, see Configuring an integration server to use a specified Java Runtime Environment (JRE).
- Go to the Connectors page for Debezium.
- Select your database, for example, Db2.
- In the scrollable side menu, click the link for setting up your database server, for example Setting up Db2.
- Follow the instructions in the link.
- Go to the Connectors page for Debezium.
- Select your database, for example, Db2.
- In the scrollable side menu, select Deployment.
- Follow the link to download the plug-in archive from Maven Central.
- Extract the file into /opt/mqsi/server/cdc (or an equivalent path if you installed elsewhere) so that you have a directory similar to /opt/mqsi/server/cdc/debezium-connector-db2 that contains several JAR files.
- If your database is Db2, you must also complete the following steps:
- The following JDBC driver for Db2 is required: https://repo1.maven.org/maven2/com/ibm/db2/jcc/11.5.0.0/jcc-11.5.0.0.jar. Download this driver from Maven Central as described in step 3 of Debezium connector for Db2.
- Add the https://repo1.maven.org/maven2/com/ibm/db2/jcc/11.5.0.0/jcc-11.5.0.0.jar into the directory where you extracted the plug-in archive at step 5.
- Complete any setup steps that are required for your chosen database as described in step 2.b of the "Procedure" section.
About this task
When you put an instance of the Change Data Capture node into a message flow, you can configure it. For more information about configuring message flow nodes, see Configuring a message flow node. The properties of the node are displayed in the Properties view. All mandatory properties that do not have a defined default value are marked with an asterisk. By configuring a Change Data Capture node, you can enable it to respond to changes in your database.
For Db2, the Debezium setup scripts to automatically start and stop data capture work only on Linux®. On other platforms, use Db2 control commands to put tables into capture mode. For more information about Db2 commands, see https://www.ibm.com/docs/en/idr/11.4.0?topic=reference-system-commands-sql-replication-linux-unix-windows-zos.
On other platforms, use Db2 control commands to put tables into capture mode.
Where the commands are listed here: https://www.ibm.com/docs/en/idr/11.4.0?topic=reference-system-commands-sql-replication-linux-unix-windows-zos
Configure the Change Data Capture node by completing the following steps: