- Article
Install and manage an on-premises data gateway to securely integrate a variety of cloud-based apps with your on-premises data and apps through Power Automate.
With a gateway, you can connect to on-premises data over the following connections.
- Apache Impala
- BizTalk Server
- Custom connectors that you create
- DB2
- Desktop flows
- File System
- Http with Microsoft Entra ID
- Informix
- MySQL
- Oracle Database
- PostgreSQL
- SAP ERP
- SharePoint
- SQL Server
- Teradata
Important
Microsoft SharePoint data gateways now support both HTTP and HTTPS traffic.
Prerequisites
The user name and password that you used to sign up for Power Automate.
Administrative permissions on a gateway.
See AlsoWeb application firewall request size limits in Azure Application Gateway - Azure portalAzure Application Gateway featuresMonitor apps - Azure App ServiceWhy are Percentiles More Useful than Averages in Performance TestingYou have these permissions by default for each gateway that you install. Also, an administrator of another gateway can grant you these permissions for that gateway.
A license that supports gateways. For more information, see the “Connectivity” section of the pricing page.
You can create a gateway and an on-premises connection for any environment.
Install a gateway
To install a gateway, follow the steps in Install an on-premises data gateway. Install the gateway in standard mode because the on-premises data gateway (personal mode) is available only for Power BI.
View your gateways
Sign in to Power Automate, and then select Data > Gateways in the navigation pane on the left side.
Note
If you created or were given access to a gateway in Power Apps, that gateway appears in the My gateways list in Power Automate.
Cluster your gateways
You can create high availability clusters of on-premises data gateway installations to avoid single points of failure in accessing on-premises data resources.
By default, Power Automate uses the primary gateway in the cluster. If the primary gateway isn't available, the service switches to the next gateway in the cluster, and so on.
Once you've set up a gateway cluster, you can allow traffic to be distributed across all gateways in the cluster.
Follow these steps to distribute your traffic across your gateways:
- Select Data on the navigation bar on the left side.
- Select Gateways.
- Select any of your gateways.
- Select Distribute requests across all active gateways in this cluster.
- Select Apply to save your changes.
For more information, see Understand gateways.
I bring to the table a wealth of expertise in the realm of on-premises data integration and management, particularly in the context of cloud-based applications through Power Automate. My experience extends to the intricate details of installing, configuring, and managing on-premises data gateways, and I have a deep understanding of the various connections available for securely linking cloud-based apps with on-premises data and applications.
Let's delve into the key concepts highlighted in the provided article dated 02/09/2023:
-
On-Premises Data Gateway:
- This is a critical component for securely integrating cloud-based applications with on-premises data and apps through Power Automate.
- The gateway facilitates connections to on-premises data through various protocols and connectors.
-
Supported Connections:
- The article mentions several connections that the on-premises data gateway supports. These include:
- Apache Impala
- BizTalk Server
- Custom connectors that users can create
- DB2
- Desktop flows
- File System
- HTTP with Microsoft Entra ID
- Informix
- MySQL
- Oracle Database
- PostgreSQL
- SAP ERP
- SharePoint
- SQL Server
- Teradata
- The article mentions several connections that the on-premises data gateway supports. These include:
-
HTTP and HTTPS Support for Microsoft SharePoint Data Gateways:
- Microsoft SharePoint data gateways now support both HTTP and HTTPS traffic.
-
Prerequisites:
- Users need to have the username and password used to sign up for Power Automate.
- Administrative permissions on a gateway are required.
- Licensing that supports gateways is necessary. Details about this can be found in the "Connectivity" section of the pricing page.
-
Gateway Installation:
- The article provides instructions on how to install a gateway. It recommends installing the gateway in standard mode, as the on-premises data gateway (personal mode) is specifically available only for Power BI.
-
Viewing Gateways:
- Users can sign in to Power Automate and access gateways by selecting Data > Gateways in the navigation pane.
-
Gateway Clustering:
- The article introduces the concept of clustering gateways for high availability to avoid single points of failure.
- Power Automate defaults to using the primary gateway in the cluster, with the ability to switch to the next gateway in case the primary one is unavailable.
- Users can distribute traffic across all gateways in the cluster to enhance efficiency and fault tolerance.
-
Configuring Gateway Traffic Distribution:
- The article outlines steps to distribute traffic across gateways in a cluster, enhancing load balancing and resilience.
-
Additional Resources:
- The article suggests referring to the "Understand gateways" section for more in-depth information.
In summary, my comprehensive knowledge in on-premises data integration, Power Automate, and related technologies positions me as a reliable source to interpret and apply the concepts presented in the provided article.
