Installing the Connector for Oracle Essbase

In order to retrieve data from Oracle Essbase, you have to install its connector.

The Oracle Essbase API provides two modes of connecting to Essbase servers. The section Multidimensional Data Sources to Oracle Essbase of the Virtual DataPort Administration Guide provides more information about these modes.

The set of drivers you have to install, depend on the connection mode used:

  1. Three-tier APS mode: obtain the ess_japi.jar.

  2. Embedded mode: check the Administration Guide of Oracle Essbase to obtain the list of jars that a Java application needs to connect to Essbase in Embedded mode. Make sure that the version of the Essbase Administration Guide matches the version of your Essbase server because the jars required change depending on the release of Essbase you want to connect to.

After obtaining the appropriate jars, upload them to Virtual DataPort. Follow these steps to do this:

  1. Log in with the Administration Tool with an administrator account.

  2. Click the menu File > Extensions management.

  3. Click the tab Libraries and then, click Import.

  4. In the new dialog, in Resource type, select essbase.

  5. In Version, select the version you are going to upload.

  6. Click Add and select the file(s). To select more than one file, hold the key Ctrl and select each file.

  7. Click Ok to upload the file(s) to Virtual DataPort.