Forum Discussion
Recommended Setup for SQL Server on Azure VM
Hello CoulterJames2
Since your customer's SQL Server is on a VM in it's own VNet, there is no private endpoint-native access, and Fabric capacity is <64 - you should use a Fabric Data Gateway.
Fabric On-Premises Data Gateway runs inside customer's VNet, and data flows through Microsoft backbone network - Data Factory Copy tasks should be able to reach it.
By 'Fabric Data Gateway' do you mean a VNet Data Gateway?
The On-premises data gateway CoulterJames2, not the VNet data gateway - the latter is targeted for Azure PaaS services.
Is there no option to avoid having an On Premises Data Gateway? That will require another VM to be spun up.
VNet Data Gateway requires F8 and above.
What is a virtual network (VNet) data gateway | Microsoft Learn
A decicated VM for the gateway is the preferred architecture according to Microsoft best practices, however you can look at exiting VMs within your network, preferably one that is consuming low resources, if you don't intend spinning up a new VM.