Share a self-hosted integration runtime with Azure Synapse

Question

Share a self-hosted integration runtime with Azure Synapse

Hans Olav Vogt Myklebust / Intility AS 31

Hi,

I want to use the same Integration Runtime in Azure Synapse as I am currently using in existing Data Factory pipelines. I managed to grant permission to Synapse by using the "Enter Manually" option and pasting the Managed Identty Object ID for my Synapse workspace, but there are no options to load a shared IR in Synapse Studio. I also tried to copy the code from an other shared IR to the code field in Synapse studio, but then I get the following error:

"
Failed to save IR. Error: Failed to save integration runtime. DurableTask.Core.Exceptions.TaskFailedException : {"code":"DataFactoryPropertyUpdateNotSupported","message":"Updating property type is not supported.","target":null,"details":null,"error":null} at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at DurableTask.Core.TaskOrchestrationContext.d__17.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at DurableTask.Core.TaskOrchestrationContext.d__161.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at DurableTask.Core.TaskOrchestrationContext.d__151.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.Analytics.ProvisioningWorkerSvc.Workflows.DataFactory.Orchestration.CreateOrUpdateDataFactoryResourceOrchestration.d__4.MoveNext() in S:\src\services\provisioning\Microsoft.Analytics.ProvisioningWorkerSvc\Workflows\DataFactory\Orchestration\CreateOrUpdateDataFactoryResourceOrchestration.cs:line 89
"

Any help is appriciated!

KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator

2020-07-21T05:18:31.607+00:00

Hi @HansOlavVogtMyklebustIntilityAS-0060,

Welcome to Microsoft Q&A and thanks for reaching out.

We are investigating into this issue and will reach out to the product team as needed and will keep you posted as soon as I have an update. I have also noticed that you have opened a Support Request for the same. In case if you find a resolution, please feel free to update this thread.

Thank you
KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator

2020-07-28T21:43:24.87+00:00

Hi @Hans Olav Vogt Myklebust / Intility AS ,

Looks like it is not possible to share SHIR of an existing Data factory with Azure Synapse. But, I have reached out to ADF team to double confirm on the same. Will keep you posted as soon as I have a final confirmation from the team.

Accepted answer

1 additional answer

Your answer

KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator

2020-07-21T05:18:31.607+00:00

Hi @HansOlavVogtMyklebustIntilityAS-0060,

Welcome to Microsoft Q&A and thanks for reaching out.

We are investigating into this issue and will reach out to the product team as needed and will keep you posted as soon as I have an update. I have also noticed that you have opened a Support Request for the same. In case if you find a resolution, please feel free to update this thread.

Thank you
KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator

2020-07-28T21:43:24.87+00:00

Hi @Hans Olav Vogt Myklebust / Intility AS ,

Looks like it is not possible to share SHIR of an existing Data factory with Azure Synapse. But, I have reached out to ADF team to double confirm on the same. Will keep you posted as soon as I have a final confirmation from the team.

Answer 1

KranthiPakala-MSFT 46,642 Microsoft Employee Moderator

Hi @Hans Olav Vogt Myklebust / Intility AS ,

I have a confirmation from product team that sharing of SHIR with Azure Synapse from an existing data factory is not currently supported, but it is in the backlog. I do not have an ETA at the moment, but I would recommend you to please subscribe to Azure updates notifications to know more about important Azure product updates, roadmap, and announcements.

Hope this info helps. Do let us know if you have further query.

----------

Thank you
Please do consider to click on "Accept Answer" and "Upvote" on the post that helps you, as it can be beneficial to other community members.

KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator

2020-07-30T06:07:34.08+00:00

Hi @Hans Olav Vogt Myklebust / Intility AS ,

Just checking to see if the above info was helpful. If this answers your query, please do consider to click “Mark as Answer” and "Up-Vote" as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

----------

Thank you
KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator

2020-07-31T20:02:59.033+00:00

Hi @HansOlavVogtMyklebustIntilityAS-0060,

Just checking to see if the above info was helpful. If you have any further query, do let us know.

Thank you
Gamez, Eduardo M 1 Reputation point

2021-03-29T17:18:37.38+00:00

Hi @KranthiPakala-MSFT - Just checking to see if this is still the case and is not currently supported as of today? I tried sharing from my current ADF IR, but only other ADFs show up in the list. Thanks!
Arthur Steijn 56 Reputation points

2021-07-22T07:24:44.263+00:00

Hi,

I would like to know as well! Is there a timeline when it will be posibble to share IR over multiple Synapse environments?

Kr.
KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator

2021-07-22T08:24:09.3+00:00

Hi @Arthur Steijn ,

At this time we do not have ETA but we expect this feature to land in the near future. As mentioned in my previous comment, I would recommend you to please subscribe to Azure updates - https://azure.microsoft.com/en-us/updates/?category=analytics for feature releases and announcements about azure products.
Max 6 Reputation points

2021-09-02T07:03:16.417+00:00

Hi,

Is there any news on when this will be available?

Regards,
KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator

2021-09-02T11:54:43.857+00:00

HI @Max ,

Thanks for reaching out. We donot have an ETA yet but as suggested in my previous comment, would recommend you to please subscribe to Azure updates for latest updates.

Thank you
RobbertFM 11 Reputation points

2021-11-10T13:18:11.763+00:00

Hi there,

As many others in this thread, I am interested in this feature.
Hans mentioned the feature is on the backlog.
Can we view this backlog and upvote features, so Microsoft can see which features are most wanted by users?

Best regards,
Robbert
selvi 0 Reputation points

2023-07-28T14:36:42.9466667+00:00

Is any update on this issue. I am in the same scenario now, which I need to share a self hosted run time to a different synapse in different subscription .Is that possible to grant permission to the synapse .

Answer 2

Thomas Lauronen 31

A late 2022 update from a tweet for anyone who might stumble upon this question:
"This is currently a roadmap item that we are evaluating as part of our CY23 plan"

Source: https://twitter.com/KromerBigData/status/1584591604077457408

Militaru, Petrica 0 Reputation points

2024-07-04T13:29:35.32+00:00

Any updates on this item ? I still don't see it available in July 2024.

Share via

Share a self-hosted integration runtime with Azure Synapse

1 additional answer

Your answer