azure-data-factory

What is process to configure Azure Fabric Pipelines to extract data from On Premise server such as SQL Database


To extract data from an on-premise SQL Database using Azure Data Factory we would configure Self-hosted Integration Runtime on ADF, and follow the necessary steps to connect to the on-premise sql database and extract data.

Can someone let me know how would we go about extracting data from an on-premise server with Azure Fabric Data Pipelines?


Solution

  • The equivalent of SHIR in fabric ecosystem is on Premises data gateway.

    https://learn.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem

    Process: https://learn.microsoft.com/en-us/fabric/data-factory/how-to-access-on-premises-data

    Install the gateway on a server and set up a connection in fabric using the gateway.

    then use that connection as a source in fabric data pipeline copy activity