Spotfire client is not recognizing the ESSBASE connector.

Spotfire client is not recognizing the ESSBASE connector.

Resolution:

Oracle ESSBASE - Oracle ESSBASE 9.3, 11.1 Driver - Oracle Enterprise Performance Management System (11.1.2.3.0) Media Pack for Microsoft x64 (64-bit)

The driver must be installed on the machine running the Oracle connector. Note: The driver has to be downloaded from the Oracle Software Delivery Cloud. This will not work if you download the driver from any other location.

Download instructions:

You will need an Oracle account to be able to download the driver (free of charge).

When you reach the Media pack search page, Choose Product Pack: Oracle Enterprise Performance Management System, Platform: Microsoft Windows x64 (64bit). Download EPM System Release 11.1.2.3.0 Client Installers for Microsoft Windows In the Custom Setup screen make sure that both ESSBASE Client and ESSBASE Client C API will be installed.

Set the environment variables: EPMHOME to Oracle Enterprise Management System home, ARBORPATH to the destination folder chosen in the installer, ESSBASEPATH to ARBORPATH, PATH must include %ARBORPATH\bin and %EPMHOME\bin

AdapterESSBASE.spk and FormsAdapterESSBASE.spk are added in server (Deployment).

Installing the ESSBASE client along with ESSBASE Client C API.

Setting Environmental Variables.

Restart the Spotfire Server, Local System. Launch the Professional Client to see ORACLE ESSBASE as a connector.

Go to the Groups and Licenses tab and select the group for which to enable or disable the Oracle ESSBASE license.