TIBCO Spotfire installed client is not recognizing the Oracle Essbase connector.

TIBCO Spotfire installed client is not recognizing the Oracle Essbase connector.

When launching the TIBCO Spotfire installed client, the Oracle Essbase connector as seen in File > Add Data Tables > Add > Connection To: Oracle Essbase is disabled and unavailable (greyed out). 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 TIBCO Spotfire installed 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. Use the attached document (Filename:Oracle_ESSBASE_client_installation_checks.doc) as a reference.