We are living in a digital transformation to O365, but by the time we are doing this, our customers still need to connect their On-Premises data like SharePoint or SQL to Office 365 applications (PowerApps, Microsoft Flow, Logic Apps, Power BI).
For that reason, Microsoft has introduced on-premises data gateway for providing a quick and secure connection between on premise data and Office 365 apps.
We must keep in mind that there are two different types of gateways, one of them is On-Premises and the other gateway, is the personal gateway, which only allows to connect to PowerBI and can be used as an individual without any administrator configuration.
In the following image, we can see the differences between the personal gateway and the On-Premises gateway:
Moreover, the current supported On-Premises applications are SharePoint 2016 and SQL 2016, as you can see in the diagram below, there are multiple O365 connections to On-Premises services:
The installation process is straightforward, and only is needed a server with the following requirement to use the gateway:
Hardware Requirements:
| Hardware Requirements | Value |
| CPU | 8 Cores |
| RAM | 8 GB |
Software Requirements:
| Software Requirements | Value |
| .NET Framework | Version – 4.5 |
| Operating System | Windows 7 / Windows Server 2008 R2, or later |
If you require more info about the gateway, you can follow the links:
https://flow.microsoft.com/es-es/blog/on-premises-data-gateway/
https://powerbi.microsoft.com/es-es/documentation/powerbi-gateway-onprem/
https://docs.microsoft.com/es-es/azure/analysis-services/analysis-services-gateway
Albandrod's Memory 