My Oracle Support Banner

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

Last updated on JUNE 22, 2018

Applies to:

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


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(
at com.sunopsis.sql.SnpsConnection.testConnection(
at com.sunopsis.sql.SnpsConnection.testConnection( 

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.


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.