Azure Data factory

Amit Rawat 86 Reputation points
2021-12-03T15:52:16.39+00:00

Is possible to connect On-Premise SQL Server Using Azure Data Factory

Looking for a solution - Replicate data from Dynamics CE 365 to On-Premise SQL server Using ADF.
Is this possible using copy data
Is this possible using Pipeline creation. Thank you.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,062 questions
{count} votes

Accepted answer
  1. Nasreen Akter 10,711 Reputation points
    2021-12-03T16:06:51.593+00:00

    Hi @Amit Rawat ,

    Yes, it is possible to connect on-premise SQL Server from Azure Data Factory. All you have to do is to configure a Self-Hosted Integration Runtime. After configuring the SHIR, you would able to use it in the CopyActivity and also in the pipeline. Hope this will help. Thanks!

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful