Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,871 questions
Establish connectivity from ADF to SQL Server which is hosted on Azure VM
MUSTAFA AHMAD MUSTAFA AL-HUNAITI
176
Reputation points
Greeting all,
I want to do something similar to this architecture, I want to connect from ADF to SQL Server which is hosted on Azure VM using VNet using one subnet is this possible? if yes, could someone please, share the instructions on how I can do that?
I want all the resources in one subnet
the VNet + subnet + SQL Server which is hosted on Azure VM (which is inside the VNet/subnet) has already created I need the rest of the work to be in the same subnet and then establish connectivity from the data factory to the SQL server is this possible?
Thanks in advance.
Note: I know that it is possible to solve such a problem using SHIR.
documentation link: https://learn.microsoft.com/en-us/azure/data-factory/tutorial-managed-virtual-network-on-premise-sql-server
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(192, 26%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
HimanshuSinha-msft 19,476 Reputation points Microsoft Employee2023-12-21T20:03:47.18+00:00 Hello @MUSTAFA AHMAD MUSTAFA AL-HUNAITI ,
Thanks for the ask and using Microsoft Q&A .
As I understand at this time you want all the all the resources including the ADF on the same VNET. As you have not mentioned if you have tried out the ADF on managed VNET (you can read about that here ) . The document does callout the below and I think using you have a SQL server it should help ."The configuration pattern in this tutorial applies to copying from a file-based data store to a relational data store"
You also mentioned.
Note: I know that it is possible to solve such a problem using SHIR.I am assuming that you do not want to use SHIR, but with the above article you will have to use Azure IR .
Thanks
Himanshu -
MUSTAFA AHMAD MUSTAFA AL-HUNAITI 176 Reputation points
2023-12-23T12:09:45.18+00:00 Hello HimanshuSinha-msft
thank you for your support
Simply put, I want to transfer data from an on-prem SQL server hosted on Azure VM to Azure data lake without using SHIR is that possible?
Note: all that will be inside Vnet and my data factory is used Azure IR (managed Vnet).
Sign in to comment
Sign in to answer