Extracting change data modified in Oracle Redo/Archive log mode - Cloud - 8.0

Talend Studio User Guide

Version
Cloud
8.0
Language
English
Product
Talend Big Data
Talend Big Data Platform
Talend Cloud
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Design and Development
Last publication date
2024-02-29

About this task

After setting up the CDC environment, you can now design a Job in Talend Studio using the CDC Oracle component to extract the change data from the source system.

If you want to use CDC with an Oracle database, proceed as below:

Procedure

  1. From the Repository tree view, drop the source table to the design workspace and select the tOracleCDC component in the Components dialog box, drop tLogRow from the Palette to the design workspace, and link the two components together using a Row Main connection.
    Job using the tOracleCDC and tLogRow components.
  2. Double-click tOracleCDC to display its Basic settings.
    The Property type is set to Repository since we used the connection information related to CDC stored locally in the Repository tree view. All connection fields are automatically filled in.
    In the Schema using CDC, Repository is selected and this way the schema corresponding to Oracle source table is automatically retrieved.
    The name of the source table that holds change data appears in the Table using CDC field. In this example, the table is called CLIENT.
    Note: The CDC Log Mode check box is selected since you select this mode when setting up the CDC environment.
  3. For the Events to catch option, select the check box corresponding to the events you want to catch.
    In this example, select Insert, Update and Delete.
    Configuration of tOracleCDC.
  4. Save your Job and press F6 to execute it.

Results

In the console, you can read the output results that correspond to what you can see in the View All Changes dialog box.