How to connect data factory to azure sql managed instance private endpoint

Question

Hi All,

I have azure SQL managed instance private endpoint database. now i am facing challenge to connect this database using data factory.

I cant able to create linked service to connect MI database.
I have done research from my side and i found one solution that using virtual machine but i am not good in networking area.

Can anyone help me out or provide me steps to connect data factory to this database.

Thanks in advance.

Answer 1

@Girish13 Thanks for using Microsoft Q&A !!

You need to setup a self-hosted integration runtime which can be on any VM or your on-premises machine (Refer to the documentation) and you need to make sure that -

• Your integration runtime is in a different subnet as your managed instance if both shares same virtual network .
• If virtual networks are different then you need to use either virtual network peering or a virtual network to virtual network connect.

Please refer to documentation to connect inside the same or different vnet's approaches. I believe you are referring to the same but if you are using managed instance with private endpoint then if you to setup the network as mentioned in the documentation.

You can refer to existing ARM template - Create a Virtual Network with two Subnets for implementing networking infrastructure for your case.
You can use Tutorial: Connect virtual networks with virtual network peering using the Azure portal to connect two virtual networks.
Also, refer to Quickstart: Create a virtual network using the Azure portal for additional details.
Please let me know if you have any questions.

----------

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