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?
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