Forum Discussion
Data Factory - SQL Server Source (Gateway)
Pipeline copy on-prem access (by SHIR in ADF) is not available yet. You can refer to Differences between Data Factory in Fabric and Azure - Microsoft Fabric | Microsoft Learn to get an idea on what are there and what are not. Right now, you can use dataflow to access on-prem resources.
I think they either making a mistake about the SQL SERVER connector (it seems the connector setting is to azure instead of on-premise) or they assume us to use Dataflow? to pulling data from on-premise server.
Btw, dataflow gen 2 does work due to gateway problem.
Re: Problem running a gen2 dataflow from a non azu... - Microsoft Fabric Community
I have no experience with ADF as we don't really use Azure. I'm super curious - for folks that have used both ADF and Dataflows via an on-prem gateway, is ADF significantly faster?
It takes a pretty long time to copy data across via our gateway servers. I'm hoping ADF is at least an order of magnitude faster.
Thanks,
Scott