Stored Procedure

Hi Team,

I would like to call a stored procedure after the successful execution of workflow in KNIME Business HUB.

The stored procedure just refresh the Table in Microsoft SQL Server.

Please suggest me any solution.

Thanks,
Subbu

any update on my request

Hi @Subramanyam , can the stored procedure just be added as a call using DB SQL Executor at the end of the workflow, or is there more to your use case that we need to know?

1 Like

Hi @takbb

I am having SQL Procedure in Microsoft SQL Server and I want to trigger that from KNIME using SQL Executor Node.

Trigger Code is ap_whse.USP_EDL_OTIFD_WEEKLY_REFRESH.

Please suggest me how to trigger this. will it work or not?

Thanks,

Hi @Subramanyam , what have you tried so far. I don’t have access to SQL Sever at the moment but if you add a DB SQL Executor node, and configure it with

exec ap_whse.USP_EDL_OTIFD_WEEKLY_REFRESH

what happens?

I’m assuming your stored procedure doesn’t return data. If it does, maybe you need to put the call in a DB Query Reader node.

further example:

1 Like