Create Azure Data Factory dataflows from sql server source databases and sql Server destination d

[Mickael_Ro]

I have a problem when I want to create an ADF dataflow with a SQL Server database as source or destination with a self-hosted integration runtime. Has anyone ever had this problem? How can I solve it?

Thank you

[NandanHegde · Accepted solution]

Assuming you are speaking about azure data factory and not fabric data pipeline, dataflow within ADF doesn't support any source using self hosted ir. 

You need to use copy activity and copy data into blob or any source supported by dataflow as an intermittent layer

[Anonymous · Accepted solution]

Hi @Mickael_Ro ,

As NandanHegde said, I likewise think this falls under the Azure Data Factory category.

You can find the solution to the problem in the Azure Data Factory related documentation.

I think you can check this official documentation for more information:

Troubleshoot self-hosted integration runtime - Azure Data Factory & Azure Synapse | Microsoft Learn

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[NandanHegde · Accepted solution]

Assuming you are speaking about azure data factory and not fabric data pipeline, dataflow within ADF doesn't support any source using self hosted ir. 

You need to use copy activity and copy data into blob or any source supported by dataflow as an intermittent layer