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.