Connecting Azure Fabric to on-prem SQL Server

48 views Asked by At

What IP addresses need whitelisting to connect Azure Fabric to an on-prem SQL Server via Dataflow Gen 2 or Copy pipelines?

1

There are 1 answers

0
David Browne - Microsoft On BEST ANSWER

You use the on-prem gateway instead of opening ports.

Data Factory for Microsoft Fabric is a powerful cloud-based data integration service that allows you to create, schedule, and manage workflows for various data sources. In scenarios where your data sources are located on-premises, Microsoft provides the On-Premises Data Gateway to securely bridge the gap between your on-premises environment and the cloud. This document guides you through the process of accessing on-premises data sources within Data Factory for Microsoft Fabric using the On-Premises Data Gateway.

How to access on-premises data sources in Data Factory for Microsoft Fabric