How to share my SHIR (Self Host Integration Runtime) service with different azure services

Question

1. I have created a SHIR service for my Azure Synapse Analytics service where I used to perform data operation from Azure Synapse to my On prem SQL Server using my SHIR service. However I wanted to use the data of my on prem SQL with Azure data factory services too and I did tried to use my same SHIR service with Azure data factory however I couldn't able to achieve my goal successfully below are the steps I tried to make use of my existing SHIR service

I went to my SHIR service from Azure Synapse workspace and look for shared option however it's not available so my workaround as below

1. Logged in in PowerShell and ran below command
2. az synapse integration-runtime show `

   --workspace-name azsynapsewrkspace3376 `

   --name SHIR `

   --resource-group dp-203-rg

3. Got the following output
   { "etag": "35003144-0000-2200-0000-675427970000", "id": "/subscriptions/9fd46475-34f3-45af-a671-ab11cb4248a5/resourceGroups/dp-203-rg/providers/Microsoft.Synapse/workspaces/azsynapsewrkspace3376/integrationruntimes/SHIR", "name": "SHIR", "properties": {

   "additionalProperties": null,
   
   "description": "Self Host Integration Runtime for On Prem SQL Server",
   
   "linkedInfo": null,
   
   "type": "SelfHosted"
   

   }, "resourceGroup": "dp-203-rg", "type": "Microsoft.Synapse/workspaces/integrationruntimes" }
4. Grab my id value and did a slight modificationa s I'm sharing my SHIR from az synapse to az data factory
   Replace Microsoft.Synapse/workspaces with Microsoft.DataFactory/factories under my Id values
5. I got below error when trying to share my SHIR by using the ID value
6. Error
   Getting an Error when trying to Share a SHIR of Azure Synapse with ADF Failed to save integrationRuntime1. Error: Failed to save integration runtime. Access denied. Unable to access shared integration runtime 'SHIR'. Please check whether this resource has been granted permission by the shared integration runtime. Microsoft team could you check on this issue ... just curious to know how to share any shir services among other azure services, i know azure data factory SHIR service can be shared across other Azure Data factory service but do you have an option to share SHIR with different services

Answer 1

Hi @Sayeed Ahmed

Greetings & Welcome to Microsoft Q&A forum! Thanks for posting your query!

Thank you for sharing the detailed explanation of your approach. Currently, sharing a self-hosted integration runtime (SHIR) across different Azure services like Azure Synapse and Azure Data Factory is not directly supported. The SHIR can only be shared within Azure Data Factory instances and not across different Azure services such as Azure Synapse Analytics and Azure Data Factory within the same Microsoft Entra tenant.

There is no supported workaround to share an SHIR between Synapse Analytics and Azure Data Factory.

For more details, please refer: Data integration in Azure Synapse Analytics versus Azure Data Factory

If you need to use the same on-premises infrastructure, you can install multiple SHIR instances on the same on-premises machine (server/VM) and configure them separately for both Synapse and ADF. This will allow both services to interact with your on-premises resources without conflict.

I hope this information helps. Please do let us know if you have 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.

Answer 2

Basically below are the 3 generic aspects:

1. you can only share SHIR created within an ADF with other ADFs present within the same tenant (no cross tenant is supported)
2. You cannot share the SHIR created within ADF with any other service other than ADF within same tenant
3. SHIR created within synapse cannot be shared with any service (synapse included)