Success
Manage your Success Plans and Engagements, gain key insights into your implementation journey, and collaborate with your CSMs
Customer Experience Accelerators
Accelerate your Purchase to Value by engaging with Informatica for Customer Success
My Engagements
All your Engagements at one place
 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
Product Learning Paths
Free and unlimited modules based on your expertise level and journey
Certifications
Get certified on Informatica products. Free, Foundation, or Professional
Experience Lounge
Self-guided, intuitive experience platform for outcome-focused product capabilities and use cases
 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
Support Documents
Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
SupportFlash
Monthly support newsletter
Product Availability Matrix
Product Availability Matrix statements of Informatica products
Product Lifecycle
End of Life statements of Informatica products
Pulse
Monitor the status of your Informatica services across regions
Events
Change Request Tracking
Marketplace
Trust Platform
English
  • PowerExchange for CDC and Mainframe H2L
  • All Products

Table of Contents

Search

  1. Abstract
  2. Supported Versions
  3. Implementing PowerExchange Express CDC for Oracle in a Non-RAC Environment

Implementing PowerExchange Express CDC for Oracle in a Non-RAC Environment

Implementing PowerExchange Express CDC for Oracle in a Non-RAC Environment

Back Next

Scenario

Scenario

You need to keep a data warehouse synchronized with an Oracle production database in near real time.
Your CDC environment has the following characteristics and requirements:
  • You use PowerExchange 10.4.0 Express CDC for Oracle.
  • You have an Oracle 12
    c
     R2 source database on a UNIX machine. The UNIX machine is remote from the PowerCenter Integration Service machine.
  • You need to capture changes from about 50 Oracle source tables and move the change data in near real time to multiple target tables on a remote machine.
  • The Oracle source tables are not in an Oracle Real Application Cluster (RAC), Oracle ASM environment, Oracle Data Guard standby environment, or Oracle 12
    c
     R2 multitenant environment.
  • The PowerExchange Navigator and PowerCenter Client reside on the same Windows machine, which is remote from the PowerCenter Integration Service machine and Oracle source system.
  • The PowerExchange Logger for Linux, UNIX, and Windows runs continuously on the Oracle source machine and logs change data records to local Logger log files.
  • You extract change data from the PowerExchange Logger log files in
    continuous extraction mode
    . Continuous extraction mode provides near real time access to change data but is much less resource intensive than
    real-time extraction mode
    .
  • You do not use offload processing. The Oracle source machine has sufficient memory and resources to handle CDC efficiently.
  • You use PWXPC connections and PowerCenter workflows to extract the change data from the PowerExchange Logger log files and to write the data to multiple target tables.
    PWXPC is a native plug-in that is installed with PowerCenter on the Windows and PowerCenter Integration Service machines.
    The following image shows the architecture for this scenario:
    This image shows the three separate machines that contain the PowerExchange and PowerCenter components and shows the data flow from the Oracle source to the target tables.
    The UNIX system hosts the Oracle source database, redo logs, and a PowerExchange instance, including the PowerExchange Logger, PowerExchange Listener, CCT file, and extraction maps. The Windows system hosts the PowerExchange Navigator and PowerCenter Client. In the PowerExchange Navigator, you create capture registrations and extraction maps and perform database row tests on the extraction maps. The PowerExchange Navigator reads and updates the CCT file and extractions maps on a UNIX source system. In the PowerCenter Client, you create mappings, connections, sessions, and workflows, which are stored in the PowerCenter repository. The PowerCenter Integration Service machine hosts the PWXPC reader and writer and communicates with the PowerCenter repository, PowerExchange Listener, and target.
0 COMMENTS
We’d like to hear from you!