Extracting change data in Trigger mode - 7.1

Change Data Capture (CDC)

author
Talend Documentation Team
EnrichVersion
7.1
EnrichProdName
Talend Data Fabric
task
Data Quality and Preparation > Cleansing data
Data Quality and Preparation > Profiling data
Design and Development
Installation and Upgrade
EnrichPlatform
Talend Administration Center
Talend DQ Portal
Talend Installer
Talend Runtime
Talend Studio

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. For further information on the properties and the parameters of the tTeradataCDC component, see tTeradataCDC .

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.