Blog

Hugo Bernier shares his expertise in technology to explain how gateway services work and how to install one. 

When using cloud-based services like Office 365 and the Power Platform, it can be challenging to integrate with your on-premises resources. All of a sudden, your on-premises databases, APIs, file shares, and even your existing on-premises SharePoint infrastructure become impossible to reach. At least, not without making some giant holes in your firewall.

At our recent Toronto Citizen Developer User Group meeting, my good friend Luis Duran demonstrated how to use the on-premises data gateway to access a custom web API running on his workstation from Power Automate.

He had rehearsed the demo earlier that day from our offices. Still, he had changed many environmental variables by moving his demo to our meetup venue. Luis ran a web API from his workstation, over a different network (the guest wifi at the Microsoft office), using a new IP address.

Let’s say that if his demo didn’t work, no one would have blamed him. Heck, I tried to run a web API project using a static IP address on my workstation earlier in the day, and I had issues getting it to work.

But the demo worked!

Areas covered in this article include:

• What is the on-premises data gateway
• How the data gateway works
• What the requirements are
• How to install a gateway
• How to use a gateway connection

Read the full article, Accessing Your On-Premises Data Using the On-Premises Data Gateway, on the Tahoe Ninja’s website.