topic Re: Connecting to SAP HANA with Fabric pipelines not working in Pipelines

Connecting to SAP HANA with Fabric pipelines not working

jvangrunderbeec — Wed, 10 Apr 2024 12:42:07 GMT

When I try to connect to a SAP HANA database via pipelines in Microsoft fabric i got this error message:

Please check your network connectivity to ensure your on-premises data gateway can access cac.frontend.clouddatahub.net and restart the service to retry the connection again once the connectivity issue has been resolved.

I use the connection via the Power BI gateway, as it sugested. We already used the same connection to connect in Data flow gen 2's with success.

I already tried to ping cac.frontend.clouddatahub.net on the gateway server and got a valid response.

Has anybody had this issue before?

Re: Connecting to SAP HANA with Fabric pipelines not working

v-cboorla-msft — Thu, 11 Apr 2024 10:33:07 GMT

Hi jvangrunderbeec

Thanks for using Microsoft Fabric Community.
At this time, we are reaching out to the internal team to get some help on this.
We will update you once we hear back from them.

Appreciate your patience.

Thanks

Re: Connecting to SAP HANA with Fabric pipelines not working

v-cboorla-msft — Tue, 23 Apr 2024 03:22:11 GMT

Hi jvangrunderbeec

Apologies for the delay in reponse from my end.

Got an update from the internal team, could you please upgrade your on-prem data gateway to the latest version and try to establish the connection.

For on-prem latest version please refer : On-premises data gateway

If the issue still persists, please do let us know we will try to help.

I hope this helps.

Re: Connecting to SAP HANA with Fabric pipelines not working

jvangrunderbeec — Tue, 23 Apr 2024 11:17:36 GMT

Just installed the latest version of the gateway and it still doesn't work..

Re: Connecting to SAP HANA with Fabric pipelines not working

jvangrunderbeec — Tue, 23 Apr 2024 13:31:11 GMT

I just did some more tests on this....

We have some connections to an on prem sql server and here I got the same error message when I try to use it in a pipeline.. When I use the same connection in a dataflow gen2 it works fine.

Could you elaborate more on what we need to open on the firewall of the gateway server to use the on prem data gateway in pipelines.

Kind regards

Re: Connecting to SAP HANA with Fabric pipelines not working

v-cboorla-msft — Tue, 30 Apr 2024 07:49:42 GMT

Hi jvangrunderbeec

Apologies for the inconvenience.

Please reach out to our support team to gain deeper insights and explore potential solutions. It's highly recommended that you reach out to our support team. Their expertise will be invaluable in suggesting the most appropriate approach.

Please go ahead and raise a support ticket to reach our support team:

https://support.fabric.microsoft.com/support

After creating a Support ticket please provide the ticket number as it would help us to track for more information.

Thank you.

Re: Connecting to SAP HANA with Fabric pipelines not working

v-cboorla-msft — Wed, 01 May 2024 17:35:43 GMT

Hi jvangrunderbeec

We haven’t heard from you on the last response and was just checking back to see if you've had a chance to submit a support ticket. If you have, a reference to the ticket number would be greatly appreciated. This will allow us to track the progress of your request and ensure you receive the most efficient support possible.

Thanks.

Re: Connecting to SAP HANA with Fabric pipelines not working

Anonymous — Thu, 30 May 2024 08:21:28 GMT

HI v-cboorla-msft

I have the same issue with Oracle On Premise. Gateway is up to date.

The gateway connection work fine with a dataflow gen 1 but doesn't work with Datapipeline.

I got this error message:

Please check your network connectivity to ensure your on-premises data gateway can access we.frontend.clouddatahub.net and restart the service to retry the connection again once the connectivity issue has been resolved. ID d’activité: 79e10e84-0276-4e02-9403-0fc737a0a9ba

Re: Connecting to SAP HANA with Fabric pipelines not working

amaaiia — Mon, 24 Jun 2024 06:38:12 GMT

Same issue here. I have a Data pipeline with COPY activity ingesting data through an on-prem data gateway. Suddenly, this error has come up. I've tried using this connection with a Dataflow gen2 and it works. The problem is when using COPY activity to do the data ingestion.

Any ideas?

Re: Connecting to SAP HANA with Fabric pipelines not working

saradas — Thu, 16 Jan 2025 20:26:18 GMT

I am having the same issue, please advise if you were able to solve the issue ?

Re: Connecting to SAP HANA with Fabric pipelines not working

hhernanz — Mon, 07 Apr 2025 07:28:43 GMT

Same problem here, when connecting to Oracle on-premise. Same connection and GW working fine por Power BI and Dataflows, the problem arises only for data pipelines. Please, any updated on these? Regards.

Re: Connecting to SAP HANA with Fabric pipelines not working

K4bal — Mon, 14 Apr 2025 08:16:17 GMT

We have the same issue with the SHIR. In the Fabric Data Pipelines not a single connection to On-Prem DBs works but if we try it with ADF from our Synapse Workspace it works. So seems like a Fabric issue.

SHIR is running with the latest version