Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
nagarjunakan
Helper I
Helper I

Sap Hana Connection

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.error.PNG

1 ACCEPTED SOLUTION
v-yiruan-msft
Community Support
Community Support

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

yingyinr_0-1638155107267.pngAlso, 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

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
v-yiruan-msft
Community Support
Community Support

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

yingyinr_0-1638155107267.pngAlso, 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

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.