Forum Discussion
Solved
Data Factory - SQL Server Source (Gateway)
Hi,
I am trying to develop a Fabric Data Factory Pipeline getting data from a source placed on a on-premise SQL Server.
But when I establish the connection I don't see the way to define the...
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 created a "Dataflow Gen2", which works like Power Query. I used the "On-premises data gateway" as source, Lakehouse as destination, and this works fine.