I would like to check if we can combine DIH and PWX CDC concepts together to achieve distribution/push of realtime change data to downstream applications from a source DB?
As a scenario, we have a source DB and the Change data from the tables is used across multiple applications or DBs, we would like to implement CDC for the source system, pull the change data from the source DB tables into a schema/DM and push these changes over to multiple downstream DBs/DMs using the publication and subscription concepts. Can someone please let me know if this can be achieved? or any other suggestions will be appreciated.
Please note the data availability requirements are real time or near real time.
PWX CDC today feeds exactly two products: PowerCenter (with a PC RealTime engine), and the PWX CDC Publisher for Kafka.