liveBook · Manning

Change-data-capture

As explained in Kafka Streams in Action, Second Edition

Change data capture is a technique for detecting and exporting database record changes such as inserts, updates, and deletes as they occur.

Change data capture (CDC) detects database-table changes and exports INSERT, UPDATE, and DELETE events to other applications. Kafka Connect stores those changes in a Kafka topic, making them available to downstream consumers with low latency while leaving the existing application unchanged. section 5.1

A CDC integration typically involves:

  • A database table whose changes are captured as they occur. section 5.1
  • A Kafka Connect connector configured as a plugin through a JSON configuration file. section 5.1
  • A Kafka topic that stores the exported changes for downstream consumers. section 5.1

Capturing table changes

A connector captures INSERT, UPDATE, and DELETE operations from a relational database and writes them to Kafka. Other applications consume the resulting events without requiring changes to the legacy application. section 5.1

How Kafka Streams in Action, Second Edition covers it

How deep it goes
Explains captured operations, Kafka-topic storage, connector configuration, and the distinction between custom clients and production-ready connectors.
Examples
Uses database INSERT, UPDATE, and DELETE events as the central example.
What you can do after
Operate CDC by configuring a Kafka Connect connector to publish database changes into a Kafka topic.
How it connects
Connects CDC with Kafka Connect, Kafka topics, relational databases, NoSQL stores, Elasticsearch, and Amazon S3.

Also explained in

Compare how 5 books explain change-data-capture →

Related concepts

This explainer was generated by Manning's knowledge graph from the text of Kafka Streams in Action, Second Edition. The section links point to the parts of the book it draws on.