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