How To Access On-Prem Data Sources From Microsoft Fabric

Рет қаралды 4,983

11 ай бұрын

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...

Пікірлер: 19

@shashipaul6279 8 ай бұрын

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.... 🎉

@DataBar 8 ай бұрын

Glad this was able to help you!!!

@nickgovorun5384 11 ай бұрын

Great! But how did you do that: on 1:50 you have win10 inside win 11, that is inside macOS ? Have you 3 VMs ?

@DataBar 11 ай бұрын

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.

@user-sm7js3pt3i 5 ай бұрын

What if you want more than 1 user to access the on premise data? Do you have to make a gateway for each user?

@DataBar 5 ай бұрын

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

@lerbous4633 4 ай бұрын

just install 1 on prem data gateway in local PC to connect to multiple on prem databases? like oracle/SQL server etc

@DataBar 4 ай бұрын

One gateway can be used to connect to multiple on-prem databases.

@ramonpacheco42 7 ай бұрын

ok, but can i use on premise on data factory? not in dataflow gen 2? or KQL?

@DataBar 7 ай бұрын

On prem gateways are used to access data on-prem and are currently only supported within Gen2 Dataflows.

@user-sm7js3pt3i 5 ай бұрын

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?

@DataBar 5 ай бұрын

@aakanshaverma1310 2 ай бұрын

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

@aakanshaverma1310 2 ай бұрын

at 5:31 in video , can you tell what is there in "more"

@DataBar 2 ай бұрын

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/

@clvc699 5 ай бұрын

Could I access to SQL Server On premise with Notebook in Fabric?

@DataBar 5 ай бұрын

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.

@vishwassee 8 ай бұрын

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?

@DataBar 7 ай бұрын

I would need to review it to really understand what’s going on. I recommend you open a support case for assistance.