Azure: Execute Stored Procedure using Azure Data Factory

In this blog post, we’ll see how to execute Stored Procedure in Azure SQL Database inside Azure SQL Server. Let’s go through the steps to see it in action.

• Login to Azure Portal.
• Click Create a resource –> Databases –> SQL Database.

• Give a unique name to the Azure SQL Database. Click on Server field to create Azure SQL Server on the fly. 
• Give a unique name to the Azure SQL Server, provide credential for login and click Select.

• Make sure the Azure SQL Server that we just created is selected as Server while creating Azure SQL Database. Fill the mandatory fields and click Create.

• Let’s connect to the Azure SQL Server using SSMS. On clicking Connect a new pop up will open where we need to put Azure subscription credential to login.

• Using Azure subscription credential we need to create a firewall rule so that…