Forum Discussion
Installing a Data Gateway
Super UserUnfortunately 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
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?
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?
