Introduction to Oracle CDC V2 Connector

Oracle CDC Connector extracts change records from PowerExchange Logger for Linux, UNIX, and Windows log files and sends the change records to Data Integration. Data Integration can then transmit the change records to a supported target.

When you define mappings in Data Integration, you select the extraction maps that PowerExchange generated for Express CDC for Oracle source tables when you registered the tables. The Oracle CDC V2 Connector metadata adapter can then retrieve the source metadata from the extraction maps and store this information in the Informatica Intelligent Cloud Services cloud.

To extract source change records from PowerExchange Logger log files, you must run the mapping tasks that are associated with the mappings. A mapping task runs to the end-of-log (EOL) in the PowerExchange Logger log files and then stops. You can manually restart the mapping task from a specific point in the logs, create a schedule that runs the mapping task on a recurring basis, or run the mapping task continuously. If the mapping task fails, Oracle CDC Connector can resume processing from the point of interruption based on recovery information that is stored on the target.

Oracle CDC Connector must be able to connect to an active PowerExchange Express CDC for Oracle environment that includes the PowerExchange Logger. You do not need to copy the PowerExchange dbmover configuration file or PowerExchange Logger pwxccl configuration file to the Oracle CDC Connector system. For more information about configuring PowerExchange Express CDC for Oracle and the PowerExchange Logger, see the PowerExchange CDC Guide for Linux, UNIX, and Windows.

Oracle CDC Connector works with the Informatica Cloud Secure Agent. When you install and start the Secure Agent, it downloads the Oracle CDC Connector components and PowerExchangeClient packages. When you define a runtime environment, you configure a Secure Agent group.