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:
Three-tier APS mode: obtain the
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:
Log in with the Administration Tool with an administrator account.
Click the menu File > Extensions management.
Click the tab Libraries and then, click Import.
In the new dialog, in Resource type, select essbase.
In Version, select the version you are going to upload.
Click Add and select the file(s). To select more than one file, hold the key Ctrl and select each file.
Click Ok to upload the file(s) to Virtual DataPort.
Requirements of the Essbase 11 Adapter¶
If you are using 8.0u20210715 or newer, the user account in Essbase requires the role “read”.
If you are using Denodo 8.0 GA or 8.0u20210209, to connect to Oracle Essbase 22.214.171.124 or newer, the user account in Essbase requires the role “manager (database)”. This is necessary to be able to introspect cubes. That is, to list the contents of the cubes during the process of creating base views. This user account needs this role because by default, the data source opens the outline of the cube.
By default, with the update 8.0u20210209, the user account also requires the role “manager (database)” but you can disable this requirement if you want. To do this, log in to Virtual DataPort as an administrator and execute this command (you do not need to restart after this):
SET 'com.denodo.vdb.essbaseAvoidOpenOutline' = 'true';
With this change, the user account for Essbase only requires the role “read” because it does not open the outline of the cubes. Note that you still need the “execute” role as well to be able to execute queries.