What is CDC?

Change data capture (CDC) is a method for capturing and tracking changes made to data in a database. Using CDC ensures real-time data synchronisation and data integrity across all systems reliant on that data.

Transactional databases store all changes in a transaction log, facilitating database recovery in case of a crash. Log-based CDC leverages this feature to read changes from the log.

Streamkap uses this method as it offers the ideal balance between minimising performance impact on the source database while maintaining high data quality.

The most significant advantage of log-based change data capture is its ability to decouple data capture from the source application, making it highly versatile across various applications.