Product: TIBCO Spotfire®
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 (126.96.36.199.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 188.8.131.52.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.