Skip to content
BENIBIX Learn

Change Data Capture (CDC)

Data📥 Ingestion & StreamingData Ingestion

Also known as CDC, Log-Based CDC

It copies each change in a database right as it is made.

Think of it like

It is like a nosy friend who writes down every change you make to your room. You never have to say what changed.

Example

A bank uses CDC on its accounts table. Each balance change reaches the fraud system in about two seconds.

Why it matters

It catches every update and every delete. A nightly copy misses those. It also puts little load on the app's database.

Definition

Change data capture copies each change in a database as it happens. It reads the database's own change log. Every insert, update and delete is written there. Each change becomes an event that is sent on to other systems. So a warehouse or a search index stays in step within seconds. The source database barely notices.
CDC reads the database's own log, so every change is sent on, deletes too.

Common mistake

Polling the table with a query for new rows. That misses deletes and rows changed twice between polls.

Key takeaways

  1. 1
    Read the log. Use the database's own change log.
  2. 2
    Every change. Inserts, updates and deletes.
  3. 3
    Low load. The app's database barely notices.

Compare