Ms Fabric SAP Hana Connector Issue

Kartik_K — Thu, 12 Sep 2024 12:33:39 GMT

Hi all,

Background:

I have been successful in connecting to SAP BW (hosted in cloud) with Ms Fabric using Dataflow Gen 2 connector. However, I am now working on connecting a SAP HANA Database (hosted by SAP in cloud) with Microsoft Fabric using the Dataflow Gen 2 connector, and have issues configuring the ODBC connector and the Online Power Query connector as follows:

1. ODBC Connector Issue:

I have downloaded the ODBC client form SAP development tools and have configured it as follows:

However the Test Connection is failing with the following error:

2. Connect to SAP Hana using Dataflow Gen2 Issue:

Going forward when I try to connect to SAP Hana using Dataflow Gen2 in MS Fabric after creating a gateway, I get the following error.

Error Message:

‘An exception occurred: ODBC: ERROR [08S01] [SAP AG][LIBODBCHDB DLL][HDBODBC] Communication link failure;-10709 Connection failed (RTE:[89006] System call 'connect' failed, rc=10061:No connection could be established because the target computer refused the connection {**.***.***.**:30015} (**.***.***.**:30015)) (Session ID: 16d99661-7b85-41e9-9a4e-2e345c90ce50, Region: germany)’

I currently understand that the Online Power Query error is occurring because the ODBC connection could not be established successfully. Therefore, any help with in resolving the ODBC error and the Dataflow Gen2 error this issue would be highly appreciated.

Warm Regards,

Kartik

Re: Ms Fabric SAP Hana Connector Issue

Anonymous — Fri, 13 Sep 2024 01:46:27 GMT

Hi Kartik_K

The ODBC connector is faulty

The error message you see indicates that the communication link failed, which means that the connection attempt was blocked or rejected by the target machine:

Make sure your machine has access to the SAP HANA server. You can check the connection to the server and port (30015 in your case) using a tool like ping or telnet.

Check to see if there are any firewall rules or security groups that might prevent connections to SAP HANA servers. Make sure the necessary ports are open.

Ensure that the server name, port, and other connection parameters are specified correctly.

Ensure that the SAP HANA server is running and configured to accept connections on the specified port.

Set up your SAP HANA database connection - Microsoft Fabric | Microsoft Learn

Regards,

Nono Chen

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

topic Re: Ms Fabric SAP Hana Connector Issue in Dataflow

Ms Fabric SAP Hana Connector Issue

Re: Ms Fabric SAP Hana Connector Issue