What is change data capture?
Change data capture (CDC) refers to software that records database data activity from transaction logs of corporate databases for tracking purposes. CDC is primarily concerned with tracking changes that have occurred within the data and its goal is to ensure data synchronicity.
Microsoft offers software with change data capture capabilities. An example of this would be SQL Server 2008, which allows users to record, track, and update data changes in real time. There is also other software that enables data change capture, such as InfoSphere Change Data Capture.
CDC improves operational efficiency and saves companies time by eliminating unnecessary data transfers across many databases. It identifies the extraction process from production databases to data warehouses.