My Oracle Support Banner

OAC Essbase - Cannot Connect To On Premise SQL Databaser From Oracle Analytics Cloud Essbase web UI (Doc ID 2662203.1)

Last updated on JULY 26, 2022

Applies to:

Oracle Analytics Cloud - Version 18.3.3 and later
Information in this document applies to any platform.


When attempting to connect to an on-premise SQL database from OAC Essbase Cloud from Sources-> Connections, following error is shown
Failure-Test failed:[Oracle DataDirect][SQLServer JDBC Driver]Error establishing socket. Unknown host:

Similar error is shown when attempting to connect to an on-premise Oracle database or any other database.


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.