question

MatthiasNohl avatar image
0 Votes"
MatthiasNohl asked MatthiasNohl answered

Dataflows --> Managed VNET --> SQL MI

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://docs.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

azure-data-factory
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

SaurabhSharma-msft avatar image
0 Votes"
SaurabhSharma-msft answered SaurabhSharma-msft commented

Hi @matthiasnohl,

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.


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @matthiasnohl,
I have not heard back from you. Did my answer solve your issue? If so, please mark as accepted answer. If not, please let me know how I may better assist.

Thanks
Saurabh

0 Votes 0 ·
MatthiasNohl avatar image
0 Votes"
MatthiasNohl answered

Hi @SaurabhSharma-msft ,
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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.