topic Re: Onprem connection not appearing as source connection in Pipelines

Onprem connection not appearing as source connection

ebjim — Thu, 29 Jun 2023 16:33:07 GMT

I created a connection to an onprem SQL Server in Fabric:

In Fabric Data Factory, I created a data pipeline and added a Copy activity. But when I went to set the onprem SQL Server as the source, the connection does not appear:

Why is that? Thank you in advance for the feedback!

Re: Onprem connection not appearing as source connection

GraceGu — Fri, 30 Jun 2023 05:20:43 GMT

on-premises access needs On-premises Data Gateway, which is not supported yet. You can refer to Differences between Data Factory in Fabric and Azure - Microsoft Fabric | Microsoft Learn

Re: Onprem connection not appearing as source connection

tsunloan — Fri, 30 Jun 2023 06:20:56 GMT

What's the ETA?
This is a very hard blocker for many large enterprise customers.

Re: Onprem connection not appearing as source connection

GraceGu — Fri, 30 Jun 2023 06:38:29 GMT

Understood it is a hard blocker, and we are actively working on this. Will share ETA when we have a concrete ETA.

Re: Onprem connection not appearing as source connection

ebjim — Fri, 30 Jun 2023 14:28:42 GMT

Just so I know for sure, when you say On-premise Data Gateway, are you referring to:

https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-install

Thank you.

Re: Onprem connection not appearing as source connection

GraceGu — Tue, 04 Jul 2023 01:00:36 GMT

Yes.