How do private endpoints work with Self Hosted Integration Runtime in Azure Synapse Analytics?

Rajat Srivastava 40 Reputation points
2023-05-05T13:25:39.4766667+00:00

So, I want to copy data from an On-Prem SQL server(In my case a VNET) to Synapse's Dedicated SQL POOL privately(without having anything exposed to internet) using private endpoints.

I have a VNET, which has the private endpoint for sql, ondemand sql and dev of the ASA as well as the storage account dlf. My On-Prem network is connected to this network using s2s connection.

When I try to set up a Self Hosted Integration Runtime(SHIR) node in my On-Prem, the On-Prem node gets registered without me having to do any DNS/Host file entry(Unlike ADF where I had to do the hostfile entry for registering the SHIR). Can someone explain me this? Also, is there even a way to achieve what I am trying to do? (That is, copy data from on prem sql to dedicated sql pool totally privately)

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,565 questions
{count} votes

Accepted answer
  1. PRADEEPCHEEKATLA-MSFT 83,301 Reputation points Microsoft Employee
    2023-05-08T06:35:09.3166667+00:00

    @Rajat Srivastava - Thanks for the question and using MS Q&A platform.

    A private endpoint for Self-hosted integration runtime is not supported in Azure Synapse Analytics at this moment, while Azure DataFactory has a private endpoint(datafactory) that guarantees private communication between SHIR and ADF.

    Hence, in Azure Synapse Analytics, all network traffic between SHIR node to datafactory service endpoint needs to go from internet.

    Appreciate if you could share the feedback on our feedback channel. Which would be open for the user community to upvote & comment on. This allows our product teams to effectively prioritize your request against our existing feature backlog and gives insight into the potential impact of implementing the suggested feature.

    Hope this helps. Do let us know if you any further queries.


    If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

    2 people found this answer helpful.

0 additional answers

Sort by: Most helpful