LD_LIBRARY_PATH=/oracledq/quality_server/tsq11r5s/Software/binCreating Repositories
There are two types of repositories:
Master Repository: Data structure containing information on the topology of the company's IT resources, on security and on version management of projects and data models. This repository is stored on a relational database accessible in client/server mode from the different Oracle Data Integrator modules. In general, you need only one master repository.
Work Repository: Data structure containing information on data models, projects, and their use. This repository is stored on a relational database accessible in client/server mode from the different Oracle Data Integrator modules. 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.The steps to follow to create repositories are detailed below:
Creating repository storage spaces
Creating the master repository
Connecting to the master repository
Creating a work repository
Connecting to the Work repository
Note: It is recommended to regularly perform the following maintenance operations: Purge ofthe execution log, in order to reduce the work repository size, and backup of the databaseshosting the repositories.Oracle Data Integrator includes out of the box a repository which can be used for testand demonstration purposes, through the script
/bin/startdemo.
Creating Repository Storage Spaces
Repositories can be installed on any database engine supporting ANSI ISO 89 syntax . In eachdatabase that is to hold a Repository, a storage space must first be created. Your master repository can be stored in the same schema as one of your work repositories. Onthe other hand, you cannot create two different work repositories in the same schema.The examples below is supplied for the Oracle database. Other databases examples can be found in the installation guide (see section documentationreference).Create:
For reasons of maintenance and back-up, we strongly recommend that repositoriesbe stored in a different space from where your application data is kept (for example in adifferent SCHEMA under ORACLE, or even in a different database under SYBASE or MicrosoftSQLServer).
create user snpm identified by snpm;
grant connect, resource to snpm;
create user snpw identified by snpw;
grant connect, resource to snpw;
Installing the repositories on Oracle versions before 9iThe Repository installation and the temporary objects creation use the CHARsemantics syntax for creating VARCHAR columns on Oracle. This syntax isnot supported on Oracle version before 9i. To install a repository on such anOracle version, edit the TECH_Oracle.xml file in the /lib/scripts/xml/sub-directory of Oracle Data Integrator installation folder, and replace theVARCHAR2(%L CHAR)string by VARCHAR2(%L).
Creating the Master Repository
Creating the master repository consists of creating the tables and the automatic importing ofdefinitions for the different technologies.To create the master repository:
Creating the dictionary begins. You can follow the procedure on your console. Connecting to the master repository
In the Start Menu, select Programs > Oracle Data Integrator >
Topology Manager, or
launch the Topology Manager script (bin/topology.bat or bin/topology.sh)
The default password of the SUPERVISOR account is SUNOPSIS. For security reason, you must change it.Creating a Work Repository
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 launch a work repository creation:
Connecting to a Work Repository
To connect to a work repository and launch the Designer module:
In the Start Menu, select Programs > Oracle Data Integrator >
ODI - Designer, or launch the
Designer script (bin/designer.bat or bin/designer.sh).
Documentation / Reference