Skip to main content Skip to complementary content

Configuring CDC in Trigger mode

Below are configuration steps that need to be set up just once for a given publisher/subscriber scenario.

Step 1: Set up a publisher

Procedure

  1. Set up a database connection dedicated to CDC.
  2. Set up a connection to the database where data is located.

Results

For more information about how to set up a database connection, see Centralizing database metadata.
Information noteNote: If you work with an MS SQL Server, you must set the two connections to the same database but using two different schemas.
Example of two connections to the same database on an MS SQL Server.

Step 2: Identify the source table

To identify the table from which data changes will be captured, right-click the newly created data connection to retrieve the schema of the source table and load it on your repository file system. In this example, the source table is person.

Example of the person source table from the connection.

Step 3: Create the subscriber(s) table

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.
    Trigger mode and XStream mode options for an Oracle database.
  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.

Step 4: Subscribe to the source table and activate the subscription

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.
    Information noteWarning: 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.
    Information noteNote: 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.
    Overview of the View All Changes dialog box.
  5. Click Finish to close the dialog box.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!

Leave your feedback here