Web Data Entry

Suppose you want to use KNIME to enter some data into a database through a Web browser. I am not implying that it is the ideal tool for this, but it is quite possible with a Data App. Below is a picture of a basic workflow to achieve this.

For my example, I have a Products table in my database to which I want to add some data. The table has 3 columns : Product ID, Product Name and Product Price.

Below you can see the 'Input fields' component expanded. I have a Widget field for each column in my database table and each widget sets a Flow Variable

Now let's look at the Configuration dialog of the DB SQL Executor node in the 'main' workflow. It is just a parametrized SQL Insert statement, where the parameters are the flow variables coming from the Component. Note that the 2 first flow variables are between single quotes, because they are of String type.

Now all that is left to do is save this, upload it to a KNIME Hub and there deploy it as a Data App. When I execute this App I will get something like below.

I just have to fill out the fields and click the 'next' button to add a row to the Products table.