Share via

ADF and azure MYSQL stored procedure

Biggy 0 Reputation points
2023-11-09T14:38:30.0666667+00:00

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.
11,017 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Nandan Hegde 32,991 Reputation points MVP
    2023-11-09T14:47:46.7933333+00:00

    Hey,

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

    PFB similar reference :

    https://stackoverflow.com/questions/64438768/executing-mysql-procedure-from-azure-data-factory

    You can use lookup activity for the same.

  2. ShaikMaheer-MSFT 38,476 Reputation points Microsoft Employee
    2023-11-14T12:29:50.8833333+00:00

    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.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.