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.

Advertisements

8 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.

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s