On-premises data gateway allows you to access on-premises data with PowerApps!
The gateway is a bridge from your app to the on-premises or virtual machine where your data is stored. On-premises means that your data is stored on a server physically located within your organization, not in the cloud. A virtual machine acts as a private cloud-based server. The gateway can be deployed centrally and you can connect to your on-premises data and manage it securely from PowerApps.
In this blog, I’ll demonstrate how we can create a simple App in PowerApps which can connect to on-premises SQL database. The App is created to capture Leads information from the user’s phone and the submitted data is saved to SQL database which is on-premises.