Database Configuration
The AlarmGateway is only compatible with Microsoft SQL Server databases.
The AlarmGateway connects to the database configured in the "Alarm Gateway" tab using the System Platform service account. You must therefore configure the permissions in this database so that the service account has read access to the table containing the additional alarm information.
Do not create the table in the Galaxy database!
The table must contain all the columns configured in the AlarmGateway.
The table can also be replaced by a view. The operation remains the same.
All SQL Server data types are supported by the AlarmGateway. For display in alarm clients, values are displayed as strings (result of the ToString() function of the data type).
Example configuration:
The AlarmGateway accepts "NULL" values in columns. In this case, an empty string is displayed in the alarm clients.
The length of values is not limited.
Example of a value with 200 characters in the "Type" attribute:
Example of a DateTime value in the "Type" attribute:
