Let us take a simple example to understand the steps to be performed for configuring an On-premises data gateway.
We have below database in our on-premise SQL Server which we connect to using On-Premise data gateway.
Below are the steps we need to perform to configure it –
Login to Power Apps and navigate to Data – Gateways
Download the On-Premises Data Gateway
Follow the installation wizard to install the on-premises data gateway
Sign in with the Office 365 Organization account
Select Register a new gateway on this computer
Specify the name and the recovery key and click on configure
This completes the setup of the gateway.
Within Power Apps, we can see the gateway record created.
Now let us create a connection to our On-Premise SQL Server Database that uses the gateway configured
Navigate to Data – Connections and click on the new connection.
Select the SQL Server connection type, and specify the connection details of the on-prem database.
Select the gateway configured and click on Save, which will test the connection.
On a successful connection, we can see the connection created with status Connected.
Now as we have the connection established with our On-Premise SQL Server database through the gateway, we can use it for in various cloud services like Power BI, Power Apps, Power Automate, Logic Apps, Dataflow, etc.
Get more details here
Another option to connect to SQL On-Prem database is through Azure Hybrid Connections (this would for Azure App Service)
Hope it helps..