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 APRIL 27, 2020

Applies to:

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

Goal

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.
 

Solution

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
Goal
Solution
References


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