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.....