Can I use the same VM for On-prem-gateway and Self-hosted IR for Synapse?

Question

Hello ,

I have a solution which extracts data from oracle db on OCI and store in data lake. Then use Synapse pipilines and Data flows to process the data and store them in sql db.

I use self-hosted IR to extract data from Oracle.

I have another solution where I use Fabric where I am using Data Mirroring and for that I have to use on-prem gateway to replicate data from OCI database.

I have two questions:

1. can on-prem gateway and Synapse Self-Hosted IR be on the same VM? can I use the same machine?
2. for non-prod I want to use two Synapse workspaces (Dev and UAT) and want to use one VM where self-hosted is setup? I can use the same VM for to serve both workspaces?

Please can you let me know as seem to have 4 VMs for this setup which is a bit too much.

Thanks

Xhev

Answer 1

Hey Xhevahir Mehalla,

It sounds like you're exploring the setup of your on-premises data gateway and self-hosted Integration Runtime (IR) and whether you can optimize your VM usage. Here's what you can do:

1. Using the Same VM for On-Prem Gateway and Self-Hosted IR: Yes, you can technically install both the on-premises data gateway and the self-hosted integration runtime on the same VM. However, it's important to note that the self-hosted IR can only have one instance per machine. Since both components are designed to serve distinct purposes data transfer between on-premises and Azure, you might encounter performance issues if your VM becomes resource-constrained. If they are lightweight on resources, you should be able to share the machine effectively.

Using One VM for Multiple Synapse Workspaces: It’s feasible to use the same VM for multiple non-production Synapse workspaces (like Dev and UAT) provided that you manage the configuration correctly. However, be aware that there are limitations due to the sharing of a single self-hosted IR. If you configure your self-hosted IR correctly, it can be accessed by both workspaces as long as they are in the same Microsoft Entra tenant.

Overall, consolidating your VMs can definitely help minimize resource use, just ensure that your single VM has enough CPU and memory to handle both components without impacting performance.

References:

• On-premises data gateway FAQ
• Create and configure a self-hosted integration runtime

Thanks!

Kalyani