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.
is there a roadmap when the "On-premises Data Gateway(in design)" could be available?
Are there any workarounds to copy data from on premise to fabric?
Power BI has a gateway, it works fine. But it can't be used with fabric.
Or maybe there is am easy way to first export from on premise SQL Server into Parquet file and then to upload it?