Name

Name of the history database.

DB name

Write name of the database for the current history. If you enter the simple name like hisstory for example you will connect to the SQLLite database. The SQLLite database file .db will be created in /DB/ folder. If you choose names beginning with jdbc:mysql: like jdbc:mysql://192.168.0.104:3306/test the application will connect to MySQL* database.if you choose names beginning with jdbc:sqlserver: like jdbc:sqlserver://192.168.1.17:1433;databaseName=test where test name of the database you want to connect. The application will connect to MSSQL* database. If you choose names beginning with jdbc:postgresql: like jdbc:postgresql://192.168.1.17:5432/test where test name of the database you want to connect. The application will connect to PostgreSQL* database.

Table name

Write table name of the database for the recipe.

Username

Username if needed for MySQL databases.

Password

Password if needed for MySQL database.

Storage type

Choose storage type - Time or Tag. If you chose Time every Save period values of tags included in Ingredients will be saved into history database. If you choose Tag values of tags will be saved when Tag's value become True(1).

Archive since

Select an archive period. The data collected before the archive period is stored in the archive database. The data collected for the selected period is stored in the main database. This improves performance when querying the underlying database.

Save Period(ms)

Time interval of saving Ingredients tag values into history database. This property used when you choose Time Storage type.

Tag

Choose Tag dependent on which value (when value become True(1)) Ingredients tag values will be saved in history database.

Ingredients

Click Collection to fill up ingredients of the history. After clicking Collection button you’ll see the following window:

Where:

1. Choose Tag you want to bind to the ingredient.

2. Enter Name of the ingredient.

3. Enter DB column name for the database.

4. Enter Unit of the DB ingredient.