SQL Database
The NETx BMS Platform uses an SQL database to store the following persistent data:
Trending values: if a trending for a data point is created, data changes are stored within the SQL database. The amount, time limit and frequency can be configured.
Alarm history: all alarm state changes are stored within the SQL database. This history can be shown within the Web Manager and exported via the reporting app.
LaMPS data: the NETx LaMPS module provides the possibility to trigger DALI tests (normal tests and emergency tests). All DALI tests and their results are stored within the SQL database.
Metering data: the project data of the metering module is also stored within the SQL database. This data is used by the reporting app to generate reports.
Within the current version of the NETx BMS Platform, the following SQL installations are supported:
Maria DB (version 10.3 or higher):
Default installation: 10.6 for 64-bit systems, 10.3 for 32-bit systems
No limit
MS SQL Server (version 2014 or higher):
Express edition: 10 GB limit for each database (workspace)
Standard edition or more: no limit
In principle, the SQL database and its contents can be used by third-party SQL clients. Therefore, it can be seen as an additional interface to access historical data. However, please keep in mind that changing the SQL database schema and its contents may harm the functionality of the NETx BMS Platform. Furthermore, the SQL database schema may change in future. This also means that no support is given for issues with third-party SQL clients.
Installation
SQL database interface is published as an extension called Database Interface. The extension will be automatically installed together with the NETx BMS Platform. If new functionality for the Database interface is available, you can update through the Extension Manager: in the Core Studio, run the menu item Extensions / Manager / Start Extension Manager.
Changelog
Version | Date | Notes |
---|---|---|
1.0.15 | Jul 30, 2024 | Fixes
|
1.0.14 | May 28, 2024 | Improvement
|
1.0.13 | Sep 21, 2023 | Fixes
|
1.0.12 | May 17, 2023 | Fixes
|
1.0.11 | Mar 29, 2023 | Improvements
Fixes
|
1.0.10 | Dec 15, 2022 | Improvements
Fixes
|
1.0.9 | Oct 13, 2022 | Improvements
|
1.0.8 | Aug 16, 2022 | Improvement
|
1.0.7 | Jun 2, 2022 | Improvement
|
1.0.6 | Mar 31, 2022 | Improvements
Fixes
|
1.0.5 | Nov 11, 2021 | New features
Fixes
|
1.0.4 | Jul 20, 2021 | Fixes
|
1.0.3 | Jun 14, 2021 | Fixes
|
1.0.2 | May 18, 2021 | New Features
Improvements
|
1.0.1 | May 14, 2021 | New features
|
1.0.0 | Dec 3, 2020 | New features
|
Article applies to the following products:
NETx BMS Platform