HFM Driver and ODI on Windows 2008R2


Installing the HFM Driver for ODI on Windows 2008R2 (64bit)

Download the Oracle Data Integrator Companion from http://www.oracle.com/technetwork/middleware/data-integrator/downloads/index.html.

Extract the files and browse to the \sdk\oracledi-sdk.zip\oracledi.sdk\lib directory in the downloaded zip file. Rename the files listed in the “Rename” section in the two directories below, and then copy the files in the “Copy” section to the same two directories.

ODI Agent:

  • E:\Oracle\Middleware\Oracle_ODI1\oracledi\client\jdev\extensions\oracle.odi.navigator\lib
  • E:\Oracle\Middleware\Oracle_ODI1\oracledi\agent\drivers

Local ODI Console (ODI 11g Studio):

  • E:\Oracle\Middleware\Oracle_ODI1\oracledi.sdk\lib

Rename the following files in the above directories:

  • HFMDriver.dll  -> HFMDriver.dll.orig
  • odi_hfm.jar -> odi_hfm.jar.orig

Copy these files to the above directories:

  • HFMDriver64_11.1.2.2.dll -> Rename to HFMDriver.dll
  • odi_hfm.jar (copy to E:\Oracle\Middleware\Oracle_ODI1\oracledi.sdk\lib after stopping agent)

*The configuration is easier if you also copy the HFMDriver.dll file the %windir%\system32 directory.

Update the Environment Variables to include the ODI SDK directories by executing the following at the command prompt:

setx PATH “%PATH%;E:\Oracle\Middleware\Oracle_ODI1\oracledi.sdk\lib” /M



Add a Comment

Your email address will not be published. Required fields are marked *

(adsbygoogle = window.adsbygoogle || []).push({});