Data Factory - Managed VNet - Flows do not work, Copies do work.

Question

Hello,

I have attempted to use a Managed Virtual Network to connect ADF to Azure SQL.

I am able use Data Copy activities to connect and send data to Azure SQL server.

However, when running data flows I am unable to make a test connection or send data to the SQl Server.

Is there additional resources needed for the IR to work with Data Flows?

Thank You,
Chris

Answer 1

Hello @Chris ,

Thanks for the question and using MS Q&A platform.

Unfortunately, Azure Data Factory Managed VNET does not apply to the Dataflow transformations.

For more details, please do refer to the Github issue: Is Datafactory Data Flow running inside the managed vnet? which addressing the similar issue.

Hope this will help. Please let us know if any further queries.

------------------------------

• Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
• If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators