0

I wanted to 'Call' MySql (Azure) Procedure from Azure Data Factory. I can with SQL Server Procedure from ADF but not MySQL Procedures.

How can this be achieved, are there any other service which can be integrated with ADF to call this mysql procedures

Sreedhar
  • 29,307
  • 34
  • 118
  • 188

2 Answers2

0

We can call the Azure SQL for MySQL stored procedure in query operation at Source.

For example, I create a stored procedure and call it successfully in Data Factory: enter image description here

Query operation: Call GetData():

enter image description here

There are many limits that the stored procedure must be query or have return value.

Others have posted the feedback: enter image description here

We can continue to vote it up and Data Factory could see it. Hope they can think about provide the full stored procedure feature support.

Leon Yue
  • 15,693
  • 1
  • 11
  • 23
0

You can use lookup Activity if you just need to call the Stored procedure. I tried today for the stored procedure (which update the table) and it worked.

Karthickselvam
  • 1