We are looking to setup CDC with the DB2 connector via Data Connection Agents and have a few questions regarding the architecture:
- Once the relevant tables in DB2 are configured for change data capture, a CDC sync can be created in Foundry. This includes setting up the Debezium connector with a Kafka topic, etc. Do all of the Debezium resources get deployed in Foundry, and then the Debezium connector queries the CDC tables in DB2? I.e., nothing needs to be managed/configured on the DB2 side apart from the CDC tables?
- If the DB2 source is agent-based, do the Debezium resources get deployed on the agent? Are there any configurations available to ensure agent performance isn’t affected for other sources/syncs?
Thanks in advance!