Symptom
Error occurs when validating SAP HANA Cloud connection in SAP Datasphere:
Data Flows: Cause: Error occurred when connecting to Hana database. [SQL error code =-709]
Replication Flows: Cause: Error occurred when connecting to Hana database. [SQL error code =-709]
Remote Tables: Unable to connect remote source: [SAP AG][LIBODBCHDB SO][HDBODBC] Communication link failure;-10709 Connection failed
Environment
SAP Datasphere
Resolution
- Confirm the type of your source system, whether it is HANA Cloud or HANA On-premise.
- Ensure the hostname and port maintained in the connection settings are correct as explained at SAP HANA Connections.
- For connection to HANA Cloud enter the SQL port number of the SAP HANA Cloud instance: 443.
See Also
KBA 3384188 - Error "SQL error code =-709" when connecting HANA On Premise into SAP Datasphere
Keywords
"SQL error code =-709" , KBA , DS-DI-CON , Connections , Problem
Product
SAP Datasphere all versions