ODI - Installation version 10.1.3.5.0

About

The Oracle Data Integrator installation program includes three products and gives you four installation options depending on the solution you want to install: The complete installation includes :

for Oracle Data Integrator.

Prerequisites

For Oracle Data Integrator

Oracle Data Integrator Client

  • Any OS with Windows or X/Windows capacities (Windows, Linux, HP-UX, Solaris etc.)
  • 512 MB of RAM
  • 150 MB hard disk
  • TCP/IP
  • A Java Development Kit (SDK) 1.5. to use Web Services

Oracle Data Integrator Agent

In order to run an Agent, your computer must meet the following minimum system requirements.

  • 512 MB RAM
  • 200 MB free disk space on your hard drive
  • An operating system supporting a Java Virtual Machine 1.5.
  • A Java Development Kit (SDK) 1.5
  • A TCP/IP network.

Oracle Data Integrator Repository

The Repository can be installed on any relational database engine supporting ANSI ISO 89 syntax, such as Oracle, Microsoft SQL Server, Sybase AS Enterprise, IBM DB2 UDB, IBM DB2/400, etc.

You can also use for evaluation purposes the demo repository provided with Oracle Data Integrator. This repository is based on an Hypersonic SQL Database and requires no particular installation.

The storage space requirements for repositories are the following:

  • Master Repository: 30 Mb of storage space.
  • Work Repository: 40 Mb of storage space. <note info>Note that the storage space required may vary

depending on the size of your models and projects, and on the volume of execution logs you keep in this repository.</note>

Metadata Navigator/Lightweight Designer

In order to run a Metadata Navigator or Lightweight Designer, your computer must meet the following minimum system requirements:

  • 512 MB RAM
  • 100 MB free disk space on your hard drive
  • An operating system supporting a Java Development Kit (SDK) 1.5
  • J2EE 1.4 compliant application server, such as OC4J 10.1.3 and above.
  • A Java Development Kit (SDK) 1.5.
  • A TCP/IP network.

For Oracle Data Quality Products

Oracle Data Quality Client

In order to use Oracle Data Quality, your computer must meet the following minimum system requirements. Minimum System Requirements:

  • 1 GB RAM
  • 400 MB free disk space on your hard drive
  • Operating Systems: Microsoft Windows 2000 Professional/Server with SP4, Microsoft Windows XP Professional with SP2, Microsoft Windows Server 2003 Standard Edition, SP1 (32 bit).
  • Internet Explorer v5.5 or greater.
  • A 10 Mbps TCP/IP network.

Oracle Data Profiling and Data Quality Server

In order to use Oracle Data Quality products, your computer must meet the following minimum system requirements. This configuration is typically for 2 Oracle Data Profiling/Quality users and an overnight data quality processing load.

  • 4 GB RAM (8 GB for a power server - For 10 users and a normal daytime load)
  • Disk space depends on the data processes, we recommend 1,5 GB plus 2 to 5 times the size of the data sources.
  • Operating Systems:
    • UNIX: AIX 5L (v5.1, 5.2, and 5.3), Solaris 8, 9 or 10, HP-UX 11.i V1 (PA RISC), HP-UX 11.i V2 (IA64), Linux Red Hat Enterprise Linux 2.1 and above, Linux Suse Version 9.2 Professional and above
    • The Inetd component (XInetd for Linux) must be installed on the UNIX machine.
    • Windows: Windows: Windows 2000 Server with SP 3, Windows Server 2003 Standard Edition with SP 1 (32 bit)
  • A 1 GB TCP/IP network.

Installing JDBC / JMS drivers

To connect to different data servers, Oracle Data Integrator need the installation of drivers

Java Configuration

Oracle Data Integrator requires a Java Virtual Machine (JRE) or Software Development Kit (SDK)

Java Virtual Machine

You should use the JVM supplied by the Oracle Data Integrator installation program. If you want to use your own Java machine, you need to install it.

It is recommended that you use the JVM 1.5.x for all Oracle Data Integrator client installations. All clients should have identical JVMs.

Java Development Kit to use Web Services

