Linked service between Datafactory and Private hosted SQL on VM

Ramakrishna Gollakota 1 Reputation point
2021-09-28T19:05:07.213+00:00

We are trying to connect between data factory and SQL that is hosted on private VM. We tried creating integration runtime but thats still not resolving the connection.

Can you help us how that can be achieved.

Note: Azure VM hosting SQL server.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,084 questions
{count} votes

1 answer

Sort by: Most helpful
  1. PRADEEPCHEEKATLA-MSFT 84,941 Reputation points Microsoft Employee
    2021-10-01T10:04:22.877+00:00

    Hello @Ramakrishna Gollakota ,

    Thanks for the question and using MS Q&A platform.

    You can use Self-hosted Integration in the option for connecting ADF to SQL Server on Azure VM.

    A self-hosted integration runtime can run copy activities between a cloud data store and a data store in a private network, and it can dispatch transform activities against compute resources in an on-premises network or an Azure virtual network. The installation of a self-hosted integration runtime needs on an on-premises machine or a virtual machine (VM) inside a private network.

    For more details, refer to Create and configure a self-hosted integration runtime.

    Hope this will help. Please let us know if any further queries.

    ------------------------------

    • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification
    • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators