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

Creating and using SQL databases

One of the most used connections is a query to obtain or set data from a SQL database. Azure has a large variety of database connections in its catalog, but one of the most used is the SQL database. However, before we get on to the subject of timeouts and error messages, we need to understand how SQL databases are created and accessed. First, I will explain this process and get us to a point where we can use a database under normal operations. At that point, I will focus on errors and how to manage them.

Two types of databases are available, and this is determined by where the database is stored. If the database is stored within the cloud, it can be accessed by a connection object in the resource group that has direct authentication, typically by using your Azure service account (or user account, if you're not operating on an Enterprise-level project). As the database is a cloud resource, the account is common to both Azure and the database...