Communities
A collaborative platform to connect and grow with like-minded Informaticans across the globe
Product Communities
Connect and collaborate with Informatica experts and champions
Discussions
Have a question? Start a Discussion and get immediate answers you are looking for
User Groups
Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
Get Started
Community Guidelines
Knowledge Center
Troubleshooting documents, product guides, how to videos, best practices, and more
Knowledge Base
One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
Support TV
Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
Documentation
Information library of the latest product documents
Velocity (Best Practices)
Best practices and use cases from the Implementation team
Learn
Rich resources to help you leverage full capabilities of our products
Trainings
Role-based training programs for the best ROI
Certifications
Get certified on Informatica products. Free, Foundation, or Professional
Product Learning Paths
Free and unlimited modules based on your expertise level and journey
Resources
Library of content to help you leverage the best of Informatica products
Tech Tuesdays Webinars
Most popular webinars on product architecture, best practices, and more
Product Availability Matrix
Product Availability Matrix statements of Informatica products
SupportFlash
Monthly support newsletter
Support Documents
Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
Product Lifecycle
End of Life statements of Informatica products
Ideas
Events
Change Request Tracking
Marketplace
English
  • Data Integration Connectors
  • All Products

Table of Contents

Search

  1. Preface
  2. Introduction to Oracle CDC V2 Connector
  3. Oracle CDC connections
  4. Mappings and mapping tasks with Oracle CDC V2 Connector
  5. Oracle CDC administration
  6. Data type reference
  7. Connection overrides reference

Oracle CDC V2 Connector

Oracle CDC V2 Connector

Back Next

Integration with the PowerExchange CDC environment

Integration with the PowerExchange CDC environment

You must have a functional on-premises PowerExchange Express CDC for Oracle on Linux, UNIX, or Windows environment that can capture change records from Oracle source tables and log them to PowerExchange Logger for Linux, UNIX, and Windows log files. Also, you must have a license that allows your organization to use the Oracle CDC Connector and PowerExchangeClient packages on Linux or Windows.
On each system from which you plan to use Oracle CDC Connector, you must install the Secure Agent. After you start the Secure Agent the first time, the Oracle CDC Connector and PowerExchangeClient components are installed locally. You then can use Cloud Data Integration, Administrator, and Monitor interfaces to configure Oracle CDC connections, mappings, and mapping tasks and to run and monitor mapping tasks.
The following image shows the general architecture of the Oracle CDC Connector components with Cloud Data Integration and a remote PowerExchange Express CDC for Oracle source system:
On-prem PowerExchange components and Oracle source in relation to on-prem Oracle CDC V2 Connector and Data Integration components on a separate system. Shows data flow from the source to target and source metadata flow to the cloud repository.
In this configuration, the PowerExchange Express CDC for Oracle environment resides on one Linux, UNIX, or Windows system and the Oracle CDC Connector environment resides on another Linux or Windows system. The PowerExchange Navigator runs on a Windows system apart from both environments. Based on this image, the following processing occurs:
  1. PowerExchange Express CDC for Oracle actively captures change records from Oracle redo logs and sends the records to the PowerExchange Logger for Linux, UNIX, and Windows on a continuous basis.
    To capture change records, the PWX Express CDC Reader uses the capture registrations and extractions maps that you defined in the PowerExchange Navigator for the Oracle source tables.
  2. The PowerExchange Logger logs the change records in its log files.
    The PWXCCL file defines the PowerExchange Logger configuration.
  3. When you design a mapping in Data Integration, you associate the Source transformation with an Oracle CDC connection. You can define the connection in either Data Integration or Administrator. The PWX CDC Metadata Adapter then uses the Oracle CDC connection to connect to the PowerExchange Listener and retrieve extraction-map metadata for the Oracle source from the PowerExchange CAMAPS file.
    In the mapping, you must also define a Target transformation and connection and map the source fields to target fields.
  4. The Secure Agent in conjunction with Data Integration sends the extraction-map metadata to the Informatica Intelligent Cloud Services repository in the cloud.
  5. When you run the mapping task that is associated with the mapping, all of the CDC metadata, connection properties, mapping information, advanced source properties, CDC runtime properties, and advanced session properties are pushed down to the on-premises Secure Agent in the form of a session .xml file.
  6. The PWX CDC Reader on the Secure Agent machine communicates with the PowerExchange Listener to retrieve the change records from PowerExchange Logger log files.
  7. Data Integration transmits the change records to the mapped target.
Alternative configurations of PowerExchange with the Oracle CDC Connector components and Cloud Data Integration are possible. For example:
  • The PowerExchange Express CDC for Oracle environment, Oracle CDC Connector components, and Secure Agent can all run on the same Linux or Windows system.
  • The PowerExchange Logger for Linux, UNIX, and Windows and its log files can reside on a system that is remote from the Oracle source system and remote from the Linux or Windows system where the Oracle CDC Connector components and Secure Agent run. By logging change data to a remote PowerExchange Logger, you can reduce resource consumption on the source system and possibly reduce the network overhead of data transfer. For more information, see "Remote Logging of Data" in the
    PowerExchange CDC Guide for Linux, Unix, and Windows
    .
  • The PowerExchange Navigator can run on any supported Windows system, including a Windows system where the Oracle database or Secure Agent runs.
0 COMMENTS
We’d like to hear from you!