ODI - Installation version 10.1.3.5.0

Card Puncher Data Processing

LD_LIBRARY_PATH=/oracledq/quality_server/tsq11r5s/Software/bin
Creating 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:
  • In the Start Menu, select Programs > Oracle Data Integrator > Repository Management > Master Repository Creation, or Launch bin/repcreate.bat or bin/repcreate.sh.
  • Complete the fields:
    • Driver: the driver used to access the technology which will host the repository.
    • URL: The complete path for the data server to host the repository.
    • User: The user id / login of the owner of the tables (previously created under the name snpm).
    • Password: This user's password.
    • ID: A specific ID for the new repository, rather than the default 0. This will affect imports and exports between repositories.
    • Technologies: From the list, select the technology your repository will be based on.
    • Language: Select the language of your master repository.
    • Validate by OK.
Example for Oracle:
  • driver: oracle.jdbc.driver.OracleDriver
  • URL: jdbc:oracle:thin:@host:port:sid
Oracle Database - How to retrieve the connect descriptor parameters? (host, port, service name and SID)Odi Create Master Repository WizardFor driver and url of other database, see the page JDBC URL Sample.
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)
  • Click on the button New (first button to the right of the field Login name)
  • Complete the fields:
Odi Master Repository Connection The default password of the SUPERVISOR account is SUNOPSIS. For security reason, you must change it.Odi Topology Manager Change Password
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:
  • Connect to your master repository through the module Topology Manager
  • follow the picture below
Odi Create Working Repository
  • When the work repository has been created, the Work Repository window closes. You can now access this repository through the modules Designer and Operator.
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).
  • And follow the picture below :
Odi Designer Connection
Documentation / Reference





Discover More
Card Puncher Data Processing
ODI - Installation

ODI - Installation
Odi Jkm Oracle
ODI - Setting up Journalizing/CDC

This is the basic process for setting up CDC on an Oracle Data Integrator data model. Each of these steps is described in more detail below. Set the CDC parameters Add the datastores to the CDC ...



Share this page:
Follow us:
Task Runner