Oracle Data Integrator 12c-First mapping

First, create " Project "

Designer-Projects, click the Insert item icon,

In the Project dialog box, under the Definition tab, enter the project name, such as Odi_exercise, to save

second, import knowledge module

Project → knowledge module → Right-click import Knowledge Module

File import Directory: Oracle\middleware\oracle_home\odi\sdk\xml-reference

Reverse Engineering Knowledge Module (RKM)	RKM Oracle
Load Knowledge Module (LKM)	LKM SQL to Oracle
Inspection Knowledge Module (CKM)	CKM Oracle
Integrated Knowledge Module (IKM)	IKM Oracle Incremental Update
The Diary Knowledge Module (JKM) is not available	JKM Oracle Consistent JKM Oracle Simple
Service Knowledge Module (SKM) is not available	SKM Oracle

Iii. Creating and configuring Mappings 3.1 New Interface

Right-click mappings → new mappings

3.2 Designing a data source-to-target mapping

Drag the Model dept from model ODI_SRC and Odi_tag to the mapped edit panel, respectively

Connect the output node of the source table dept to the output node of the target table dept, if the property match prompts to automatically match by name, click OK (you can also drag the source field to the destination table field, or edit the property panel expression of the target marker segment)

At this point, the individual field properties of the two tables have been mapped, a field in the target table is selected, and the field background of the source table is red.

Save and verify

Click on the target Datastore, and the properties panel can view the receivable.

There is a button at the back of the property panel expression to provide a graphical edit button

After clicking,

3.3 Select the appropriate knowledge module in the "Flow"

Logical tab page, select the target table, set the integration type to incremental update, update the keyword as the constraint primary key pk_dept

Physical tab page, set the lkm of the intermediate module to lkm SQL to Oracle

Physical tab page, set the integration knowledge module of the target table ikm for ikm Oracle Incremental update

3.4 "execute" mapping, using operator to correct the interface

Click on the toolbar green to perform the mapping, in the actions → session list → View the execution results

Go to database query results

SELECT *  from "Odi_tag". " DEPT ";

Continue inserting a piece of data in the source table actor

INSERT  into VALUES ('the 'IT''BOSTON');

Perform the mapping and find the ability to synchronize the new records

At this point, a complete mapping is completed.

Oracle Data Integrator 12c-First mapping