OracleBIBlog Search

Friday, August 14, 2009

ODI Installation on Windows Vista

Off late ODI is expected to be predominantly used for Data transformation needs more specifically to OBI needs. I just wanted to summarize the Oracle recommended system requirements and Prerequistes for installation of ODI and illustrate the steps for installation of ODI

System Requirements

Recommended System Requirements for Data Integrator Client:

512 MB RAM
300 MB Disk space
Operating system with graphical capabilities (such as Microsoft Windows, Linux, HP-UX, or Solaris)
Java Virtual Machine 1.5
Java Development Kit (SDK) 1.5
TCP/IP network

Recommended System Requirements for Data Integrator Agent:

512 MB RAM
200 MB free disk space on your hard drive
Others as for above for Data Integrator Client component

Recommended System Requirements for MetaData Navigator:

512 MB RAM
100 MB free disk space on your hard drive
J2EE 1.4 compliant application server, such as OC4J 10.1.3 and above
Others as for above for Data Integrator Client component

Recommended System disk space for Oracle Data Integrator Repository:

Master --> 30 MB

Working --> 40 MB. It varies depending on the size and volume of models and projects

Recommended System Requirements for Metadata Navigator:

Oracle Data Integrator also requires JDBC / JMS drivers

Oracle Data Integrator uses the JDBC (Java DataBase
Connectivity) standard for databases, JNDI (Java Naming and Directory Interface) and JMS (Java
Message Service) for MOM (Message Oriented Middleware).
Oracle Data Integrator does not include any third-party driver licenses.
Oracle Data Integrator requires the drivers for your different technologies to be installed in the /drivers sub-directory if they are not already referenced in the Java classpath.

Follow these steps to add a new driver for Oracle Data Integrator

1. Copy the driver packages (.zip or .jar files) to the /drivers sub-directory under the Oracle Data Integrator installation folder. Oracle Data Integrator will automatically detect the driver the next time it starts and will add these packages to the classpath. This must be done on each machine executing an Oracle Data Integrator component.
2. If the driver is used to connect a repository and you wish to use Metadata Navigator to connect to this repository, then copy the driver's packages in the /WEB-INF/lib subdirectory of the Metadata Navigator installation folder, then restart the application server.

Download Software

The latest software version ODI can be downloaded from

Select Oracle Business Intelligence (10.1.3) Media Pack for Microsoft Windows (32-bit) under Oracle Business Intelligence Product Pack and download Oracle Data Integrator, Oracle Data Profiling, and Oracle Data Quality for Data Integrator 10g ( for Windows Platforms (CD) with Part Number V14803-01

Extract the zipped file to a Folder eg: C:\ODI10.

Installation Steps

Click on Setup windows batch file located in eg: C:\ODISW\setup\Windows
It invokes the ODI setup through Oracle Universal Installer Window

Select the option button for Oracle Data Integrator and click Next
I have selected this as I just wanted to install this component. The default option is setting up all the components of ODI i.e Oracle Data Integrator, Oracle Data Profiling, Oracle Data Quality

Oracle Data Profiling is a component that is used for monitoring and analysing the data quality.

Oracle Data Quality is a component used for Data cleansing

Leave the default option for installation type as Complete which needs 281 MB Next. In case you select all components then the setup needs 1.18 GB of disk space

In this screen you have specify the Oracle Home path. Leave the default values and Click Next. If you need to change you may do that

Select Install
Click Exit after successful installation

Please follow another posting for ODI Modular Repository. It illustrates steps for creating and connecting ODI Modular Repositories