SAP Knowledge Base Article - Public

3508341 - Unknown Host error when connecting via JDBC to Datasphere's HANA Cloud

Symptom

Error when attempting JDBC connection with datasphere HANA Cloud database:

"Unknown host ***.&SQLendpoint***...hanacloud.ondemand.com:443"

Environment

SAP Datasphere

Reproducing the Issue

You configure a new JDBC connection:

  1. Add egress rule for datasphere's Hana Cloud  "*.hanacloud.ondemand.com"
  2. Inform name for connection, hostname and remaining details and save configuration
  3. You validate the created connection and get this error with additional SQLEndpoint on URL:

    ***.&SQLendpoint***...hanacloud.ondemand.com:443

Cause

Depending on the used SAP HANA Cloud database version, the used features and the SAP HANA Client version, different features are available which in addition to the public SQL endpoint require the usage of internal SQL endpoints.

Resolution

This is the system working as designed as you are required to add on setup the SQL endpoints used in HANA Cloud system to your URLs in configuration.

See Also

KBA 3325646 - SQL Endpoints Used by SAP HANA Cloud Database 

Keywords

KBA , DS-DI-CON , Connections , HAN-CLS-DB , HANA Database as a Service , How To

Product

SAP Datasphere all versions