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.
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.
Double-click tTeradataCDC to open its Basic
- 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.
- 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.
- Select the check box(es) for the event(s) to be monitored.
- 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.
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.