Creation of Master and Work Repositories

 Master Repository Creation:

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

 

Step 8:

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

   Work Repository Creation:

 Several work repositories can be designated with several master repositories if necessary. However, a work repository can be linked with only one master repository for version management purposes.

To create a new work repository: First create the schema for work repository

I am using sql developer to create schemas

\

 

In the Topology Navigator, go to the Repositories panel.

Right-click the Work Repositories node and select New Work Repository.

The Create Work Repository Wizard opens.

Specify the Oracle Data Integrator work repository connection details as follows:

 

Technology: Choose the technology of the server to host your work repository. Default is Oracle.

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

JDBC URL: The complete path of the data server to host the work repository.

 

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

 

User: User ID / login of the owner of the tables you are going to create and host of the work repository.

Password: This user's password. This password is requested for attaching this work repository to a different master.

Specify the Oracle Data Integrator work repository properties:

 

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

 

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

 

Click Test Connection to verify that the connection is working.

 

Click Next.