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

Change Data Capture

author
Talend Documentation Team
EnrichVersion
6.4
EnrichProdName
Talend Data Services Platform
Talend Data Integration
Talend Data Fabric
Talend Big Data
Talend Big Data Platform
Talend Data Management Platform
Talend ESB
Talend MDM Platform
Talend Real-Time Big Data Platform
task
Data Quality and Preparation > Third-party systems > Database components > Change Data Capture
Data Governance > Third-party systems > Database components > Change Data Capture
Design and Development > Third-party systems > Database components > Change Data Capture
EnrichPlatform
Talend Studio

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.