Dataflows --> Managed VNET --> SQL MI

Question

Hi,

is there a way to connect to the SQL MI when using ADF Dataflows in a managed VNET manner?

The method described in this article is too much overloaded...
https://learn.microsoft.com/en-us/azure/data-factory/tutorial-managed-virtual-network-sql-managed-instance

Is there a simple and smart solution out there?

Best
Matthias

Answer 1

Hi @Matthias Nohl | b.telligent ,

I have checked internally on this and for Dataflow only solution right now is the one described in shared documentation.

SQL MI has native VNet integration. Any service that can be integrated with VNet may be peered with MI (or even share the VNet). To access the SQL Managed Instance private endpoint, set up a self-hosted integration runtime that can access the database. If you provision the self-hosted integration runtime in the same virtual network as your managed instance, make sure that your integration runtime machine is in a different subnet than your managed instance.
If you provision your self-hosted integration runtime in a different virtual network than your managed instance, you can use either a virtual network peering or a virtual network to virtual network connection. See Connect your application to SQL Managed Instance.

However, the SQL MI PG is working on that private link support for SQL MI and it may be released in couple of months and that will ease the infrastructure overload concerns.
Hope this helps.

Please let me know if you have any other questions.

Thanks
Saurabh

----------

Please do not forget to "Accept the answer" wherever the information provided helps you to help others in the community.

Answer 2

Hi @Saurabh Sharma ,
Since there is no solution for this, I will leave the ticket open.
Please let me know when the Private Endpoints for the SQL MI are available, then I will close the ticket.
Best
Matthias