Oracle ODI 12c setting up simple CDC

Source: Internet
Author: User

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.