Thoughts, ideas and solutions from a few EPM consultants.

Installing ODI Studio with FDMEE

Prior to 11.1.2.3 FDMEE was known as ERPi and while it worked together with Oracle Data Integrator (ODI) they were seperate installs.

ODI's installer is good but I woudln't call friendly or great. The agent configuration in ODI for example is not part of the install and it also comes in two forms. The first one being the standalone, that was easy less difficult to setup but lacked many features. The second being the J2EE agent (preferred) which included an optional web based console and allowed for centralized configuration with the rest most of the EPM products in WebLogic. The J2EE agent required execution of commands using the WebLogic scripting tool and a somewhat manual deployment of the application to WebLogic that was quite unforgiving in single machine installs and downright mean in distributed deployments. On top of that once you got it configured if you wanted to run it as a service you would have to use OPMN or a third party service manager.

Once ODI was working ERPi could be configured. EPRi preferred the use of a specific type of ODI repository (execution) that should only hold scenarios. ERPi also required some a lot of manual configuration in the ODI topology.

With 11.1.2.3 things have gotten better (assuming FDMEE is installed, manual install ODI is still the same.) FDMEE really streamlines the process, in addition to installing the FDMEE interface it creates ODI repositories, installs the agent, sets it up as s service and configures it all to work together out of the box. The only thing missing is the install of the ODI Studio.

* The steps below assume ODI studio is being installed on a single server environment or on the same server as FDMEE in a distributed environment.

Install ODI Studio

I have always started the ODI install from command line since executing the setup without runtime parameters requires additional environment variables that I rarely set. To do so locate the ODI setup located in X:\Install Path\odi\Disk1. If you do so from windows explorer you can launch a command window from that directory by right clicking on the white space while holding down the Shift button.
Open Command Window with Shift

Once in the command window the setup can be launched. The jreLoc parameter will set the location of the Java Runtime Environment. Since its being installed on a server where EPM is already installed you can use the JDK that ships with EPM.
Lauching ODI Setup with jreLoc

Once setup is launched the Welcome screen will appear.
ODI Installer Welcome Screen

After the Welcome screen is Install Software Updates. Generally I select the Skip Software Updates radio button and continue.
ODI Skip Software Updates

After software updates ODI will prompt for the products to be installed. Since this is being installed on a server with FDMEE the agent and many componets of ODI are already installed and configured so only ODI Studio is needed with the ODI SDK being optional.
ODI Select Installation Type

After selecting the installation components ODI will continue to the Prerequisite Check screen.
ODI Prerequisite Check

Next on the Specify Install Location screen ODI will ask where to create a Oracle Home or where the existing Oracle home is located.
ODI Create or Upgrade Oracle Home

Locate the existing ODI Oracle Home created by FDMEE in the Middleware directory.
Locate ODI Oracle Home Created by FDMEE

ODI will then prompt to upgrade the existing ODI Oracle Home.
Upgrade existing Oracle Data Integrator 11g Home

Since FDMEE has already created a exising repository skip the repository configuraion on the Repository Configuraion screen.
Skip Repository Configuration

On the Specify Security Updates screen the user has the option to be notified of security issues.
ODI Specify Security Updates

The last screen before beginning the installation of ODI Studio is the Installation Summary.
ODI Installation Summary

Its likely errors and/or warnings will be encountered during installation. In the next section below I have listed the errors we enountered during my most recent installation. Once the install has completed the Configuration Progress screen will allow the process to continue.
ODI Install/Configuration Complete

Once completed an Installation Completed summary screen will finish the ODI install process.
ODI Installation Completed

Once completed it should be possible to launch ODI Studio from the start menu.
Launch ODI Studio on Windows

Next up is Configuring ODI Studio with FDMEE which I will cover in my next post.

Warnings and Errors

It is not uncommon to encounter warnings or errors during the ODI install. When doing this installation I encountered the following:

  • Warning
    • The install touches a component that is patched by an interim patches.
  • Errors
    • File not found: oracle.opss.client
    • File not found: oracle.odi.scheduler.manual
    • File not found: oracle.sysman.plugin.ai.odi
    • File not found: oracle.sysman.plugin.ai.main.oms.mw
    • File not found: oracle.fmwconfig

Below I have included the screenshots for reference.
ODI Warning: Interim Patches ODI Error: oracle.opss.client ODI Error: oracle.odi.scheduler.manual filegroup 2 ODI Error: oracle.odi.scheduler.manual filegroup 1 ODI Error: oracle.sysman.plugin.ai.odi ODI Error: oracle.sysman.plugin.ai.main.oms.mw filegroup 2 ODI Error: oracle.sysman.plugin.ai.main.oms.mw filegroup 1 ODI Error: oracle.fmwconfig filegroup 2 ODI Error: oracle.fmwconfig filegroup 1