Forum Discussion
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.
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.