This blog provides an alternative approach to implement order visibility and search using Change Data Capture (CDC) software pattern or technique instead of using IBM Order Management event extension points described in a previous blog in this series.
Change Data Capture (CDC) is a popular software pattern that is used by databases to track the changes in data and perform certain actions. CDC is employed as real-time data replication technique that does not require making any code changes in the software application.
The source database must enable transaction logging that is read by a CDC tool and the data is pushed to a target data source which can be another datastore or a flat-file. This data is then transformed into an order object that is required to support the read and search mechanisms. The contents of transaction logs are proprietary to the database management system and therefore a CDC tool is used to interpret them. There are many standard CDC tools available in the market. For example, IBM Infosphere CDC, Oracle Golden Gate, Informatica CDC, Attunity and so on.
The following diagram shows an IBM Cloud approach to CDC based on real-time data integration to support the order search mechanism.
Note: Similar components from other cloud providers like Amazon, Microsoft and Google can also be used as desired.