Supplying business leaders with the insights for real-time decision-making is no easy feat. In most enterprises, key operational data is spread across hundreds of different systems, so a common practice is to extract and move all relevant data to a central location for analysis (for example, an enterprise data warehouse / data lake / enterprise data hub). But since most operational systems write all their data to a relational database, one of the main challenges to enabling real-time analysis is how to capture changes from the relational databases in real-time?
This is where Change Data Capture (CDC) comes into play.