To get started, we will need two separate components:
- An Azure Logic Apps instance
- An Azure SQL database
To create a logic app instance, go to the marketplace and search for logic app:
Fig. 10.39 – Logic App in Azure Marketplace
You will have to enter all the required fields:
- The name of your application
- Location
- Resource group
- Subscription
Azure SQL can be created using the Azure CLI, using two commands—az sql server create for SQL Server creation and az sql db create for creating a SQL database:
$ az sql server create -g <rg-name> -n <server-name> -l westeurope -u <admin-username> -p <admin-password>
$ az sql db create -n c<db-name> -g <rg-name> -s <server-name>
Once those two services are created, we can start the integration process. To integrate SQL Server with an Azure logic app, you will have to perform a few simple steps, which are described here:
- Click on the...