ODI version history

Oracle Data Integrator History about all Version Releases

Oracle acquired sunopsis and released ODI 10G in October 2006

Find the version release history below:

Hardware and system configuration requirements for Oracle Data Integrator

Steps for Changing SUPERVISOR user password in Oracle Data Integrator

Please find the steps below to change SUPERVISOR user password in Oracle Data Integrator

 On the server running the ODI client,

Click on start -> All Programs -> Oracle -> Oracle Data Integrator -> ODI Studio- Navigate on ODI Studio

Click on left pane ->   Connect to Repository -> pop up the Master Repository with
Supervisor -> click on OK 

Go to
View -> ODI Security Navigator ->  click on users -> click on "Supervisor " -> on right pane click on "change password"


On the server running the agent,

Browse to cd $ODI_HOME/oracledi/agent/bin

Take the backup of the file odiparams.sh

Run the command

./encode.sh  “new password”

Copy the encoded password to odiparams.sh in the following location
 ODI_SUPERVISOR=SUPERVISOR
 ODI_SUPERVISOR_ENCODED_PASS=

Restart services.

 Now logging odi studio as SUPERVISOR / "new password"

Step by step installing fusion middleware infrastructure , odi 12c and creating master and work repositories and setting up topology on windows system

Installing Infra Structure for odi 12c 12.1.3.0.0

click next

specify the path for oracle home and click next

click next

click next

uncheck and click next

click install

click next

click finish

Installing ODI 12c

click next

click next

select enterprise installation and click next

click next

click install

click next

click finish

Creating Master and Work Repositories schemas Manually

Creating Repositories in ODI

Creating Master Repository

Start ODI Studio

click on file and click on new

select create a new master repository and click ok

Provide the database and schema details and click on test connection

click ok

click next

Provide the password for supervisor user and click next

click finish

click ok

Connecting to Master Repository

select create a new odi repository login and click ok

provide all the details and click test

click ok

click ok

If you want to store the password in secure wallet select option store password in secure wallet  and provide a password for the wallet and click ok

otherwise select store passwords without secure wallet and click ok

Enter the login details and click ok

Creating Work Repository

In the technology tab under repositories section right click on work repository and click new work repository

give the database and work repository details and click test connection

click ok

click next

click finish

click no

Connecting to Work Repository

give all the details

select work repository and click on search

select odi work repo and click ok

click test

click ok

click ok

click ok

Setting Topology In ODI

Go to Topology> Context

Click New to create a new context

Specify the Name of the context

Example: DEV

Go to TOPOLOGY > TECHNOLOGIES > ORACLE

Create a New Data Server

Specify the Data server Name and connection details in definition tab

In JDBC tab Click on   icon

Select the Driver and click OK

Specify the JDBC Url

Click ‘Test connection’ to test the connection