This is a quick guide to manually installing ODI on a Windows machine. This will take a blank machine and set up a fully functioning ODI system. For this you must have a database in place already and have an account at oracle.com so you can download the software. You will also need 7-zip.

Get the Installation media (download the software)

1. Java
2. ODI

JAVA

Go to the Java Downloads | Oracle Page

Make sure you are in the Java 8 Section, and choose the Windows tab.

Click on the x64 Installer for the latest JDK 8 version, for windows, and it will download to your chosen location.

---

ODI

Go to the ODI download page Oracle Data Integrator Downloads

Click on the All platform link. This takes you to the edelivery page

here you select the Windows platform, tick the accept licence button, and press download. this will download an exe file that will do the actual download. You have to run the exe file and it will pop up a downloader. This tool is useful when you have lots of edelivery file to collect.

I did find this tool to be quite slow compared to the normal Oracle downloads.

Once it has download, then use 7-zip to extract the jar file from the zip.

---

Install

1. Java
2. ODI

Java

Click on the installer and follow the screens!

ODI

1. Install the Software
2. Configure a ‘domain’

The install of the software uses the java we installed above. It is a basic “java runs jar file” command

e.g. bin/java -jar jarfilehere.jar

In our case the command is:

java -jar e:\software\fmw_12.2.1.4.0_odi.jar

Follow the screens!

On my server at home it took about 10 minutes (I shortened the sequences in the video).

---

Configure the system

The next stage is to create the database objects that will hold the definitions for your ODI system. Everything is held in the database, which you would expect from Oracle!

The first step is to have a database that you can install into. I have added a PDB specifically for this in my 19c container database.

CREATE PLUGGABLE DATABASE odidemoPDB ADMIN USER odidemosys IDENTIFIED BY "Password";

ALTER PLUGGABLE DATABASE odidemoPDB OPEN READ WRITE

GRANT CREATE SESSION TO odidemosys WITH ADMIN OPTION;
GRANT SYSDBA TO odidemosys WITH ADMIN OPTION;

Check your Java version, make sure it complies with the system requirements.

Set the Java home variable

set JAVA_HOME=E:\java\jdk-1.8\bin

There is a defect in ODI that means the documentation is wrong here. You need to run

E:\odi\oracle_common\bin\rcu_internal.sh

The next step is to setup your ODI Studio

coming after the break….