CDC Guide for Linux, UNIX, and Windows

10.5
- 10.5.6
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5.1
- 10.4.1
- 10.4.0 HotFix 1
- 10.4.0

Back Next

PowerExchange CDC Overview

PowerExchange change data capture (CDC) works in conjunction with PowerCenter® to capture change data from source tables and replicate the changes to target tables and files. This guide describes PowerExchange CDC for supported relational database sources on Linux, UNIX, or Windows operating systems.

After materializing target tables or files with PowerExchange bulk data movement, you can use PowerExchange CDC to synchronize the targets with their corresponding source tables. Synchronization is faster when you replicate only the change data rather than all of the data.

The change data replication process consists of following high-level steps:

Change data capture
. PowerExchange captures change data for the source tables. PowerExchange can read change data directly from the RDBMS log files or database. Optionally, you can use the PowerExchange Logger for Linux, UNIX, and Windows to capture change data to its log files.

Change data extraction
. PowerExchange, in conjunction with PowerCenter, extracts captured change data for movement to the target.

Change data apply
. PowerExchange, in conjunction with PowerCenter, transforms and applies the extracted change data to target tables or files.

Change Data Capture Introduction

Change Data Capture

Change Data Extraction and Apply

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal