ADF and azure MYSQL stored procedure

Biggy 0 Reputation points

I have created a linked service for azure database for mysql. I am able to pull or push data to a table. But when I tried to call the stored procedure, I can't see the linked service from the settings in stored procedure components. Could someone help?

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

2 answers

Sort by: Most helpful
  1. Nandan Hegde 27,391 Reputation points MVP


    Based on my understanding MySQL SP is not supported within ADF SP activity.

    PFB similar reference :

    You can use lookup activity for the same.

  2. ShaikMaheer-MSFT 35,796 Reputation points Microsoft Employee

    Hi Biggy,

    Thank you for posting query in Microsoft Q&A platform.

    In Lookup Activity try to write query that runs your SP. This way Lookup Activity can run your SP. Also, inside Lookup Activity you will have SP option. Try that option as well if that suits for you. I believe your API provides you some values in output json of activity which you want to pass to SP parameters. Write expressions to take API values and pass them to SP parameters in Lookup Activity.

    Hope this helps. Please let me know if any further queries.

    Please consider hitting Accept Answer button. Accepted answers help community as well. Thank you.