Specify which table the subscriber wants to subscribe to and then activate the subscription - 7.3

Change Data Capture

EnrichVersion
Cloud
7.3
EnrichProdName
Talend Big Data
Talend Big Data Platform
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
EnrichPlatform
Talend Studio
task
Data Governance > Third-party systems > Database components > Change Data Capture
Data Quality and Preparation > Third-party systems > Database components > Change Data Capture
Design and Development > Third-party systems > Database components > Change Data Capture

Procedure

  1. Right-click the Leafact schema in the source CRM and select Add CDC in the drop-down list. The Create Subscriber and Execute SQL Script dialog box displays.
  2. In the Events to catch check boxes, select Insert, Update and Delete to catch inserted, updated or deleted data.
  3. In the Subscriber Name field, enter the name of the subscriber that will have access to the modifications, in this scenario Sub_Mktg for the Marketing department.
  4. Click Execute and then Close to validate the subscription.
    In the CDC Foundation folder, the two created tables display and the schema node of the catched table is marked with a green CDC symbol.