Saturday, 26 March 2011

Configuring ODI for integrating with Hyperion Financial Management Application

I will be using Single-machine architecture; machine will be hosting ODI and hosting HFM and EPM foundation (Workspace and shared services). I have created a FM application named SAMPLE that is based on the “Simple Demo” information that can be found in “Hyperion\products\Financial Management\Sample Apps\Simple Demo\” of the HFM installation.

The machine is windows based as that is a pre-requisite for HFM and also the HFM client that has to be installed on the ODI machine.
The EPM version installed is
We need to perform some work around solutions for integrating ODI 11g with EPMA

Step: 1) Go to directory C:\oracle\Middleware\Oracle_ODI1\oracledi\agent\lib Copy the HFMDriver.dll file and pest it to directory

Step: 2) If you will use the “Local Agent” you will need to add the driver location to the windows environment variable (Path).

Once you have added the location make sure you restart all the ODI components to pick up the driver or you will continue to receive the error message.


  1. Excellent Share! An exciting dialogue is well worth comment. I think you ought to compose much more on this matter, it may well not be considered a taboo issue but typically individuals usually are not enough to speak on this sort of topics.

    financial management

    1. Thanks.....

      I will try to post more details on it.

  2. Hi there, awesome site. I thought the topics you posted on were very interesting. I tried to add your RSS to my feed reader and it a few. take a look at it, hopefully

    I can add you and follow.

    Expenses Management Application