topic Re: Common On-Premise data gateway to access multiple SQL servers from Fabric Data Factory in Data Engineering

Common On-Premise data gateway to access multiple SQL servers from Fabric Data Factory

MaheshSanga — Thu, 23 Jan 2025 15:58:13 GMT

HI Team, we are migrating ADF pipelines to Fabric Data Factory where as we have On-Premisis sql servers data copying with Integration runtime now we are trying to set up common On-Premisis Gateway to connect multiple sql servers.

looking some help in setting up common gateway.

Re: Common On-Premise data gateway to access multiple SQL servers from Fabric Data Factory

govindarajan_d — Thu, 23 Jan 2025 16:20:09 GMT

Hi MaheshSanga,

Similar to ADF Self-hosted Integration Runtime (SHIR), you have a On-premises Gateway in Fabric through which you would be connecting to the on-prem systems.

In the current VM where you have installed SHIR, you can install On-prem gateway as well and establish connection to it from Power BI Manage connections page. Once you configure the gateway, you can create SQL connections on the Gateway using the same Manage Connections page.

Re: Common On-Premise data gateway to access multiple SQL servers from Fabric Data Factory

MaheshSanga — Thu, 23 Jan 2025 16:23:06 GMT

yes I have done it already able to connect SQL Server from gateway but would need help in how to set the same gateway to access multiple sql servers which are from different VM's like centralized Gateway across sql servers.

Re: Common On-Premise data gateway to access multiple SQL servers from Fabric Data Factory

govindarajan_d — Thu, 23 Jan 2025 16:47:15 GMT

Hi MaheshSanga,

You need to install the gateway in the multiple VMs you mentioned, and you would require the recovery key that you had generated when you installed the gateway the first time.

Below is the complete instructions on how to do that:

https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-install#add-another-gateway-to-create-a-cluster

Re: Common On-Premise data gateway to access multiple SQL servers from Fabric Data Factory

v-aatheeque — Tue, 28 Jan 2025 16:38:41 GMT

Hi MaheshSanga ,

If our response addressed by the govindarajan_d your query, please mark it as Accept Answer and click Yes if you found it helpful.

Should you have any further questions, feel free to reach out.

Thank you for being a part of the Microsoft Fabric Community Forum!

Re: Common On-Premise data gateway to access multiple SQL servers from Fabric Data Factory

v-aatheeque — Sat, 01 Feb 2025 17:50:53 GMT

Hi MaheshSanga ,

If our previous response posted by govindarajan_d was helpful, please consider clicking "Accept Answer" and selecting "Yes" for whether the answer was helpful. If you have any further questions or need additional assistance, please don't hesitate to reach out.

Thanks for using Microsoft Fabric Community.

Re: Common On-Premise data gateway to access multiple SQL servers from Fabric Data Factory

v-aatheeque — Wed, 05 Feb 2025 10:18:46 GMT

Hi @MaheshSanga ,

If our response addressed by the @govindarajan_d your query, please mark it as Accept Answer and click Yes if you found it helpful.

Should you have any further questions, feel free to reach out.

Thank you for being a part of the Microsoft Fabric Community Forum!