Creating the Master Repository using ODI 11G studio

Creating the master repository creates an empty repository structure and seeds metadata (for example, technology definitions, or built-in security profiles) into this repository structure.


Step1: First you need to create schema for Master Repository
Open the sql developer
And create new schema with the name MasterRepo
Grant the required permissions

Step2: Start the ODI Studio

Step3: To create the master repository:

Open the New Gallery by choosing File > New.

In the New Gallery, in the Categories tree, select ODI.

step4: Select from the Items list the Master Repository Creation Wizard.

Click OK.

The Master Repository Creation wizard opens.

step 5:

Specify the Database Connection parameters as follows:

Technology: From the list, select the technology that will host your master repository. Default is Oracle.

JDBC Driver: The driver used to access the technology, that will host the repository.

JDBC URL: The URL used to establish the JDBC connection to the database.

Note that the parameters JDBC Driver and URL are synchronized and the default values are technology dependant.

User: The user ID / login of the owner of the tables (for example, odim).

Password: This user's password.

DBA User: The database administrator's username

DBA Password: This user's password

Note: It is strongly recommended that this ID is unique and not used for any other master repository, as it affects imports and exports between repositories


step6:
Specify the Repository Configuration parameters as follows:

ID: A specific ID for the new repository, rather than the default 0.



Click Test Connection to test the connection to your master repository.

The Information dialog opens and informs you whether the connection has been established. If the connection fails, fix the connection to your master repository before moving to next step.

Click Next.

Do one of the following:

step 7:

Select Use ODI Authentication to manage users using ODI's internal security system and enter the following supervisor login information:
Properties Description
Supervisor User User name of the ODI supervisor.
Supervisor Password This user's password
Confirm Password This user's password



Click Next.

step 8:

Specify the password storage details:

Select Internal Password Storage if you want to store passwords in the Oracle Data Integrator master repository

step 9:


In the Master Repository Creation Wizard click Finish to validate your entries.

www.odiguru.com