Sap Hana Connection

[nagarjunakan]

Hi,

I am unable to connect SAP Hana database. I have installed SAP HANA ODBC drivers

When i click on Connect got this error

Details: "ODBC: ERROR [08S01] [SAP AG][LIBODBCHDB DLL][HDBODBC] Communication link failure;-10709 Connect failed (connect timeout expired)"

Please find the attached extarct for more info.

Help me in this regard.

[v-yiruan-msft · Accepted solution]

Hi @nagarjunakan ,

First, make sure that you have the proper SAP HANA ODBC Driver installed. For more details, you can check the official documentation below.

Prerequisites

Also, there are some threads here with a similar problem to yours, please check if the solution in it can help you solve the problem.

-10709: Connection failed (RTE:[89006] System call 'connect' failed, rc=111

ERROR: "[SAP AG][LIBODBCHDB SO][HDBODBC] Communication link failure;

---

Solution

​Make sure that the connection string for relational ODBC connection in Workflow Manager and data source name in odbc.ini file are exactly the same.

---

Finally, you can refer to the following document to connect to SAP HANA in Power BI Desktop.

Connect to sap HANA Database from Microsoft power BI(Business Intelligence)

Connect to an SAP HANA database from Power Query Desktop

Best Regards