AZURE DATA FACTORY - Oracle Database

KnowledgeSeeker 21 Reputation points

Hi ,

Is it possible to execute Oracle Database Stored Procedure in Azure Data Factory and output as a CSV File?

The Stored Procedure tool seems only available for SQL Server Connection.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
7,213 questions
0 comments No comments
{count} votes

Accepted answer
  1. MartinJaffer-MSFT 25,716 Reputation points

    Hello @KnowledgeSeeker and thank you for your question.

    While the Copy Activity option to select Stored Proc may not exist for Oracle table dataset the same way it exists for SQL, there is something you can try.

    In the Copy Activity "Use query" option where you can select "table" or "query", when you select "query" there is a space to write your own query statement. In this space you can write anything. Try writing an Execute stored proc statement here.

    Please let me know if this solves your issue.

0 additional answers

Sort by: Most helpful