Oracle ODI 12c setting up simple CDC

This article describes how to use simple CDC for Oracle ODI 12c. It is the simplest kind of CDC. In this mode, each CDC table change is captured independently, and there is no need to consider data consistency between multiple tables with primary foreign key reference relationships.

1. Import Knowledge Module

Prior to this, all the knowledge modules have been imported, and the CDC feature knowledge module as shown:

2. Set the model CDC parameter

Open the corresponding model, set journalizing mode to simple, such as:

3. CDC Configuration 3.1 Add Datastores

In the model, right-click the table that you want to add to CDC, add or remove operations as shown:

It can be seen in the journalizing tables of the model, such as:

3.2 Start Journals

In the model, right-click the table that you added to CDC and start or close journal as shown:

After you start the log, a small green clock pattern appears in the upper-left corner of the icon, indicating that it was successfully set.

4. Initialize data

This step depends on the actual situation.

4.1 Creating mappings

The mapping diagram looks like this:

4.2 Setting the target's integration type

Note that in the logical result of the map, click the target table and set the target integration type to control Append, as shown in:

4.3 Setting loading knowledge Module

4.4 Setting Integration Knownledge Module

If you want to empty the target table before initializing the data, you can set the value of the truncate_target_table and Delete_all parameters to true.

4.5 Target table Import initialization data

The mapping is first checked before starting the mapping. Execution results such as:

To this, the initialization data has been imported into the target table.

5. Sync change Data 5.1 set source data storage

Set the source table to synchronize only the changed data. Select the source data store and select "journalized data only", such as:

5.2 Setting loading Knowledge Module

Here you need to set the loading knowledge module mode to "LKM SQL to Oracle". Such as:

5.3 Setting Integration Knownledge Module

The mode for setting the Integration Knownledge module is "IKM Oracle Incremental Update". Such as:

Finally, save all settings.

5.4 Source data store Insert new data

Then, in the pattern, select the source data store to view the new data, such as:

5.5 Target Sync Data

After the data is synchronized, the journalized data of the source table is cleared. After the ODI synchronizes the change data for a table, the corresponding subscriber's journaling data will be emptied. This is a very simple approach, but data synchronization for multiple tables with primary foreign key reference relationships can result in inconsistent data. Consistency JKM is required for this complex situation, as described later in this module.

Oracle ODI 12c setting up simple CDC