Stored Procedure

KNIME Analytics Platform
1

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

2

any update on my request

3

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
4

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,

5

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