Skip to main content Skip to complementary content

Extracting change data in Trigger mode

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.
    Job using the tTeradataCDC and tLogRow components.
  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 boxes for the events to be monitored.
    Configuration of the tTeradataCDC component.
  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.
    Results from the tLogRow component.
    On the console, you can read the output results which correspond to what you can see in the View All Changes dialog box.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!

Leave your feedback here