Create Master and Work Repository in ODI

The Oracle Data Integrator Repository is composed of one Master Repository and

several Work Repositories. Objects developed or configured through the user interfaces

are stored in one of these repository types.

There is usually only one master repository that stores the following information:

■ Security information including users, profiles and rights for the ODI platform

■ Topology information including technologies, server definitions, schemas,

contexts, languages and so forth.

■ Versioned and archived objects.

The work repository is the one that contains actual developed objects. Several work

repositories may coexist in the same ODI installation (for example, to have separate

environments or to match a particular versioning life cycle). A Work Repository stores

information for:

■ Models, including schema definition, datastores structures and metadata, fields

and columns definitions, data quality constraints, cross references, data lineage

and so forth.

■ Projects, including business rules, packages, procedures, folders, Knowledge

Modules, variables and so forth.

■ Scenario execution, including scenarios, scheduling information and logs.

When the Work Repository contains only the execution information (typically for

production purposes), it is then called an Execution Repository.

Before creating master repository in ODI we need to create RDBMS schema/user for the master repository

CREATE USER ODIM IDENTIFIED BY <PASSWORD>

DEFAULT TABLESPACE ODI_TBS TEMPORARY TABLE SPACE TEMP1;

GRANT CONNECT,RESOURCE TO ODIM;

Start menu -> All programs-> oracle-> Oracle Data Integrator -> ODI Studio select new and then select master repository creation wizard

Creating ODI Repository Login

Creating Work repository

Before creating work repository in ODI we need to create RDBMS schema/user for the work repository

CREATE USER ODIW IDENTIFIED BY <PASSWORD>

DEFAULT TABLESPACE ODI_TBS TEMPORARY TABLE SPACE TEMP1;

GRANT CONNECT,RESOURCE TO ODIW;

Thanks,
Haree