This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(48, 85%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAR%3C/text%3E%3C/svg%3E)
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.
Hi @Amit Rawat , wondering if the following answer was helpful. If yes, Would you please mark the answer as accepted and up-vote the same. Thanks!
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!
Hi nasreen,
thank you for sharing this details really this is helpful.
as you mentioned this can be possible using both Pipeline and copy activity.
Is there are any pricing difference in both the options
please could you help me how the pricing will be calculated based on the below example.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(313.6, 60%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
Can we connect to on-premises SQl sevrer from Azure data factory without self hosted IR ?