Oracle Data Integrator

1) Click on Master Repository Creation to create a new master repository.

2) Select Oracle driver for driver field and then enter the connection url.

3) Enter the user name and password. For master repository I created a new schema called XXODI_MST.

4) Click OK. You will get Successful Creation message.

5) Go to Start->Oracle->Oracle Data Integrator->Topology Manager

6) A small window will open. Click on new icon.

7) Login Name : Enter “Master Repository”

User : Supervisor

Password: SUNOPSIS

User: XXODI_MST

Pwd: XXODI_MST

Driver : Oracle JDBC Driver

Driver Name: oracle.jdbc.driver.OracleDriver

Url:odbc.oracle.thin:@taylusap.oradom.ekk:1520:DEV

8) Right click on Work Repository and click on Insert Work Repository

9)Click the first tab and then expand Technologies and right click oracle and click insert data server
10) Create a Source physical data server as shown below
11) Create another data server for target data server.
12) Click on logical schema and then expand Technologies. Right click on Oracle and insert logical schema.

13) Go to ODI menu and click on Designer. Select the work repository and enter user as SUPERVISOR and password as SUNOPSIS

14) Create a new project.
15) Right click on project and click on “import Knowledge Module”
16) Select the folder impexp from ODI directory.
17) Select IKM Oracle Incremental Update and LKM SQL to SQL

18) Click on Model tab and then right click and then click on insert model folder.
19) Create a source model folder and select the values as shown below:-

20) On the Selective Reverse tab click on “Object to Reverse” and then select the table from which you want to fetch the data. Once selected then click on Reverse button

20) Similarly create Target model and select the table which you want to populate.
21) Right click on source model and select add to cdc(Changed data capture).
22) Right click on Constraint in each of the table and create a primary key. Same thing is to be done for tables in target model.
23) Click on projects and create a new interface as shown below.

24) Drag the source table and drop it in right frame as shown below. Similiarly drag the target table and drop it in Target area on the right hand side as shown below.

25) If column names in source and target are same then auto mapping will be done. Otherwise we can do manual mapping for each column in target table.
26) Click on flow tab and then click on source frame . Then select LKM SQL to SQL.
27) Then click on Target frame and select IKM Oracle Increment Update.

28) Right click on package and click on “insert Package”. Then add the interfaces to this newly created package.
29) Here we can set the sequence in which interfaces is to be executed.

30 ) Right click on package and generate the scenario.
31) Under Scenario, Scheduling option is there. Using this we can schedule the package.

32) Right click package and click on execute.
33) Go to ODI menu, click on Operator and check the status by expanding ALL Execution node