Forum Discussion

Knowledgeseeker's avatar
Knowledgeseeker
Brass Contributor
Jan 20, 2022

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.

Resources