question

SunShine-2583 avatar image
0 Votes"
SunShine-2583 asked SamaraSoucy-MSFT answered

Integration Service on Azure Synapse Studio

Hello:

I want to copy data from my on-prem SQL Server to Azure Synapse and from Azure Synapse Studio, I can create site-to-site Integration Service and it is prompting me to download and create new one.

My question is, why I cannot use my existing site-to-site Integration Service??

Microsoft should give options to use existing one or create new one.

Any help is greatly appreciated.

97237-integrationruntime.png


azure-synapse-analytics
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

SamaraSoucy-MSFT avatar image
0 Votes"
SamaraSoucy-MSFT answered

Hello,

I appreciate the feedback.

You are correct that Synapse does not currently offer the capability to share a runtime with another Synapse workspace or with Data Factory. You can redirect your nodes with the dmgcmd.exe -key <new key> command but this does disconnect it from any other services.

You may wish to post or upvote this feature on feedback.azure.com. Any feedback posted here is discussed with the product teams, but the upvote system there is used to help prioritize new features.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.