Change Data Capture

Change Data Capture for Oracle with Power Exchange

Change Data Capture is the process of capturing changes that are done on the source of data and then implementing those changes later on inside the organization.

Change Data Capture is the process of capturing changes that are done on the source of data and then implementing those changes later on inside the organization. It only deals with data changes; therefore use of the CDC reduces the resources needed for ETL (Extract, Transform, and Load) operations. The objective of Change Data Capture is to make synchronicity of certain data. Oracle change data capture technology is used to speed up the process of data warehousing, allow doing quick data integration within the organization that improves the database performance. In your Informatica Online Training, learn about a few implementations of Oracle’s Change Data Capture with Informatica PowerExchange.

Power Exchange Listener

The PowerExchange Listener helps to manage data charts for un-related files and occupies extraction and registration maps for all data sources. It also takes care of all the extraction requirements for massive data and data change.  

  1. CCT file for capturing registrations
  2. DATAMAPS directory for DB2 data maps
  3. CAMAPS directory for extraction maps

PowerExchange Logger

PowerExchange Logger collect captured change data from the connected ECCRs and saves the change data in log data sets. Linux, Windows, and UNIX capture data with its PowerExchange Logger from DB2 recovery logs, SQL server distribution database or Oracle redo logs and then scripts that data into log files.

The use of Power Exchange logger is not essential at all, depending on your requirements and processes. You need to process a single PowerExchange Logger for each type of database. The PowerExchange logger writes all UOWs in a sequence that is based on the ending time of log files. By doing this, you can sustain transactional reliability and extract the change data in batches or continuous flow from the PowerExchange Logger.


Power ExchangeCondenser

This condenser constructs condense files, which are a condensed version of the data changes grabbed by ECCR and saved in the logger.


The Power ExchangeNavigator

The Navigator is the graphical user interface, you can utilize for monitoring, scripting, managing data maps, confining registrations and extracting maps of data sources that are required to discover massive data or grab data change.


Power Exchange


Steps Involved in Change Data Replication:  


Change Data Capture: As the PowerExchange observes the change data in the data sources, but in RDBMS log files or databases, it can directly examine change data.


Change Data Extraction: PowerCenter integrating with PowerExchange extracts captured change data to transfer it for further processing.


Change data apply: PowerExchange and PowerCenter, together also convert data in a feasible format and then apply the change data to intended tables or files.


How to Implement Change Data Capture?

  1. Configure parameters indbmover.cfg file for the PowerExchange Listener.
  2. Start the PowerExchange Listener on the device with the source database.
  3. Execute RDBMS-based configuration for CDC.
  4. Configure the PowerExchange Logger.
  5. Begin working with PowerExchange Logger.

The concept of change data capture is quite complicated. Using these implementations with Informatica’s PowerExchange can help you to some extent to learn the change data capture in Oracle. But without any practical training, it will not be possible to master the skills of technology. Informatica Training will help you to learn all hacks relating to PowerExchange. Join the training today, we have services in the United States, United Kingdom and Europe.

Write a Comment