First time KNIME user here.
I am trying to extract some data from a postgres server and parse it.
First I want to be able to pull the data at periodic intervals. I tried researching online and came across loops and wait nodes, but none of the solutions really work for me.
I am not planning on using KNIME Webserver due to its very high cost.
is there a way i can execute the query in a periodic manner say every 15mins etc?
I cant seem to even execute the nodes manually unless i make some changes to them. So after 15mins when I want to execute and get the updated table, I have to make and revert a change in one of the node to be bale to hit the execute button.
I was able to kinda make it work with the iris example. Thank you!
Is there a way to se a counter so i know how many times the loop has run? This is for debugging purposes in case it fails an n’th time, I would like to know what n is.
I tried using math formula, but it takes the input from the previous node, which is a table… how do i initialize a value and have it iterate through the loops?
Thank for that suggestion, I would actually like to use this method since it would not involve me having to manually trigger it and leave KNIME open on my machine. However i am an infant with regards to KNIME.
I tried running knime in command prompt, but I get the following screenshot below. I used the following syntax and changed the path where my KNIME application was installed.
Hi @eamendola, my workflow is very simple, as shown in the screenshot below. It just has a PG connector, DB reader and it spits the resulting table to a csv file that is written to a path in my local drive.
All parameters are hardcoded inside the nodes.
What other parameters would I need?
Hi @thentangler , try to add the parameter -reset in your command line. It will make sure that the workflow is reset before it’s executed. You probably want to add -nosave also.
You may consider create a batch file (.bat file) to encapsulate your command, and then schedule your Task Scheduler to execute that batch file.
I would also recommend that you move your workspace outside of the installation path of Knime. Your Knime is most probably installed in C:\Program Files\KNIME\ and it looks like your workflow also resides there. It’s better to keep them separate so that you can update your KNIME without risking deleting your workflows.
On another note, I’d like to take the opportunity to suggest to KNIME Developers to provide an overview of resources focusing on Batch Execution with KNIME as you’d already done with Text Mining as exemplified in the link above. It will certainly make things more organized!
Also, to add this as a topic under the KNIME Documentation here: https://docs.knime.com/ to make it more searchable-friendly
Thank you for this suggestion!
I have moved my workspace.
It still doesnt seem to work. In the FAQ and other examples the workflowDir has “/” in the path. But windows directory structure has “”. Should i put it as WorkflowDir=“C:\Knime_Workspace/Auto_testing”? or “C:\Knime_Workspace\Auto_testing”?
Where Auto_testing the name of my workflow.
Hi @badger101 ,
Thank you. This worked.
I created a silly workflow variable like test, integer, 1 and now it seems to work!
I dont know why my workflow would require that!
Between yours and @bruno29a I was able to get it to work.
Check my previous answer, that’s my command for workflows without a parameter initialization/override default. I do have variables inside some workflows, but it isn’t always the case that I need to override them via command line. Sometimes they could be calculated inside the workflow.
I still dont know what KNIME means when it says “variables”.
I would be having many variables in my nodes, I’ll try to learn all that in the tutorials…hopefully!
@badger101 Jus tto clarify, the variable specification i did was in the KNIME workspace by right clicking on my workflow and setting the variables there. I did not use the -workflow.variable switch in the command line.