Change Data Capture is a functionality which allows to capture changes in the data on the DB level to either propagate them synchronously to another DB, or to manage them asynchronously which facilitates ETL’s on extractions.

The goal of the study would be to : ​Evaluate the asynchronous variant to provide an ETL with the input required to update a datawarehouse Compare with the standard way of working where we code the delta to this automation. Evaluate the advantages & disadvanatages​