Passing Parameter to a Stored Procedure Activity in Azure Data Factory

Requirement: I have a SQL procedure which has the input parameters. How can I pass the parameters to that SQL procedure in a data pipeline in Azure Data Factory

Solution:

1. Create procedure in a SQL database with input parameter



2. Log into azure portal and click on existed or new data factory. Next click on Author & Monitor
3. New window will open, click on Create Pipeline. Enter the name of the pipeline
4. On the Activities tab, search Stored Procedure activity and drag it into the editor



5. In General settings enter name of the activity, click on SQL account
6. Here we have to select the SQL datasource which we created using Gateway to connect on-premises SQL server. Click on test connection



7. Click on Stored Procedure



8. Click on the select dropdown of Stored procedure name and select the procedure which we created in first step
9. Next click on Import Parameter. It will import the parameter of that SQL procedure



10. In the above image we can see that parameter got imported. Enter the value in VALUE input section



11. Save the pipeline and Execute the pipeline

Make data easy with Helical Insight.
Helical Insight is world’s best open source business intelligence tool.

Click Here to Free Download

12. SQL procedure will be executed for the entered value

Thank You
Ramu Vudugula
BI Developer
Helical IT Solutions Pvt Ltd

Best Open Source Business Intelligence Software Helical Insight Here

A Business Intelligence Framework

Free
Download

Best Open Source Business Intelligence Software Helical Insight is Here

A Business Intelligence Framework

Free
Download