How To Create Master repository in ODI 11 G(Oracle Data Integrator)

How To Create Master and Work Repository:

Step 1: Prerequisites for working with ODI:

·         ODI should be installed, for configuring ODI we need Master repository and Work repositories. These repositories can be created in two ways:

1)      First way is to create the repositories in the DB(Data Base) and then use it in the configuration, the steps for this is given in Step 2 and the

2)      Second method is to do it through RCU (Repository Creation Utility), steps for this is given in Step 3.

For Complete step 2(Create repository in the DB) we have to create user in the DB. The user can be created in Oracle  (this user can be created in any RDBMS).

Find Scripts to create users in the DB.

--------------------------------------------------------

 SCRIPT FOR CREATING ODI User

--------------------------------------------------------

CREATE USER SINGH_DEV_ODI_REPO IDENTIFIED BY DEV_ODI_REPO;

GRANT CONNECT, RESOURCE TO SINGH_DEV_ODI_REPO ;

Note: Here SINGH_DEV_ODI_REPO is a Username and

Password: DEV_ODI_REPO. We will create this username in the data base and then use this user for Creating Master Repository.

·         Execute the script in any user with SYSDBA privilege.

Important: We can create any number of Master repositories and Work Repositories

Step2:  How to Create Master Repository and Work Repository :

Open ODI Studio: StartàAll ProgramàOracleàOracle data integratoràODI studio

ODI(Oracle Data Integrator)Start Page will open

Click on File->New and below window will be opened.

Select Master Repository Creation Wizard ---then Click :Window will openàMaster Repository Creation Wizard step1 of 3:

Technology:Oracle (Select any RDBMS).

JDBC Driver:Select respective Driver that supports selected technology.

JDBC URL:enter the specific information of the system on which oracle is available.                                                      

User:<Master Repository User name> ex: SINGH_DEV_ODI_REPO

Password:<Master Repository User’s Password>Ex: DEV_ODI_REPO

DBA User:<DBA User name> Ex: User name which you user during oracle installation

DBA Password:<DBA User’s Password> Ex: password which you user during oracle installation

Test the connection, Enter the ID for master repository and click Next, this creates Master repository related tables in the Oracle user that we have used for Master repository for the first time