Step 4: Subscribe to the source table and activate the subscription - 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

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

Procedure

  1. Right-click the relevant schema of the source table and select add CDC. The Create Subscriber and Execute SQL Script dialog box appears.
    Warning: The source table to be monitored should have a primary key so that the CDC system can identify the rows on which changes have been made. You cannot set up a CDC environment if your source table schema does not have a primary key.
    Note: For Oracle databases, 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.
  2. In the Create Subscriber and Execute SQL Script dialog box, check the event(s) you want to catch: Insert, Update or Delete.
  3. Click Execute to run the SQL script displayed and then click Close to close the dialog box.
    In the CDC Foundation folder, the catch table schemas and the corresponding view schemas appear.
  4. To view any data changes made to the source table, right-click the table in the Table schemas folder and select View All Changes to open the View All Changes dialog box.
  5. Click Finish to close the dialog box.