Manage an on-premises data gateway in Microsoft Flow

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 Microsoft Flow.

With a gateway, you can connect to on-premises data over these connections:

  • SharePoint
  • SQL Server
  • Oracle
  • Informix
  • Filesystem
  • DB2


Microsoft SharePoint data gateways support HTTP traffic, but not HTTPS traffic.


  • The user name and password that you used to sign up for Microsoft Flow.
  • Administrative permissions on a gateway.

    You have these permissions by default for each gateway that you install, and 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 only in your default environment.

View your gateways

In the upper-right corner of the Microsoft Flow website, click or tap the gear icon, and then click or tap Gateways.

Gateway under manage

Note: If you created or were given access to a gateway in PowerApps, that gateway appears in the My gateways list in Microsoft Flow.

Install a gateway

  1. Download the gateway-installation wizard.

    You can also download this wizard by clicking or tapping the gear icon in the upper-right corner of the Microsoft Flow website, clicking or tapping Gateways, and then clicking or tapping Create gateway.

    Gateway installation

  2. Run the wizard, providing the same credentials with which you signed into Microsoft Flow.

    After you register and configure your gateway successfully, it shows up in the My gateways list in Microsoft Flow.

For more information, see Understand gateways.