How to execute MariaDB storedprocedure from Azure Data Factory?

Question

How to execute MariaDB storedprocedure from Azure Data Factory?

Ankit Kumar 21

I wanted to 'Call' MariaDB Procedure from Azure Data Factory.

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

I tried calling the procedure by writing query using lookup activity.

It fails while showing this error.
ErrorCode=InvalidParameter,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=The value of the property 'columns' is invalid: 'Value cannot be null. Parameter name: columns'.,Source=,''Type=System.ArgumentNullException,Message=Value cannot be null. Parameter name: columns,Source=Microsoft.DataTransfer.Common,'

Bhargava-MSFT 31,261 Reputation points Microsoft Employee Moderator

2022-12-20T20:08:08.783+00:00

Hello @Ankit Kumar ,

Welcome to the MS Q&A platform.

By selecting the 'query' option, you can call the stored procedure using lookup activity. From your error message, it looks like you are missing the parameter columns while calling the stored procedure.

Did you try executing the same code using the client tools like MySQL workbench? If you can execute the stored proc from other client tools, then you should be able to execute the same using the lookup activity.

I tested from my end and was able to execute the Stored procedure using lookup activity. Please see the below screenshot for your reference.

I hope this helps. Please let me know if you have any further questions.
Ankit Kumar 21 Reputation points

2022-12-21T05:06:35.657+00:00

I executed the stored proc in Mysql Workbench, it is working there.
But when I am calling the same in lookup activity, it is showing the error.
How to fix the parameter column?
Ankit Kumar 21 Reputation points

2022-12-22T04:26:40.427+00:00

Thanks for the link you provided.

The Stored proc I called was not returning any record, so I added Select statement after the call stored_proc name() and now the lookup activity is executing successfully.
Bhargava-MSFT 31,261 Reputation points Microsoft Employee Moderator

2022-12-22T11:24:48.45+00:00

Hello @Ankit Kumar ,
Glad to know it's working for you. If you don't have any further questions, please consider accepting the answer by hitting the Accept answer button, as it helps the community looking for answers to similar questions.

Accepted answer

0 additional answers

Your answer

Bhargava-MSFT 31,261 Reputation points Microsoft Employee Moderator

2022-12-20T20:08:08.783+00:00

Hello @Ankit Kumar ,

Welcome to the MS Q&A platform.

By selecting the 'query' option, you can call the stored procedure using lookup activity. From your error message, it looks like you are missing the parameter columns while calling the stored procedure.

Did you try executing the same code using the client tools like MySQL workbench? If you can execute the stored proc from other client tools, then you should be able to execute the same using the lookup activity.

I tested from my end and was able to execute the Stored procedure using lookup activity. Please see the below screenshot for your reference.

I hope this helps. Please let me know if you have any further questions.
Ankit Kumar 21 Reputation points

2022-12-21T05:06:35.657+00:00

I executed the stored proc in Mysql Workbench, it is working there.
But when I am calling the same in lookup activity, it is showing the error.
How to fix the parameter column?
Ankit Kumar 21 Reputation points

2022-12-22T04:26:40.427+00:00

Thanks for the link you provided.

The Stored proc I called was not returning any record, so I added Select statement after the call stored_proc name() and now the lookup activity is executing successfully.
Bhargava-MSFT 31,261 Reputation points Microsoft Employee Moderator

2022-12-22T11:24:48.45+00:00

Hello @Ankit Kumar ,
Glad to know it's working for you. If you don't have any further questions, please consider accepting the answer by hitting the Accept answer button, as it helps the community looking for answers to similar questions.

Answer 1

Hello @Ankit Kumar ,
Thanks for the reply. Are you using any input parameters in your SP?
Could you please share your SP definition?
I am going through a similar error message on the below thread; as per the suggestion, it requires a specific syntax.
I was able to call the sp using the below syntax(also, it worked for me using the standard syntax).

https://stackoverflow.com/questions/65282135/execute-a-stored-procedure-in-oracle-from-azure-data-factory-v2

call sp1();

Can you please try this from your end and see

Share via

How to execute MariaDB storedprocedure from Azure Data Factory?

0 additional answers

Your answer