Scenario: We have to connect to an on-premise SQL Server/Oracle database and have three synapse workspaces in Azure, DEV, UAT and PROD in three different subscriptions.
Current- Architecture
To connect to these sources on the on-premise networks we have virtual networks set up on Azure, gateways and site to site connections to local network.
The downside of this is having to maintain a lot more from an administrator perspective,
- Three Virtual Networks
- Peering between three networks
- Three seperate Virtual Machines to host the respective Azure Self Hosted IRs
Instead of this, we thought of simplifying it and having only one Virtual Network, one VM where self hosted integration runtime is hosted and the IR is shared by all three Synapse workspaces, see below architecture,
 |
| Proposed Architecture with Shared Self Hosted IR. |
Now comes the road-block here, sharing integration run-time is not yet available for Synapse Analytics ( reference - https://learn.microsoft.com/en-us/azure/synapse-analytics/data-integration/concepts-data-factory-differences#available-features-in-adf--azure-synapse-analytics )
This seems to be something in the backlog for the Synapse Analytics Product team, I will be updating here if this comes out in any new releases. This will be really cool to have.
