Connect to on-premises data sources from Azure Logic Apps

After you install the on-premises data gateway on a local computer and before you can access data sources on premises from your logic apps, you need to create a gateway resource in Azure for your gateway installation. You can then select this gateway resource in the triggers and actions that you want to use for the on-premises connectors available in Azure Logic Apps.

This article shows how to create your Azure gateway resource for a previously installed gateway on your local computer. For more information about the gateway, see How the gateway works.

Tip

To directly access on-premises resources in Azure virtual networks without having to use the gateway, consider creating an integration service environment instead.

For information about how to use the gateway with other services, see these articles:

Supported data sources

In Azure Logic Apps, the on-premises data gateway supports the on-premises connectors for these data sources:

  • BizTalk Server 2016
  • File System
  • IBM DB2
  • IBM Informix
  • IBM MQ
  • MySQL
  • Oracle Database
  • PostgreSQL
  • SAP
  • SharePoint Server
  • SQL Server
  • Teradata

Azure Logic Apps supports read and write operations through the data gateway. However, these operations have limits on their payload size. Although the gateway itself doesn't incur additional costs, the Logic Apps pricing model applies to these connectors and other operations in Azure Logic Apps.

Prerequisites

  • You already installed the on-premises data gateway on a local computer. This gateway installation must exist before you can create a gateway resource that links to this installation.

  • You have the same Azure account and subscription that you used for your gateway installation. This Azure account must belong only to a single Azure Active Directory (Azure AD) tenant or directory. You need to use the same Azure account and subscription to create your gateway resource in Azure because only the gateway administrator can create the gateway resource in Azure. Service principals currently aren't supported.

    • When you create a gateway resource in Azure, you select a gateway installation to link with your gateway resource and only that gateway resource. Each gateway resource can link to only one gateway installation. You can't select a gateway installation that's already associated with another gateway resource.

    • Your logic app and gateway resource don't have to exist in the same Azure subscription. Provided that you have subscription access, in triggers and actions that can access on-premises data sources, you can select other Azure subscriptions that have gateway resources.

Create Azure gateway resource

After you install the gateway on a local computer, create the Azure resource for your gateway.

  1. Sign in to the Azure portal with the same Azure account that was used to install the gateway.

  2. In the Azure portal search box, enter "on-premises data gateway", and select On-premises Data Gateways.

    Find "On-premises data gateway"

  3. Under On-premises Data Gateways, select Add.

    Add new Azure resource for data gateway

  4. Under Create connection gateway, provide this information for your gateway resource. When you're done, select Create.

    Property Description
    Resource Name Provide a name for your gateway resource that contains only letters, numbers, hyphens (-), underscores (_), parentheses ((, )), or periods (.).
    Subscription Select the Azure subscription for the Azure account that was used for the gateway installation. The default subscription is based on the Azure account that you used to sign in.
    Resource group The Azure resource group that you want to use
    Location The same region or location that was selected for the gateway cloud service during gateway installation. Otherwise, your gateway installation won't appear in the Installation Name list. Your logic app location can differ from your gateway resource location.
    Installation Name Select a gateway installation, which appears in the list only when these conditions are met:

    - The gateway installation uses the same region as the gateway resource that you want to create.
    - The gateway installation isn't linked to another Azure gateway resource.
    - The gateway installation is linked to the same Azure account that you're using to create the gateway resource.
    - Your Azure account belongs to a single Azure Active Directory (Azure AD) tenant or directory and is the same account that you used for the gateway installation.

    For more information, see the Frequently asked questions section.

    Here is an example that shows a gateway installation that's in the same region as your gateway resource and is linked to the same Azure account:

    Provide details to create data gateway resource

Connect to on-premises data

After you create your gateway resource and associate your Azure subscription with this resource, you can now create a connection between your logic app and your on-premises data source by using the gateway.

  1. In the Azure portal, create or open your logic app in the Logic App Designer.

  2. Add a connector that supports on-premises connections, for example, SQL Server.

  3. Select Connect via on-premises data gateway.

  4. Under Gateways, from the Subscriptions list, select your Azure subscription that has the gateway resource you want.

    Provided that you have subscription access, you can select from different Azure subscriptions that are each associated with a different gateway resource. Your logic app and gateway resource don't have to exist in the same Azure subscription.

  5. From the Connection Gateway list, which shows the available gateway resources in your selected subscription, select the gateway resource that you want. Each gateway resource is linked to a single gateway installation.

    Note

    The gateways list includes gateway resources in other regions because your logic app's location can differ from your gateway resource's location.

  6. Provide a unique connection name and other required information, which depends on the connection that you want to create.

    A unique connection name helps you easily find that connection later, especially if you create multiple connections. If applicable, also include the qualified domain for your username.

    Here is an example:

    Create connection between logic app and data gateway

  7. When you're done, select Create.

Your gateway connection is now ready for your logic app to use.

Edit connection

To update the settings for a gateway connection, you can edit your connection.

  1. To find all the API connections for just your logic app, on your logic app's menu, under Development Tools, select API connections.

    On your logic app menu, select "API Connections"

  2. Select the gateway connection you want, and then select Edit API connection.

    Tip

    If your updates don't take effect, try stopping and restarting the gateway Windows service account for your gateway installation.

To find all API connections associated with your Azure subscription:

  • From the Azure portal menu, select All services > Web > API Connections.
  • Or, from the Azure portal menu, select All resources. Set the Type filter to API Connection.

Delete gateway resource

To create a different gateway resource, link your gateway installation to a different gateway resource, or remove the gateway resource, you can delete the gateway resource without affecting the gateway installation.

  1. From the Azure portal menu, select All resources, or search for and select All resources from any page. Find and select your gateway resource.

  2. If not already selected, on your gateway resource menu, select On-premises Data Gateway. On the gateway resource toolbar, select Delete.

    For example:

    Delete gateway resource in Azure

Frequently asked questions

Q: Why doesn't my gateway installation appear when I create my gateway resource in Azure?
A: This issue can happen for these reasons:

  • Your Azure account isn't the same account that you used for the gateway installation on your local computer. Check that you signed in to the Azure portal with the same identity that you used for the gateway installation. Only the gateway administrator can create the gateway resource in Azure. Service principals currently aren't supported.

  • Your Azure account doesn't belong to only a single Azure AD tenant or directory. Check that you're using the same Azure AD tenant or directory that you used during gateway installation.

  • Your gateway resource and gateway installation don't exist in the same region. However, your logic app's location can differ from your gateway resource location.

  • Your gateway installation is already associated with another gateway resource. Each gateway resource can link to only one gateway installation, which can link to only one Azure account and subscription. So, you can't select a gateway installation that's already associated with another gateway resource. These installations won't appear in the Installation Name list.

    To review your gateway registrations in the Azure portal, find all your Azure resources that have the On-premises Data Gateways resource type across all your Azure subscriptions. To unlink the gateway installation from the other gateway resource, see Delete gateway resource.

Q: Why did the location for my existing gateway change?
A: Gateway resources created before May 3, 2017 were moved to the original locations of the Azure AD tenant for the work or school account that created those gateways. However, these changes shouldn't affect currently running logic apps, which should continue working as usual. With the gateway's general availability in May, gateway resource locations can differ from logic app locations.

Next steps