在 PowerApps 中管理本地数据网关Manage an on-premises data gateway in PowerApps

安装本地数据网关,以便在 PowerApps 和不在云中的数据源(如本地 SQL Server 数据库或本地 SharePoint 网站)之间快速、安全地传输数据。Install an on-premises data gateway to transfer data quickly and securely between PowerApps and a data source that isn't 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:

  • SharePointSharePoint
  • SQL ServerSQL Server
  • OracleOracle
  • InformixInformix
  • FilesystemFilesystem
  • DB2DB2

必备组件Prerequisites

  • 注册 PowerApps 时使用的用户名和密码。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 accessing on-premises data using an on-premises gateway. 有关详细信息,请参阅定价页的“连接性”部分。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. powerapps.com 的左侧导航栏中,单击或点击“网关”。In the left navigation bar of powerapps.com, click or tap Gateways.

    左侧导航栏中的“网关”

  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.

    网关安装

    若要详细了解如何安装网关,请参阅了解本地数据网关For details about how to install a gateway, see Understand on-premises data gateways.

查看和管理网关权限View and manage gateway permissions

  1. powerapps.com 的左侧导航栏中,依次单击或点击“网关”和一个网关。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:

    • 可使用:用户可以在网关上创建用于应用和流的连接,但不能共享网关。Can use: Users who can create connections on the gateway to use for apps and flows, but cannot share the gateway. 对运行应用但不共享应用的用户使用此权限。Use this permission for users who will run apps but not share them.
    • 可使用和共享:用户可以在网关上创建用于应用和流的连接,并可在共享应用时自动共享网关。Can use + share: Users who can create a connection on the gateway to use for apps and flows, and automatically share the gateway when sharing an app. 对需要与其他用户或组织共享应用的用户使用此权限。Use this permission for users who need to share apps with other users or with the organization.
    • 管理员:管理员可以完全控制网关,包括添加用户、设置权限、创建与所有可用数据源的连接和删除网关。Admin: Administrators who have full control of the gateway, including adding users, setting permissions, creating connections to all available data sources, and deleting the gateway.

对于“可使用”和“可使用和共享”权限级别,请选择用户可以通过网关连接的数据源。For Can use and Can use + share permission levels, select the data sources that the user can connect to over the gateway.

查看和管理网关连接View and manage gateway connections

  1. powerapps.com 的左侧导航栏中,依次单击或点击“网关”和一个网关。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 its details, edit the settings, or delete it.
  3. 要共享连接,请单击或点击“共享”,然后添加或删除用户。To share a connection, click or tap Share, and then add or remove users.

    注意:可以仅共享某些类型的连接,例如 SQL Server。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 your connections.

疑难解答和高级配置Troubleshooting and Advanced Configuration

若要详细了解如何排查网关问题或配置网络网关服务,请参阅了解本地数据网关For more information on troubleshooting issues with gateways, or configuring the gateway service for your network, see Understand on-premises data gateways.

后续步骤Next steps