Step 3: Create the subscriber(s) table - 7.1

Change Data Capture (CDC)

author
Talend Documentation Team
EnrichVersion
7.1
EnrichProdName
Talend Data Fabric
task
Data Quality and Preparation > Cleansing data
Data Quality and Preparation > Profiling data
Design and Development
Installation and Upgrade
EnrichPlatform
Talend Administration Center
Talend DQ Portal
Talend Installer
Talend Runtime
Talend Studio

About this task

To set up the connection between the CDC and the data:

Procedure

  1. Right-click the CDC Foundation folder under the data connection node and select Create CDC from the contextual menu. The Create Change Data Capture dialog box opens up.
  2. In the Create Change Data Capture dialog box, click the [...] button next to the Set Link Connection field to select the database connection dedicated to CDC.
    Note that for the database, such as Oracle, which also supports other CDC mode, make sure to select Trigger mode as the option to capture data changes in this step.
  3. Click Create Subscriber and the Create Subscriber and Execute SQL Script dialog box opens up.
  4. Click Execute to run the SQL script displayed and then click Close to close the dialog box.
  5. Click Finish in the Create Change Data Capture dialog box.
    In the CDC Foundation folder, the CDC database connection and the subscriber table schema appear.