Extracting change data in Trigger mode - Cloud - 7.3

Talend Studio User Guide

Version
Cloud
7.3
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-13

About this task

After setting up the CDC environment, you can design a Job in Talend Studio using the CDC component which corresponds to the type of the database being used, in order that changes made to the data from the source system can be extracted. In this example, the tTeradataCDC component will be used to show how to extract data changes made to the source table person.

Procedure

  1. Create a new Job in Talend Studio, add a tTeradataCDC component and a tLogRow component, and link tTeradataCDC to tLogRow using a Row > Main connection.
  2. Double-click tTeradataCDC to open its Basic settings view.
  3. Select Repository from the Property of the CDC connection drop-down list and click the [...] button next to the field to retrieve the schema that corresponds to the database connection dedicated to CDC.
  4. Select Repository from the Schema using CDC drop-down list and click the [...] button next to the field to retrieve the schema that corresponds to the table from which changes will be captured.
  5. Select the check box(es) for the event(s) to be monitored.
  6. Double-click tLogRow and in the Mode area on its Basic settings view select Table (print values in cells of a table) for a better display of the result.
  7. Press Ctrl + S to save the Job and then F6 to execute it.
    On the console, you can read the output results which correspond to what you can see in the View All Changes dialog box.