Before you can create a DataBase data source, a database connection must first be created.
You can find out how to create database connections in the following article: Creating database connections
The data source input screen opens, in which you can select the DataBase data source as “Type” as the first step.
However, if you first assign a name to the data source and it contains the word “database“, “DataBase” is already preselected as the data source type. (This works with all data source types)
Once this has been done, the data source-specific settings of the DataBase data source are automatically adjusted.
DataBase Specific
- Connection
Select the previously created database connection here.
After entering the relevant information for the connection, click on “Add” or on “Save” after editing an already created data source.
The DataBase data source is created and subsequently displayed in the data source overview.
Created data sources can be edited or deleted again. You can do this using the corresponding buttons.
You also have the option of displaying all internal data sources. This works by activating the “Show internal data sources” checkbox.
You can find out how to add variables for the DataBase data source in the article “Adding DataBase variables“.
You can find out how to carry out external logging for the DataBase data source in the article “External logging in the database“.
For what purposes can I use the DataBase data source?
You can store externally provided values in your database. QuickHMI then uses this data to visualize the desired values.
For example, you have statistical values for your company that you want to display on your QuickHMI visualization, but which are only available as database data.
All you need for this purpose is a“QHMI_VARIABLES” table and the right to access it. You transfer the desired values to the table as required and link them to your project in the QuickHMI Editor.
What do I need to operate a DataBase data source?
To operate the QuickHMI database data source, you need a customer-supplied and administered database.
The database must be accessible by the QuickHMI processes via TCP/IP and communication must not be interrupted by firewalls or similar.
The network connection between QuickHMI system and database should be realized with a speed of 100Mbit/s.
QuickHMI does not provide a database server or database licenses, but offers the connection of an existing database. The necessary database and / or access licenses must be available to the user / customer.
How should I prepare the database?
Before use, you must provide the QuickHMI system with a set of database objects.
The following database objects must exist and be valid:
- Table QHMI_VARIABLES
- Column NAME VARCHAR(200)
- Column VAR_VALUE VARCHAR(250)
The database connection parameterized in the project requires update rights within the created table. If these rights are not available, malfunctions may occur with regard to the database data source.
Make settings
Create a database connection in your QuickHMI project by clicking on 
“Connections” under “Database” in the Project Explorer.
You can find out how to create a new database connection in the following chapter: Creating database connections.
Fill the QHMI_VARIABLES table with your values.
Example:
Create a suitable data source in the QuickHMI Editor by clicking on 
“Data source” in the Project Explorer under Communication.
You can now create variables for this data source that correspond to your values. You can find more information in the article Adding DataBase data source variables.
Example:
You can now link the variables to elements in your project and the values are displayed and/or set.
