In data warehousing, the data is extracted and transported from production database(s) into a data warehouse for reporting and analysis. Change Data Capture identifies and processes only the data that has changed and stores the changed data in a form so as to be of further use. This solution delves on how to achieve this when running Shareplex.
There are two ways Change Data Capture is generally implemented by the native database implementation and is done on the source side. These modes are:
Asynchronous: The changes to the table are gathered from the redo logs once the transaction is committed on source.
Synchronous: Triggers are enabled on source table so as to capture the changes to it.
When running Shareplex, it is possible to use the Synchronous mode on the target to implement CDC. The advantage with Shareplex is that you can implement CDC without impacting the performance of the production source database. However, when using Synchronous mode, you will have to assess its impact on Post performance. At any time, it is possible to disable CDC if it is a drag to the Post.
The Professional Services of Quest can be contacted for implementation of CDC for a fee. The contact information can be obtained from Support or your Sales rep for Shareplex.