How To Access On-Prem Data Sources From Microsoft Fabric
ฝัง
- เผยแพร่เมื่อ 31 ก.ค. 2023
- This video will walk you through how you can use On Prem Data Gateways and Microsoft Fabric to access On-Prem Data Sources. At the time of this recording, the gateway is only supported for DataFlow Gen2, so we will use that for the demo.
learn.microsoft.com/en-us/dat... - วิทยาศาสตร์และเทคโนโลยี
That's amazing .... wanted someone to guide it in better way ... Luckily got this video .... Hope you will continue it n explore everything related to data science stuff which can empower data analysts with DS stuff.... 🎉
Glad this was able to help you!!!
Great! But how did you do that: on 1:50 you have win10 inside win 11, that is inside macOS ? Have you 3 VMs ?
MacOS is my host OS. I then have an RDP connection to a Windows 11 VM. At the 1:50 mark I am running the SSMS app connected to a SQL Server 2022 instance hosted on Windows Server 2022.
What if you want more than 1 user to access the on premise data? Do you have to make a gateway for each user?
No each user does not need to install their own gateway. The admin of the gateway, usually the person that installs it, can grant additional users permission to use the gateway. See the below doc for more info:
learn.microsoft.com/en-us/data-integration/gateway/manage-security-roles
ok, but can i use on premise on data factory? not in dataflow gen 2? or KQL?
On prem gateways are used to access data on-prem and are currently only supported within Gen2 Dataflows.
What if more than 1 user need to access the on-prem data? Does every user need to install their own data gateway on the server?
No each user does not need to install their own gateway. The admin of the gateway, usually the person that installs it, can grant additional users permission to use the gateway. See the below doc for more info:
learn.microsoft.com/en-us/data-integration/gateway/manage-security-roles
just install 1 on prem data gateway in local PC to connect to multiple on prem databases? like oracle/SQL server etc
One gateway can be used to connect to multiple on-prem databases.
Could I access to SQL Server On premise with Notebook in Fabric?
I am not aware of a way to do this via notebooks. The ideal solution would be to use Fabric Mirroring to mirror your SQL Server database into OneLake. Currently the mirroring feature is in private preview and only supports Azure SQL DB, CosmosDB, and Snowflake, but sql server will be coming soon.
Hi, awesome vid. I need to connect my Fabric data with SAP that its in a VPN.... what can i use? thanks
Have you looked into using an on-prem data gateway with the SAP connectors?
can we access SAP data in Microsoft fabric through On Prem Data Gateways ? I dont see any information on the internet that we are the source data that is accessible through MS fabric. If you know pls reply. thanks
at 5:31 in video , can you tell what is there in "more"
Yes SAP data can be accessed through an on-prem gateway. Check out this link for more details. blog.fabric.microsoft.com/en-us/blog/integrate-your-sap-data-into-microsoft-fabric/
i am getting this error after i publish error: GatewayCannotAccessSqlError Couldn't refresh the entity because of an internal error any idea how to fix it?
I would need to review it to really understand what’s going on. I recommend you open a support case for assistance.