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_18.104.22.168.3_disk1_1of1.zip (or 22.214.171.124.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_126.96.36.199.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:
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
Entry to odi.conf file as directed and restart. ODI studio will finally start up.