Forum Discussion
Knowledgeseeker
Jan 20, 2022Brass Contributor
Use Azure Data Factory with On-premises Data
Hi Community,
Is there any way to make Azure Data Factory write data directly to an On-premises Sql Server?
Thank you in advance.
2 Replies
- While we typically do that in the opposite direction, I don't see any reason why you can't do that. You just need to configure an on-premises self-hosted integration runtime that has visibility to the on-premises server, then configure a linked service. You can then call procedures, etc. or use it as the sink in a copy activity.
- EricStarkerGold Contributor
Knowledgeseeker Hello! I'm moving this one to the Azure Data Factory discussion space in hopes of a more targeted response there.