Mappings and mapping tasks with Microsoft SQL Server CDC Connector
Mappings and mapping tasks with Microsoft SQL Server CDC Connector
In Data Integration, create a mapping that includes the Microsoft SQL Server CDC source and a target of a supported type. Then create a mapping task that is associated with the mapping to process change data based on the mapping.
The mapping and mapping task information is stored in the Informatica Intelligent Cloud Services cloud.
To process the SQL Server change records, run the mapping task in the runtime environment. The mapping task runs on premises, on the same machine where the Secure Agent and PowerExchange client components run. The mapping task uses the mapping and mapping task information pushed down from the Informatica Intelligent Cloud Services cloud. During a mapping task run, the PWX CDC Reader retrieves the captured SQL Server change records from the PowerExchange Logger log files, and Data Integration transmits the change records to the target based on the mapping.
After a mapping task ends, you can determine its job status and view the session log from either the Data Integration or Monitor interface.