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