Log scanners can identify any changes in these transaction logs. The use of timestamps is one of the most popular methods of CDC, as most systems track when a row was created and most recently modified.ĭatabase transaction logs are also a resource for CDC. There are different approaches that a system can use to capture changes in data. What Are Common Methods of Change Data Capture? CDC tools leverage that information to deliver database changes to an external system. CDC tools typically rely on the database’s transaction log, which keeps track internally of record changes for the purposes of system recovery. How Does Change Data Capture Work?ĬDC delivers data on records that changed for database functions such as inserts, updates, and deletes, and makes a record of that change available either within a database itself or to other applications that rely on the data.

Multiple databases and applications can subscribe to the change data. The change data capture process via the publisher/subscriber method.

Change data capture