Permanent connection to a Database

KNIME Analytics Platform
1

Hi,

I was wondering if it's possible to create a permanent/dynamic connection to a MYSQL Database using Knime ?

For instance, at the moment, i have a database, with a table that i use for predictive learning, but i sometimes add data on that table. And if i want Knime to access the new data, i need to reset the Database Reader node each time. 

Is there any way to have a permanent connection, that would detect a change in the database and implement it instantly ?

Best regards,

Arcaf

2

Hi Arcaf,

No, there is no way to automatically detect changes in a database. One possible workaround would be to run your workflow on a schedule, so that you query the data in regular intervals. This would require a license for KNIME Server Lite, see here: https://www.knime.org/knime-collaboration-extensions

Cheers,

Roland