Skip to main content
Microsoft Idea

Data Factory

Completed

Support for on-prem connectivity within Pipelines in Fabric

Vote (89) Share
Darwin Dat's profile image

Darwin Dat on 28 Jun 2023 18:34:34

As we have many data sources from on-prem (SQL Server), it would be great if the Pipeline in Data Factory within Microsoft Fabric can support the on-premise data gateway, so we could integrate data easily from on-prem to Onelake. Otherwise, as the Copy Activity in Fabric seems much easier to use, but we still can't use it properly.

Administrator on 19 Apr 2024 04:02:06

We are shipped on-premises data gateway for data pipeline, check the blog announcement Integrating On-Premises Data into Microsoft Fabric Using Data Pipelines in Data Factory | Microsoft Fabric Blog | Microsoft Fabric

Comments (13)
Darwin Dat's profile image Profile Picture

Don Hicks on 20 Nov 2023 16:09:28

RE: Support for on-prem connectivity within Pipelines in Fabric

Agree with this. Given that Fabric is now General Availability can you provide a better idea when the support for On Premise Data Gateways will be added? I would have thought this would be part of the GA!Also agree that Incremental refresh is needed, especially important for properly setting up a medallion architecture

Darwin Dat's profile image Profile Picture

Beth Ramsey on 17 Nov 2023 05:19:48

RE: Support for on-prem connectivity within Pipelines in Fabric

This is vital for our Fabric Project to be successful. We're having to use a DataFlow for large data and it not a viable solution. All source data is on-prem SQL.

Darwin Dat's profile image Profile Picture

Leon Dingen on 28 Sep 2023 06:25:52

RE: Support for on-prem connectivity within Pipelines in Fabric

2 months after the last update - could we please get another?

Darwin Dat's profile image Profile Picture

Scott Powell on 26 Sep 2023 18:40:32

RE: Support for on-prem connectivity within Pipelines in Fabric

Without a good way to quickly copy on-prem data to Fabric, it limits your potential customer base to people that already are buying Azure services. This really is must-have functionality to get customers who don't currently use Azure to sign up. I've been kicking the tires on Fabric since it was announced - but with no good way to move large amounts of data from on-prem SQL server into Fabric, I'm completely handcuffed.Thanks,Scott

Darwin Dat's profile image Profile Picture

Neil Smith on 21 Aug 2023 07:29:21

RE: Support for on-prem connectivity within Pipelines in Fabric

I agree with all the comments, this is essential functionality, and needs to be available as soon as possible.

Darwin Dat's profile image Profile Picture

Martin Newton-Hughes on 15 Aug 2023 09:24:41

RE: Support for on-prem connectivity within Pipelines in Fabric

I second the incremental refresh needed for this as well.

Darwin Dat's profile image Profile Picture

Random Guy on 09 Aug 2023 15:27:42

RE: Support for on-prem connectivity within Pipelines in Fabric

And don't forget the incremental refresh.

Darwin Dat's profile image Profile Picture

Random Guy on 09 Aug 2023 15:27:04

RE: Support for on-prem connectivity within Pipelines in Fabric

Really hoping for this ASAP. Without on-prem SQL connectivity, Fabric is a cute toy. Let's make it a true game changer!

Darwin Dat's profile image Profile Picture

on 19 Jul 2023 02:26:04

RE: Support for on-prem connectivity within Pipelines in Fabric

I'd love to be able to use the gateway in in the Pipeline to get to on-prem SQL data. Please allow use of data sources configured in the gateway in pipelines.

Darwin Dat's profile image Profile Picture

Wolfgang Strasser on 12 Jul 2023 13:25:10

RE: Support for on-prem connectivity within Pipelines in Fabric

This is a must for implementing successful Fabric projects!

Merged Idea (1)