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

Join the OneLake & Platform Admin teams for an ask US anything on July 16th. Join now.

Reply
SergioSurfer
Frequent Visitor

Installing a Data Gateway

I'm trying to connect to a SAP database using Dataflows Gen 2, however it requests an On-premises Data Gateway. 

I've read a lot about these data gateways. I need to install it on a computer that is ON all the time, which is something that I do not have. I'm assuming that the ideal solution would be to install the gateway on the same machine that is hosting the SAP database? What if I don't have any way of doing this? Is there any solution where Microsoft Fabric can 'host' these data gateways so we don't have to worry about installing in some computers just for the gateway?

 

Thanks in advance

 

5 REPLIES 5
NandanHegde
Super User
Super User

Unfortunately it is not recommended to install a gateway on the same server as that on the database. And unfortunately there is no direct component within Fabric to handle that as of today.

 

https://learn.microsoft.com/en-us/data-integration/gateway/

 

The Vnet gateway is for MSFt cloud services connectivity.

So you wuld have to set up a server within the same vent as the database and host a gateway on that new server




----------------------------------------------------------------------------------------------
Nandan Hegde (MSFT Data MVP)
LinkedIn Profile : www.linkedin.com/in/nandan-hegde-4a195a66
GitHUB Profile : https://github.com/NandanHegde15
Twitter Profile : @nandan_hegde15
MSFT MVP Profile : https://mvp.microsoft.com/en-US/MVP/profile/8977819f-95fb-ed11-8f6d-000d3a560942
Topmate : https://topmate.io/nandan_hegde
Blog :https://datasharkx.wordpress.com

Reading the resources you shared: What is a virtual network (VNet) data gateway | Microsoft Learn
I see that the limitations of this mention the following: 

 

1) "Currently, this feature is available only for Fabric Dataflow Gen2, Power BI semantic models, Power Platform dataflows, and Power BI paginated reports."
2) "Power Platform dataflows - For Power Platform dataflows, this feature currently doesn't support the ability to write to a privatized data lake or Dataverse."

 

--> Does this mean that I wouldn't be able to use the Notebook with PySpark to access a SAP Hana database and put the data onto OneLake? 

Anonymous
Not applicable

Hi @SergioSurfer ,

Based on the limitations you’ve mentioned, it seems that the virtual VNet data gateway currently supports only specific services like Fabric Dataflow Gen2, Power BI semantic models, Power Platform dataflows, and Power BI paginated reports.

 

Since your use case involves using a Notebook with PySpark to access a SAP Hana database and then putting the data onto OneLake, it falls outside the supported scenarios for the VNet data gateway. The gateway does not currently support writing to a privatized data lake or Dataverse for Power Platform dataflows. Therefore, you wouldn’t be able to use the VNet data gateway for your specific requirements.

 

 

 

Best Regards

Yilong Zhou

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

What would be the best way then for me to gather some data from SAP hana database into OneLake?

charlyS
Most Valuable Professional
Most Valuable Professional

Easiest way will certainly be using a Dataflow Gen2 https://learn.microsoft.com/en-us/fabric/data-factory/connector-sap-hana

 

No need to have a machine up and runnning all time for the usage of a Fabric Gateway, it just need to be up and running while you are retrieving the data.

 

Hope this help,

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June FBC25 Carousel

Fabric Monthly Update - June 2025

Check out the June 2025 Fabric update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

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

Top Solution Authors
Top Kudoed Authors