azure-data-factoryazure-mysql-database

Executing MySQL procedure from Azure Data Factory


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


Solution

  • 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.