'Driver must be specified' When Testing Connections To Hyperion Server In ODI Topology Manager (Doc ID 762997.1)

Last updated on JULY 29, 2016

Applies to:

Hyperion BI+ - Version 9.0.0.0.00 and later
Information in this document applies to any platform.
***Checked for Relevance on 23-Jan-2012***


Symptoms

After creating a Hyperion Essbase/Planning/HFM Data Server in ODI Topology Manager and testing the connection to the Hyperion server, the following message is signaled :

java.sql.SQLException: Driver must be specified
at com.sunopsis.sql.SnpsConnection.a(SnpsConnection.java)
at com.sunopsis.sql.SnpsConnection.testConnection(SnpsConnection.java)
at com.sunopsis.sql.SnpsConnection.testConnection(SnpsConnection.java) 
at com.sunopsis.graphical.l.pm.a(pm.java).....

The issue can also happen when running an interface in which a wrong type of KM (SQL-type KM for Hyperion loading) is used. This is because the Hyperion ( Planning, Essbase, and HFM ) is not using standard JDBC connections, but an adapter / connector, which does not accept standard SQL commands, nor connection through JDBC to the Data Server.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms