Lately I've been experimenting a bit with Azure Logic Apps, in combination with an On-premises data gateway. If you've ever used Logic Apps, you may have noticed that you have a set of actions for a SQL Server connection. What you may not know is that you can connect to a local database on your machine using a data gateway.
The first thing to do is install a gateway on your machine, they have a helpful document on how to do this up on Azure. Let's say you've installed a gateway and called it MyGateway. Next we need to create an On-premises Data Gateway in Azure. If you don't see it in your list of services, click "More services >" down at the bottom and you can filter the list to find it (hit the star on the right to add it to your service list). This next part is pretty important - if you already have a resource group that you've been using for Logic Apps, make sure you use the same resource group and location when setting up your gateway (otherwise it will not display as an available option in your Logic App). You should see MyGateway in the Installation Name list at the bottom. Keep in mind that you can only associate one Azure gateway with one installation, if you've already used your installation you won't see it in this list.
Once your gateway has been created, you are free to use it in Logic Apps - there is a simple tutorial in the Azure docs that can step you through this process. When creating your connection, make sure to include your domain (if applicable) in the username box. You should see your gateway in the Gateway list (if you don't you may have set it up incorrectly).
This brings me to the next roadblock I stumbled upon. The first time I created my Gateway, I had used an incorrect location and it didn't show up in my connection dialog in Logic Apps, so I decided to create a new one. Since I was no longer using the first gateway, I wanted to just go ahead and delete it from Azure, but that doesn't seem to be an option in the UI. There is still hope though, as you can delete it using the Azure Management API. To delete your gateway run this command, substituting your environment's info.
Your subscription ID can be found in the Essentials section of your resource group. You will also need to include your Azure Authorization header in your request, you can find this in your browser's dev tools network tracing - look for calls to management.azure.com and inspect the headers used to find the Authorization header.
If you're just getting started you may run into some of the same roadblocks, so hopefully these tips will help you to keep moving forward with your apps!
About the Author:
TopLine Strategies delivers the complete integration and development of sales, marketing and customer service technologies that enable corporate clientele to improve revenue streams and strengthen customer interactions. Our project management and consulting is designed to achieve timely delivery, 100 percent user adoption of the technologies we implement and deliver measurable returns on investments for our clients.