can I use an Azure Integration runtime to UPSERT data from ADF to SQL Server on azure VM?

Question

Hi,

I'm trying to UPSERT data from ADF to a SQL server hosted on Azure Virtual Machine since SHIR is not supported in Mapping dataflows.

I've created an Azure Integration Runtime with Virtual Network Enable, however when I tried to create an endpoint I do not see any option available for a VM, could you please guide me through the process to create this connectivity,?

this is my previous question about this topic

https://learn.microsoft.com/en-us/answers/questions/158556/sqlserver-on-iaas-vm-of-azure-cloud-and-integratio

thanks

Answer 1

Hello @Anonymous , Thanks for the question and using MS Q&A platform.

I am assuming that you have named instance of SQL running on the VM. If that's the case, then you can get the hostname of the VM and pass that hostname in the ADF and that should help you connect to the SQL server. How to find the hostname

I think you can do this in many ways, I find, login in on the server - cmd prompt - ipconfig/all

and the hostname should be

hostname.yourdns.com .

You should pass this server name to the linked service name in the below screen .

Let me know how it goes.

Thanks Himanshu

Please accept as "Yes" if the answer provided is useful , so that you can help others in the community looking for remediation for similar issues.