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.
Excellent clear article. can I run the ODI
agent on mac os x
I was not able to run it by specifying the path you provided but using /Library/Java/Home worked. Otherwise everything was the same, thanks!
Your JDK path may not be the same.
Thanks!! very nice and clear article!!!
Do you happen to know where the snps_login_work.xml file is located on the Mac? I can’t seem to find it anywhere.
Thanks for the great article.
Found it – it’s in a system folder “.odi” under your /Users/username/.
Michael Rainey
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.
I have the same problem.. but i’m using Mojave instead of Mavericks
Any luck getting ODI 12c working under OSX? The menus don’t work for me at all….
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.