Migration data

MUSTAFA AHMAD MUSTAFA AL-HUNAITI 166 Reputation points
2022-09-26T12:28:45.76+00:00

Hi there,
I have a VPN on my device to make me connect to enterprise source data(SQL database).
in my case, i wanna connect from VM using self-hosted integration runtime without using my VPN installed on my device.
to better understand my case i want migration my data from source to azure synapse to store data in ADLgen2.
i want to use the virtual network(VN), inside VN i create a sub-net that included my VM it has integration runtime installed in it

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,455 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ShaikMaheer-MSFT 38,126 Reputation points Microsoft Employee
    2022-09-27T10:26:06.38+00:00

    Hi @MUSTAFA AHMAD MUSTAFA AL-HUNAITI ,

    Thank you for posting query in Microsoft Q&A Platform.

    Kindly elaborate more what you mean when you say VPN installed on my device?

    From your requirement, it seems you want to migrate data from SQL database (which in some private virtual network) to Azure Synapse. You can do this by installing self-hosted IR on your private network machines and then using that self-hosted IR in ADF.

    Hope this helps. Please let me know how it goes.

    1 person found this answer helpful.