Your organization needs to replicate change data in real time from a mission-critical Microsoft SQL Server production system to minimize intrusive, non-critical work, such as offline reporting or analytical operations, on that system.
You can use SQL Server CDC Connector to connect to an on-premises PowerExchange CDC system from another Linux or Windows system where the Secure Agent is installed. SQL Server CDC Connector components retrieve metadata about SQL Server 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 SQL Server CDC connections, mappings, and mapping tasks. When you run the mapping tasks, SQL Server 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 SQL Server CDC Connector, you reduce the workload on the SQL Server production systems while making accurate and up-to-date SQL Server 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 running and monitoring mapping tasks.