Db2 for LUW CDC Connector > Introduction to Db2 for LUW CDC Connector > Db2 for LUW CDC Connector usage scenario
  

Db2 for LUW CDC Connector usage scenario

Your organization needs to replicate real-time change data from a mission-critical Db2 for LUW production system to minimize intrusive, non-critical work, such as offline reporting or analytical operations, on that system.
You can use Db2 for LUW CDC Connector to connect to an on-premises PowerExchange CDC for Db2 for LUW system from another Linux and Windows system where the Secure Agent is installed. Db2 for LUW CDC Connector components retrieve metadata about Db2 source tables and the change records that PowerExchange captured for these sources. The source metadata is stored in the Data Integration cloud. You can use the browser-based Informatica Intelligent Cloud Services interfaces to define Db2 for LUW CDC connections, mappings, and mapping tasks. When you run the mapping tasks, the CDC Connector components in conjunction with Data Integration retrieve and process the change records that PowerExchange captured from the production database and transmit these change records to one or more targets. Multiple users can then access the latest data on the target systems.
By using Db2 for LUW CDC Connector, you reduce the workload on Db2 production systems while making accurate and up-to-date Db2 change data available to multiple users on less critical target systems. Also, you gain access to easy-to-use, browser-based interfaces for defining mappings and mapping tasks and for running and monitoring mapping tasks.