Book Image

Enterprise Integration with Azure Logic Apps

By : Matthew Bennett
Book Image

Enterprise Integration with Azure Logic Apps

By: Matthew Bennett

Overview of this book

Logic Apps are a visual flowchart-like representation of common programming actions, and are a flexible way to create logic without writing a single line of code. Enterprise Integration with Azure Logic Apps is a comprehensive introduction for anyone new to Logic Apps which will boost your learning skills and allow you to create rich, complex, structured, and reusable logic with instant results. You'll begin by discovering how to navigate the Azure portal and understand how your objects can be zoned to a specific environment by using resource groups. Complete with hands-on tutorials, projects, and self-assessment questions, this easy-to-follow guide will teach you the benefits and foundations of Logic App logic design. As you advance, you'll find out how to manage your Azure environment in relation to Logic Apps and how to create elegant and reliable Logic Apps. With useful and practical explanations of how to get the most out of Logic App actions and triggers, you'll be able to ensure that your Logic Apps work efficiently and provide seamless integration for real-world scenarios without having to write code. By the end of this Logic Apps book, you'll be able to create complex and powerful Logic Apps within minutes, integrating large amounts of data on demand, enhancing your systems, and linking applications to improve user experience.
Table of Contents (17 chapters)
1
Section 1: Logic App Fundamentals
7
Section 2: Logic App Design
13
Section 3: Logic App Maintenance and Management

Connecting to a SQL database using an Azure connection profile

Now, let's use Azure to connect to this table. I am going to create a new logic app that will create rows in our database. Create a blank logic app with an HTTP request for the trigger. Then, add a new action. In the catalog, look for SQL and select SQL Server category. From the list of actions, select Insert row.

If you already have a connection profile you can use that to point to the correct server, select it from the list. We don't need to press the Add new button in our case to make a new connection profile.

On the first profile page, set Connection name to something memorable, such as MatthewTestConnection. In this case, we will be using SQL Server authentication to authenticate the connection by using the details from the Connection profile we created earlier.

Here is my completed Connection profile:

Figure 12.11 – Connection profile to access our new database

You...