Connect to on-premises data sources from Azure Logic Apps
To access data sources on premises from your logic apps, create an on-premises data gateway resource in the Azure portal. Your logic apps can then use the on-premises connectors. This article shows how to create your Azure gateway resource after you download and install the gateway on a local computer. For more information about the gateway, see How the gateway works.
To connect to Azure virtual networks, consider creating an integration service environment instead.
For information about how to use the gateway with other services, see these articles:
- Microsoft Power BI on-premises data gateway
- Microsoft Flow on-premises data gateway
- Microsoft PowerApps on-premises data gateway
- Azure Analysis Services on-premises data gateway
Supported data sources
For Azure Logic Apps, the on-premises data gateway supports on-premises connectors for these data sources:
- BizTalk Server 2016
- File System
- IBM DB2
- IBM Informix
- IBM MQ
- Oracle Database
- SharePoint Server
- SQL Server
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.
You've already installed the on-premises data gateway on a local computer.
You have the same Azure account and Azure subscription that you used when you installed the on-premises data gateway.
You haven't previously linked your gateway installation to another gateway resource in Azure.
When you create a gateway resource, you select a gateway installation to associate with your gateway resource. An already linked gateway installation isn't available for you to select when creating gateway resources.
Create Azure gateway resource
After you install the gateway on a local computer, create the Azure resource for your gateway.
Sign in to the Azure portal with the same Azure account that was used to install the gateway.
In the Azure portal search box, enter "on-premises data gateway", and select On-premises Data Gateways.
Under On-premises Data Gateways, select Add.
Under Create connection gateway, provide this information for your gateway resource. When you're done, select Create.
Property Description Resource Name Your gateway resource name, which can contain only letters, numbers, hyphens (
-), underscores (
_), parentheses (
)), and periods (
Subscription Your Azure subscription, which must be the same as gateway installation and logic app. 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 as the location that was selected for the gateway cloud service during gateway installation. Otherwise, your gateway installation won't appear in the Installation Name list for you to select. Your logic app location can differ from your gateway resource location. Installation Name If your gateway installation isn't already selected, select the gateway that you previously installed. Previously linked gateway installations won't appear in this list for you to select.
Here is an example:
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.
In the Azure portal, create or open your logic app in the Logic App Designer.
Add a connector that supports on-premises connections, for example, SQL Server.
Select Connect via on-premises data gateway.
For Gateways, select the gateway resource that you created.
The gateways list includes gateway resources in other regions because your logic app's location can differ from your gateway resource's location.
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:
When you're done, select Create.
Your gateway connection is now ready for your logic app to use.
To update the settings for a gateway connection, you can edit your connection.
To find all API connections for just your logic app, on your logic app's menu, under Development Tools, select API connections.
Select the gateway connection you want, and then select Edit API connection.
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 main Azure menu, go to All services > Web > API Connections.
- Or, from the main Azure menu, go to 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.
From the main Azure menu, select All resources. Find and select your gateway resource.
If not already selected, on your gateway resource menu, select On-premises Data Gateway. On the gateway resource toolbar, select Delete.
Frequently asked questions
Q: Why don't I see my gateway installation when I create the gateway resource in Azure?
A: This issue can happen for these reasons:
Your gateway installation is already registered and claimed by another gateway resource in Azure. Gateway installations don't appear in the instances list after gateway resources are created for them. To check your gateway registrations in the Azure portal, review all your Azure resources with the On-premises Data Gateways type for all Azure subscriptions.
The Azure AD identity for the person who installed the gateway differs from the person who signed in to the Azure portal. Check that you're signed in with the same identity that installed the gateway.
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.