question

GaryCui-4085 avatar image
0 Votes"
GaryCui-4085 asked SteenSigaard-8973 published

How to connect 2 Synapse Workspace to the same on-premise SQL Serveer using self-hosted integration runtime?

I have one Synapse workspace for Dev and one Synapse workspace for Prod. Both will need to connect to the same On-prem SQL server as the data source.

I find I can only install one self-hosted integration runtime and associate it with only one Synapse.

Can I kindly ask how I can enable two Synapse to read from the same On-prem SQL server?

Thanks,
Gary

azure-synapse-analytics
· 2
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.

Hello @GaryCui-4085,

Following up to see if the below suggestion was helpful. And, if you have any further query do let us know.


  • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you.

0 Votes 0 ·

Microsoft please fix this.

0 Votes 0 ·

1 Answer

PRADEEPCHEEKATLA-MSFT avatar image
0 Votes"
PRADEEPCHEEKATLA-MSFT answered PRADEEPCHEEKATLA-MSFT commented

Hello @GaryCui-4085,

Welcome to the Microsoft Q&A platform.

Unfortunately it doesn’t support sharing SHIR among different Synapse workspaces.

132588-image.png

For more details, refer to Data integration in Azure Synapse Analytics versus Azure Data Factory.

But it’s in our product team backlog. We don't have any ETA at the moment but I would recommend you to please subscribe Azure Updates page for new feature announcements and updates about Azure Products.

Once the feature is available we will update this answer.

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


image.png (47.2 KiB)
· 1
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.

Hello @GaryCui-4085,

Just checking in to see if the above answer helped. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.

0 Votes 0 ·