3586084 - Error "Unable to connect to connproxy" when validate S/4HANA On-Premise connection in Datasphere

Cloud Connector is selected for Data Provisioning Option under Remote Tables section of S/4HANA On-Premise connection to use the ABAP SQL service to federate data with remote tables.

When validate the S/4HANA On-Premise connection in Datasphere, below error message is displayed in the details:

Remote Tables: Unable to connect remote source: [SAP][ODBCforABAP] (08001) Open backend connection: Unable to connect to connproxy-<hana_db_instance>:20003, Code: 5921, SQL State: HY000_

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."  

SAP Datasphere

1. Select the checkbox in front of the connection to S/4HANA On-Premise.
2. Click Validate button.

ConnectivityProxy on BTP is not enabled.

ConnectivityProxy should be enabled for all the HANA cloud under the Datasphere's tenant. The development team is checking the reason why it is disabled in some tenants. As a workaround, create a DS-DI-CON component case and send it to SAP support with below information:

1. The URL of your Datasphere.
2. Tenant ID and Database ID. (Navigation -> System -> About)
3. The technical name of problematic connection.
4. The message which is displayed when validate the connection.
   Remote Tables: Unable to connect remote source: [SAP][ODBCforABAP] (08001) Open backend connection: Unable to connect to connproxy-<hana_db_instance>:20003, Code: 5921, SQL State: HY000_

Datasphere operation team will enable ConnectivityProxy for that tenant.

Using ABAP SQL Services for Accessing Data from SAP S/4HANA

KBA , DS-DI-CON , Connections , Problem