Installing ODI Developer Studio on OS X

This is not exactly rocket science but having searched and failed to find the solution out there in an easily digestible format I’ve written up a quick how-to to get up and running with ODI Developer Studio on OSX.

I needed to install odi studio. Note not a full install of odi but just the client install. The first difficulty was actually finding the software. So you can go to otn.oracle.com and try and find Oracle Data Integrator: or it’s much easier and faster searching google for odi +oracle.

What you don’t want if you just want the odi client running on OS X is to download Oracle Data Integrator. Ignore those siren calls, even the download for “All Platforms”. It might sound like just the ticket for a young developer on a shiny OS X box, but trust me this download will not help you.

No, if you are looking for ODI studio on OS X get yourself the Oracle Data Integrator Companion. Download this and you are left with a zip file: ofm_odi_companion_generic_11.1.1.3.3_disk1_1of1.zip (or 11.1.1.5.5 if you are after the latest).

Unzip the zip file and you will end up with the following:


[jason-mac][~/Downloads/odi]$ ls -F
agent_standalone/                         misc/                                   sdk/                                   xml-reference/
demo/                                   ofm_odi_companion_generic_11.1.1.3.3_disk1_1of1.zip     studio/

Descend to the studio directory, and you will see you are left with another zip file. Uncompress this and you are left with 2 directories:


[jason-mac][~/Downloads/odi/studio]$ ls -F
odi_misc/          oracledi/          oracledi-studio.zip

You are particularly interested in the oracledi directory descend to here and then the client directory within. However, you need a java jdk. Mine was located in the following location:


/System/Library/Frameworks/JavaVM.framework/Versions/1.6.0/Home

Have this location handy when you first run the odi.sh.

You will be prompted for the location:


./odi.sh 
Oracle Data Integrator 11g
 Copyright (c) 1997, 2010, Oracle and/or its affiliates. All rights reserved. 
Type the full pathname of a J2SE installation (or Ctrl-C to quit), the path will be stored in ~/.odi_jdk
/System/Library/Java/JavaVirtualMachines/1.6.0.jdk/Contents/Home
Error: Java home /System/Library/Java/JavaVirtualMachines/1.6.0.jdk/Contents/Home/bin/java is not a J2SE SDK.
Running ODI under a JRE is not supported.
If the Java VM specified by the SetJavaHome is actually a full J2SDK installation
then add 'SetSkipJ2SDKCheck true' to /Users/jason/Downloads/odi/studio/oracledi/client/odi/bin/odi.conf

As you can see even after giving it this location odi does not believe this is a true SDK, however if you add the

SetSkipJ2SDKCheck true

Entry to odi.conf file as directed and restart. ODI studio will finally start up.

10 thoughts on “Installing ODI Developer Studio on OS X

  1. Do you know how to do with Mavericks? I change the path :
    ./odi.sh
    Oracle Data Integrator 11g
    Copyright (c) 1997, 2010, Oracle and/or its affiliates. All rights reserved.
    Type the full pathname of a J2SE installation (or Ctrl-C to quit), the path will be stored in ~/.odi_jdk
    /System/Library/Java/JavaVirtualMachines/1.6.0.jdk/Contents/Home
    by Library/Java/JavaVirtualMachines/1.7.0.jdk/Contents/Home

    Then when I restart ODI it works, but it’s impossible to make a connection.

  2. yes it is not working for me either. ODI 12c Studio installation – Menus and Connect to Repository do not work. when clicked do not do anything.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s