Getting Started with ODI

Getting Started

Data loading into tables in Oracle DB:

TOPOLOGY

Step1: Connect to the repository

 

Step2: Check the connection by clicking edit button

Step3: Create Topologies

             Physical Architecture>Technologies>File>FILE_GENERIC 

         

Step4: Right click on the FILE_GENERIC and create new Physical Schema. Specify the working space i.e. (Directory (Schema), Directory (Work Schema)) in your local machine 

Step5: Give the context information as the following

NOTE: Logical Schema can be created here or can create separately under the logical schema in the topology

Save the work here

Step6: Create the Data Server under the Oracle technology in the Physical architecture 

NOTE:  At least one physical schema should be attached to the Data Server

              Physical Schema must contain at least one logical schema

Step7: Specify the following details in the Data Server Definition.

Step8: Provide the JDBC connection details as follows

JDBC Driver:  oracle.jdbc.OracleDriver

JDBC Url: jdbc:oracle:thin:@ogslab2.1gs.us:1560:COEODI

Save the work here

Step9: Create the physical schema under the Data Server by right clicking on the Data server which we created

Step10: Here we have to specify the following details for the Physical schema

             Schema (Schema)                   : COE_ODI_REPO

             Schema (Work Schema)         : COE_ODI_REPO

                                                              (Since this is the target location in the database)

Step11: Specify the context value as following

  

NOTE: Topology definitions are over here, now move on to the Designer Navigator in ODI studio

Save the work here

DESIGNER

Step12: In the model window under the designer navigator create your own folder

           (E.g.) Santhosh

 

Step13: Create the new model under the folder we created. One for source and other for target

E.g SRC_EMP_SAN

      TRG_EMP_SAN

 

Step14: Create Data Stores for each model by right clicking the SRC_TRG_EMP and TRG_EMP_SAN, for source we have to specify the following Details

 

Before going to the next step create table as follows in the respective schema

CREATE TABLE COE_ODI_REPO.TRG_EMP_SAN

(

  EMPNO       VARCHAR2(50 BYTE),

  FIRST_NAME  VARCHAR2(50 BYTE),

  LAST_NAME   VARCHAR2(50 BYTE),

  JOB         VARCHAR2(50 BYTE)

)

Step15: Specify the following details for the TRG_EMP_SAN and Resource should be the Target table name and which must be created in prior with the same table structure as in source file

Step16: Make sure that you will be doing reverse engineering before saving the target table

Save the work here

INTERFACE

Step17: Create new project (ODI_DEMO_SAN) in the designer window

Step18: Import all the required Knowledge modules by right clicking the Knowledge modules under the Project ODI_DEMO_SAN

              LKM file to SQL

              IKM Oracle Incremental Update 

 

 

Choose close in the import report

Step19: Creating new interface under the ODI_DEMO_SAN>First Folder>Interface Right click create new interface

          

Step20: In the definition window of overview tab specify the following details

              Name:     ODI_DEMO_INT_SAN

             Context:  Global

Step21: In the mapping window specify the details. Choose the Source and Target data stores from the model which we created in earlier stage (Step13). It asks for auto mapping and choose Yes for the auto mapping dialogue box and the results is follows

Note: We have to specify the key for the target table in the quick edit window of interface

Step22: Go to the flow tab in the interface specify the following details in the target (ODI_DEMO_SAN)

Choose Flow control as False and delete all as false.

Step23: Run the interface

Designer>project>ODI_DEMO_SAN>First Folder>Interfaces> ODI_DEMO_INT_SAN

Right Click and execute or Run directly from the options

        

Step24: Go to the operator navigator and check for the status under sessions, you will be getting all the Interfaces. Go to ODI_DEMO_INT_SAN and check for the Status.