3513085 - Error "-10709 Connection failed" "Network unreachable" when validate HANA connection in Datasphere

When creating connection to SAP HANA On-Premise, error is raised for remote table feature (SAP Cloud Connector used as Data Provisioning Option):

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 (XX.XX.XX.XX:Port-> HostName:Port)), 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 external (public) IPv4 address to Datasphere 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:

• The allowlist is not applicable to 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.
• When communication occurs between trusted networks over an untrusted network, a single public IP address (managed by Network Address, or NAT) is used.
• Therefore, if the Cloud Connector is installed in a private network, ensure that its public IP address is added to the SAP Datasphere allowlist - Trusted Cloud Connector IPs for untrusted network access.

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

Unable to connect remote source; "-10709 Connection failed"; "Network unreachable", "Data Provisioning Option", , KBA , DS-DI-CON , Connections , BC-MID-SCC , SAP Cloud Connector On-Demand/On-Premise Connectivity , Known Error