3513085 - Remote tables fail due "-10709 Connection failed" "Network unreachable" via Cloud Connector Data Provisioning

When creating connection to SAP HANA On-Premise, error is raised:

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

Remote Tables: Unable to connect remote source: 
[SAP AG][LIBODBCHDB SO][HDBODBC] Communication link failure;
-10709 Connection failed (RTE:[89133] Proxy server connect: 
Network unreachable (100.96.165.36:46936 -> ecddbds:30641)), Code: 5921, SQL State: HY000

SAP Datasphere

Cloud Connector's IP is missing in Datasphere's allowlist.

Follow SAP Help Prepare Connectivity to SAP HANA

If you want to use SAP HANA Smart Data Access:

• An administrator has added the Cloud Connector IP address to the IP allowlist.

  For more information, see Add IP address to IP Allowlist.

"Trusted Cloud Connector IPs: For Cloud Connectors that you want to use for federation and replication with remote tables from on-premise systems such as SAP HANA"

NOTE:

Allowlist is NOT relevant for private IP ranges (10.0.0.0 ~ 10.255.255.255, 172.16.0.0 ~ 172.31.255.255, 192.168.0.0 ~ 192.168.255.255)
Trusted networks use private IP addresses to communicate within trusted environment.
Communication between the trusted networks over an untrusted network, use a single public IP address. Network Address Translation (NAT) manages this communication.
Therefore if the Cloud Connector is installed in a private network, make sure to add the public IP address into SAP Datasphere's Allowlist for untrusted networks.

Support Content How to setup SAP Cloud Connector connect to SAP Datasphere

KBA , DS-DI-CON , Connections , Known Error