This tasks could be used to Insert data into a internal / external SQL Database.

To make use of this feature, you need to create a MySQL Provider in Provider Management. There you enter MySQL Server, Username and Password.

This Provider could be chosen in this block. (1)
You need to specify the database and table name you want to insert into. (2)
After you have done this, click the “load Structure” button. (3)

This click will load all columns from table and create a list you could fill with values.

1 – You could configure a value for every column or add additional columns, if you modify the table structure after initialization.

The checkbox “set on Update” is used together with next section.
2 – You could configure columns and values, which are checked before insert.
If a matched column is found, no Insert, but a Update is done with the columns you set to “set on Update”.