The Stored Procedure activity in Azure Data Factory allows you to execute stored procedures in SQL Server or Azure SQL Database. To use it, you first need to create a linked service connecting to your database. Then you create a dataset pointing to the specific stored procedure you want to run. The Stored Procedure activity is a built-in activity that lets Azure Data Factory run stored procedures on your databases.
1 of 4
Download to read offline
More Related Content
40 Stored Procedure Activity in Azure Data Factory.pptx
1. 40- Azure Data Factory
Stored Procedure Activity in azure data factory
Demo- Stored Procedure Activity
Welcome in BPCloudLearningInHindi
1
2. Stored Procedure Activity:
2
Welcome in BPCloudLearningInHindi
The "Stored Procedure" activity in Azure Data Factory is a built-in activity that allows you
to execute a stored procedure in a SQL Server or an Azure SQL Database.
To use the Stored Procedure activity, you need to first create a linked service to connect to
your SQL Server or Azure SQL Database. Then you need to create a dataset that points to
the stored procedure you want to execute.