I have connected MYSQL Database to KNIME and i am not sure on how to get the databases auto updated. Suppose today my table is having 1000 records and if i add one record to the table through UI , will the Database which is linked in KNIME gets updated automatically?
If not , please help us how to sink data automatically to KNIME DB!
KNIME provides several data manipulation nodes such as writer, update, drop table and sql executor. If you want to update your database by adding new records and using KNIME Analytics Platform, you should use the Database Update node. Please find attached an example workflow that shows how to complete the update operation.
Hope that helps,