Install an on-premises data gateway to transfer data quickly and securely between PowerApps and a data source that's not in the cloud, such as an on-premises SQL Server database or an on-premises SharePoint site. View all gateways for which you have administrative permissions, and manage permissions and connections for those gateways.

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

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

Note: For SharePoint, gateways support HTTP traffic but not HTTPS traffic.

Prerequisites

  • The user name and password that you used to sign up for PowerApps
  • 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.
  • Gateways and on-premises connections can only be created and used in the user's default environment.

Install a gateway

  1. In the left navigation bar of powerapps.com, click or tap Gateways.

    Gateways in left navigation bar

  2. If you don't have administrative permissions for a gateway, click or tap Install a gateway now (or New Gateway in the upper-right corner), and then follow the prompts in the wizard that appears.

    Gateways Install

    For details about how to install a gateway, see Understand gateways.

View and manage permissions

  1. In the left navigation bar of powerapps.com, click or tap Gateways, and then click or tap a gateway.

  2. Add a user to a gateway by clicking or tapping Users, specifying a user or group, and then specifying a permission level:

    • Admin: Administrator who has full control, including adding users and setting permissions for the gateway.
    • Can use: User who can create a connection on the gateway.
    • Can use + share: User who can create a connection on the gateway and automatically share it when sharing an app.

View and manage connections

  1. In the left navigation bar of powerapps.com, click or tap Gateways, and then click or tap a gateway.

  2. Click or tap Connections, and then click or tap a connection to view or modify its details.

  3. To share a connection, click or tap Share, and then add or remove users.

    Note: You can share only some types of connections, such as SQL Server. For more information, see Share app resources.

For more information about how to manage a connection, see Manage connections.

Next steps