Configuring the HMI project

Enable/disable DB Connectors

Path: ProjectView> right-click Database Links> Enable

Note the icon change to indicates whether the function is enabled or disabled.

Configure a Database

Path: ProjectView> Config > double-click Database Links

To use an external database it is necessary to create a connection with the specific database by specifying the database access parameters. Later you can use the macros and the JavaScript APIs by referencing the database by the name given to the link.

 

Parameter Description
Name The name to use to reference the database defined in this row.
Type

The available supported databases are::

  • MYSQL
  • MariaDB
  • PostgreSQL
  • ODBC
  • SQL4Automation
Description A free text that will help you to recognize the database.
. . . The other parameters identify how the database is accessed and depend on the type of the selected database (Ref. "Database Configuration").

Status of database connection is available through system variable tags. See "Default variables"

Error status can be reset with actions. See "DBResetErrors"

Using the database

You can exchange data with the database through macros or through JavaScript API: