Using change data capture (CDC) is a reliable way to integrate data and keep track of changes that occur. This method helps ensure that all systems relying on the data remain consistent and functional.
Transactional databases use a transaction log to store all changes. This allows for recovery of the committed state of the database should the database crash for whatever reason. Log-based CDC takes advantage of this aspect of the transactional database to read the changes from the log.
Streamkap uses log-based CDC because it offers the best combination of low impact on the source database while maintaining high data quality.
The most significant advantage of log-based change data capture is that it decouples the capture of changes from the source application. Log-based CDC can be used for a variety of applications, making it extremely versatile.
Updated about 1 year ago