Start work with ODI.Creating Master Repository,Work Repository,Physical Schema,Logical Schema

Before you start your work,There are pre-requisite steps that need to follow.
First, you should have data base installed  in your machine/should have Creadentials of other database.


Orace XE is a very light database,we can use it to start a work.


1)Creating Master Repository
    Security information and Topology information(Physical Schema OR Logical Schema information)
    are kept in master repository.


    I have installed XE in my local machine and has a schema SYSTEM.


    To create master repository,
    Start menu-----> All Programme---->Oracle------>Oracle data integrator---->Repository Management-      
    --->Master Repository Creation. enter details,click on Test Connection,it should success.


    click OK,Master repository will be created in few seconds.


      

   








2)Creating Work Repository
     Your work(We will see that ProcedureInterface/Package) will be stored into work repository.
 
     To create work repository,
     Start menu-----> All Programme---->Oracle------>Oracle data integrator---->Topology Manager.


     Create new connection,
   

           Login Name:Give any Login name you want.
           Login Name:SUPERVISOR
           password:SUNOPSIS.


           Enter others detail and Test connection by clicking Test button,it should success.then click OK.


           You will see window which has shown below,Insert Work repository
          
            I am using same schema SYSTEM for both master and work repository,you can create new shema
            for work repository if you want.Also enterJDBC details in new Data server.

      Now,to start Designer,
      Start menu-----> All Programme---->Oracle------>Oracle data integrator---->Designer.


      You will have,
    

           Login Name:Give any Login name you want.
           Login Name:SUPERVISOR
           password:SUNOPSIS.


           In Work Repository section,click on find button.It will show Work Repository that you have 
           created. Click OK,you will be having Desiner window.

          
 

      ***Physical and Logical schema are like body and soul,they are link to each other.
3)Physical Schema
     To Create Physical shema,Go to Topology manager---->physical schama
     
     If you want to connect ODI with Oracle database,In technology right click on Oracle,

      Give name to physical schema,enter credentials of database you want to connect,give JDBC parameter
      and Test it.it should success.I have connectd with localhost PC,with SYSTEM schema.


4)Logical Schema
      Its a logical name given to Physical schama


     To Create Logical Schema ,Go to Topology manager---->Logical Schema.

            Give any name that you want.Click OK.


   If you have followed upto this successfully,then you can start working on Examples/Practice..... 

Installing Oracle data integrator.

Installing Oracle data integrator is a very simple process,Just click next,next and you have done!!
Below is a first screen when you installing ODI.

Getting Started with an ETL tool,Oracle Data Integrator.

Oracle Data Integrator is a Extract,transform,load tool from Oracle.In a simple way,It can extract data from one technology(Database/Application) and can load to another technology.


To extract/transform/load data by ODI,only 1 PC need to have install ODI.We can connect this ODI installed PC to different PC/database/application(Oracle apps or any...) and work can be done.