Step 4: Create the change table, subscribe to the source table and activate the subscription - 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

You must specify the table to which the subscriber wants to subscribe and then activate its subscription.

Procedure

  1. Right-click the schema that corresponds to the source table and select Add CDC. The Create Subscriber and Execute SQL Script dialog box appears.
    Note: For Oracle databases and for versions 3.2 + of Talend Studio, the CDC system creates an alias for the source table(s) monitored. This helps to avoid problems due to the length of identifiers upon creation of the change table and its associated view. For CDC systems which are already set up, the table names are retained.

    The value of the options_string argument (for example tablespace users in the below dialog box) should be the default tablespace that you are using.

  2. Click Execute to activate the subscription to the source table and then click Close to close the dialog box.
    In the CDC Foundation folder, the table that holds the modified data and the associated view schemas appear.
    Example of the table schema in the connection.
  3. To see the changes made to data, right-click the corresponding table in the Table schemas folder and select View All Changes to open the corresponding dialog box.
    Overview of the View All Changes dialog box.

    The TALEND_CDC_TYPE column of the View All Changes dialog box indicates all of the different changes caught.

    The changes are caught as follows: I indicates that the data has been inserted, UN indicates that the data has been updated, and D indicates that the data has been deleted.

    The columns of the source table and their values are also displayed.

  4. Click Finish to close the dialog box.