IBM InfoSphere Change Data Capture
You can use the CDC Transaction stage in an IBM® InfoSphere® DataStage® job to read data that is captured by IBM InfoSphere Change Data Capture (InfoSphere CDC) and apply the change data to a target database.
Note: The CDC Transaction stage is being deprecated and will be removed from the palette for the
parallel job canvas.
- Overview
The CDC Transaction stage integrates the replication capabilities that are provided by IBM InfoSphere Change Data Capture (InfoSphere CDC) with the ETL capabilities that are provided by IBM InfoSphere DataStage. - Configuring InfoSphere CDC
After installing InfoSphere CDC, the installation program starts a configuration tool. You use the configuration tool to add and configure InfoSphere CDC instances for your environment. You must configure InfoSphere CDC for the source database and for the target (InfoSphere DataStage) before you can start replication. - Setting up replication in the InfoSphere CDC Management Console
You set up replication in the InfoSphere CDC Management Console to define how change data is captured and sent to the target. To set up replication, you add data stores for the source and target, add a new subscription, and map one or more tables to the target system. - Developing a job that processes replicated data from InfoSphere CDC
After setting up replication in the InfoSphere CDC Management Console, you generate a template for the InfoSphere DataStage job, import the template into InfoSphere DataStage and QualityStage® Designer, and configure the stages of the job. - Starting the subscription and running the job
You start the subscription in the InfoSphere CDC Management Console. If auto-start is selected, starting the subscription automatically starts the InfoSphere DataStage job. If auto-start is not selected, you must start the job manually. - Monitoring the status of the job and the subscription
You use the InfoSphere CDC Management Console to monitor the status of a subscription, and the InfoSphere DataStage and QualityStage Director client to monitor the status of the job. By using these tools together, you can view statistics about latency and throughput, and identify error and warning conditions. - Ending the subscription
After you start a CDC Transaction stage job, it runs continuously until the subscription ends and the InfoSphere CDC for InfoSphere DataStage server sends a termination message to the CDC Transaction stage. To end the subscription, you specify one of the termination modes in the InfoSphere CDC Management Console. - Example: Applying change data by using a CDC Transaction stage
This example demonstrates how to use IBM InfoSphere Change Data Capture (InfoSphere CDC) to read changes that occur on tables in an Oracle database and then use IBM InfoSphere DataStage to replicate the changes to a target Db2® database. - Troubleshooting
These topics describe how to resolve problems that you might encounter when you use the CDC Transaction stage in an InfoSphere DataStage job. - Frequently asked questions about the CDC Transaction stage
Find the answers to frequently asked questions about using the CDC Transaction stage in an InfoSphere DataStage job.
Related tasks: