Use Azure Data Factory with On-premises Data

[Knowledgeseeker]

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]

@Knowledgeseeker Hello! I'm moving this one to the Azure Data Factory discussion space in hopes of a more targeted response there.

[#3]

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.