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:
You...