SAP Knowledge Base Article - Public

3366756 - Datasphere HANA Cloud connection error Remote source is down

Symptom

When connecting HANA Database (Cloud) with SAP Datasphere. Getting below error when validating HANA connection in SAP Datasphere, even though HANA Database is up and running.

Connection "XXXX" is valid, but not all features are available.
- Data flows can't be used because of errors in the connection.
- Replication flows can't be used because of errors in the connection.
- Remote tables are enabled.

Data Flows: Cause: Remote source is down! Code:1
Replication Flows: Cause: Remote source is down! Code:1

Environment

SAP Datasphere

Reproducing the Issue

  1. Log into SAP Datasphere --> Connection
  2. Select the connection and click "Validate" button.
  3. Get the above message in symptom.

Cause

IP Address not added into allowlist.

Resolution

1. Find the Outbound IP of Datasphere. See https://help.sap.com/docs/SAP_DATASPHERE/9f804b8efa8043539289f42f372c4862/0934f7ed9a534e638299f53ab60866ae.html?locale=en-US

2. Add this outbound IP to the HANA Cloud instance's allowlist. See https://help.sap.com/docs/hana-cloud/sap-hana-cloud-administration-guide/managing-sap-hana-database-instances?locale=en-US

3. Find the public IP of HANA source. See https://help.sap.com/docs/hana-cloud/sap-hana-cloud-administration-guide/domains-and-ip-ranges?locale=en-US

4. Add this IP to Datasphere's allowlist. See https://help.sap.com/docs/SAP_DATASPHERE/9f804b8efa8043539289f42f372c4862/a3c214514ef94e899459f68f4c1e2a23.html?locale=en-US

Keywords

KBA , DS-DI-CON , Connections , Problem

Product

SAP Datasphere all versions