SAP Knowledge Base Article - Public

3611335 - Error "SQL error code =-709" when connecting HANA Cloud into SAP Datasphere

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