CDC – Change Data Capture

Data Integration > CDC – Change Data Capture

CDC – Change Data Capture

Overview

Change Data Capture is the solution to capture the data from another database, it would be useful when your organization needs information changes as well as operational database. It will always be synchronized.

Objective

To capture the changes of the operational database and replicate it into the target with near real time.
To speed-up the windows time of synchronization by captured the changes only

Objective

To capture the changes of the operational database and replicate it into the target with near real time.
To speed-up the windows time of synchronization by captured the changes only

Benefits

Only changed data will be captured, almost no impact to the operational database
With small windows-time during transformation, users could get the fresh data when they come in the morning and sit in their desk.