Change data capture (CDC) is an event-driven alternative to repeatedly copying a source system’s current state. It reads change logs and emits insertions, updates, and deletions for downstream systems in real time. section 5.0 section 5.1.2
CDC uses a uniform event representation rather than requiring specialized events for every business change. Kafka provides the central streaming hub, while downstream systems consume the resulting topics independently. section 5.0 section 5.1.2
CDC is useful when:
- Systems need database changes made available to multiple destinations without building custom notification services. section 5.1.2
- A streaming flow is preferable to waiting for a batch process to complete. section 5.0
- The source contains data that changes through direct updates rather than application-managed services. section 5.1.2
Reference-data replication
Reference tables such as occupations, education levels, and country codes can be streamed from source systems through Kafka topics. Kafka Connect source connectors publish the data, while independent sink connectors deliver it to an MS SQL database and Amazon S3. Debezium can provide the CDC integration with source change logs. section 5.1.2




