Using Trigger workflow for SQL DB change in KNIME

[madhumita3]

Hi Team

I am looking for a solution, is there any node where we can use to run trigger on sql Table and send a notification when there is any changes in DB.

Thank you
Madhu

[madhumita3]

any suggestion please!

Thank you
Madhu

[mlauber71]

@madhumita3 you might want to give us a little more context. Like what kind of database is this and how would you come about the changes.

In this example a workflow will run in certain intervals and when something changed some action will be triggered.

Start a Workflow, e. g. a database query, after a certain time

@USCHUKN1ME I tried to build a system you might be able to expand and use. The idea is to have a workflow that would iterate a number of times (v_number_of_intervals) with a set interval (of seconds) between (v_seconds_interval) them. The workflow looks for a trigger_file.csv if this file has changed from the last time the loop has run a component would be executed. If the file has not changed nothing would happen. Admittedly not the most elegant way but you could build a small automatic execu…