I have been trying to find a way to update my database on the cloud without downloading it as a KNIME table. I am able to perform all transformations, but not able to update the database (save the changes) without using the DB reader table node that downloads data into KNIME. I can only see below two nodes that update/write db, but input for both of them is a KNNIME table.
Any help would be highly appreciated.
@prabhpreetsidhu welcome to the KNIME forum
Concerning the transfer of data from one DB to another without full downloading the data to KNIME there is this workflow example by Tobias. Not sure if such a streaming approach would also work for your problem:
@mlauber71 Thank you very much for getting back to me. This seems to do the trick but inside the streaming component, DB reader is used which converts data into KNIME table. Here is the snapshot of the streaming component.
If you stay within the same database you should be able to use the DB SQL Executor or the DB Connection Table Writer and the nodes with the ‘brown’ squares - they would just send commands to the DB without downloading any data.
Maybe you can check these DB examples for a big data system
More examples concerning database operations you can find here
The DB SQL Executor solves the problem. Thank you again!
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.