Using Web Services with Oracle Data Integrator requires a Java Development Kit (SDK) 1.5. The SDKs are not provided in the setup programs, and should be installed separately.

The warning “A JDK is required to execute Web Services with Oracle Data Integrator. You are currently using a JRE.” may appear when starting Oracle Data Integrator components. Ignore this warning.

Installation Steps

Note: This setup program creates shortcuts to the installed Oracle Data Integrator components.

Installing Oracle Data Integrator from a Downloaded File:

Start Oracle Universal Installer

  • On Windows, run \CD_10.1.3.5.0_WINDOWS\setup\Windows\setup.bat
  • On Linux, Unix, Enter the following command at the operating system prompt: ./runInstaller

Oracle Universal Installer Launch with the Welcome Page, click next

Product Type to Install and Home Detail

  • Select the product to install. The first choice include all options. Click Next
  • Select the type of installation (Complete, Client, Server) and hit the next button.
  • Specify the Home Detail and click Next (see the picture below for example)

_

Server Installation Type

The configuration page of the data profiling and quality server appears if you have selected server installation type.

_

The port numbers should be greater than 1000 and not exceed 65535, and for easy reference, should be consecutive numbers. (For example, 7600 for the Repository Port and 7601 for the Scheduler Port.)

How to define the available port ? On Windows, on linux

Define the Metabase configuration as follows:

  • Repository Port: Port for the Metabase repository. Default is 7600.
  • Scheduler Port: Port for the Oracle Data Quality scheduler. Default is 7601.
  • Administrator Name: Metabase administrator name. Default is madmin.
  • Administrator Password: Metabase administrator password (In this example, madmin)

Enter the data and hit the Next Button.

Client installation type

The Metabase Connection screen appears if you have selected the Client installation type. This screen configures the client to connect to a specific Metabase and repository.

_

Specify the Metabase connection as follows:

  • Hostname: Name of the host where the Oracle Data Profiling or Oracle Data Quality for Data Integrator server components are installed. If you are installing these components on the same machine, enter localhost.
  • Scheduler Port: Port for the Oracle Data Quality scheduler. Default is 7601.
  • Repository Port: Port for the Metabase Repository. Default is 7600.
  • Repository Name: Name of the Repository.

ODBC Adapter Configuration

The Oracle Data Quality ODBC Adapter Configuration screen appears only if you have chosen the server or complete installation type for Oracle Data Profiling. Set the ODBC Adapter port as follows:

ODBC Port: 7602

Click Next and install the software.

At the end, you must be able to see the services :

_

Post Requisites on Unix/Linux

On UNIX platforms add the following environment variables for the user who has installed Oracle Data Integrator:

  • ODI_JAVA_HOME=<ODI_HOME>/jre/1.4.2
  • TS_QUALITY=<ODI_HOME>/oracledq/quality_server/tsq11r5s/Software
  • LD_LIBRARY_PATH=<ODI_HOME>/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 of the execution log, in order to reduce the work repository size, and backup of the databases hosting the repositories.

Oracle Data Integrator includes out of the box a repository which can be used for test and 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 each database 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. On the 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 Documentation / Reference).

Create:

For reasons of maintenance and back-up, we strongly recommend that repositories be stored in a different space from where your application data is kept (for example in a different SCHEMA under ORACLE, or even in a different database under SYBASE or Microsoft SQLServer).

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 9i The Repository installation and the temporary objects creation use the CHAR semantics syntax for creating VARCHAR columns on Oracle. This syntax is not supported on Oracle version before 9i. To install a repository on such an Oracle version, edit the TECH_Oracle.xml file in the /lib/scripts/xml/ sub-directory of Oracle Data Integrator installation folder, and replace the VARCHAR2(%L CHAR)string by VARCHAR2(%L).

Creating the Master Repository

Creating the master repository consists of creating the tables and the automatic importing of definitions 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)

_

For 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:

_

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:

  • Connect to your master repository through the module Topology Manager
  • follow the picture below

_

  • 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 :

_

Documentation / Reference


Powered by ComboStrap