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
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?
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: