/
SQL Database

SQL Database

The NETx BMS Platform (not NETx MP Server) 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.

The following SQL installations are supported: Maria DB (version 10.3 or higher) or MS SQL Server (version 2014 or higher). The setup contains for BMS Platform contains Maria DB and can be installed while executing the setup.

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. We do not provide support if the database gets changed.

Installation

In version R2 (setup version 4.2.x), SQL database interface was published as an extension called Database Interface. The extension was automatically installed together with the NETx BMS Platform. If new functionality for the Database interface was available, you could update through the Extension Manager (Core Studio menu → Extensions → Manager -> Start Extension Manager).

Changelog

Version

Date

Notes

Version

Date

Notes

1.0.18

 

 

1.0.17

Jul 3, 2025

Fixes

  • Report "Metering Table" shows wrong values if they are compound – fixed.

1.0.16

Jan 7, 2025

Fixes

  • Custom trending aggregation for range "Weeks" does not show values - fixed.

  • Metering table report calculates wrong values - fixed.

1.0.15

Jul 30, 2024

Fixes

  • MariaDB 10.3 not working since last update – fixed.

  • Metering queries not working for MS SQL – fixed.

1.0.14

May 28, 2024

Improvement

  • Trending procedure performance improved.

  • SQL driver updated.

1.0.13

Sep 21, 2023

Fixes

  • Metering chart report: option “Label” is not considered – fixed.

1.0.12

May 17, 2023

Fixes

  • [Default] Metering Chart cannot be executed – fixed.

1.0.11

Mar 29, 2023

Improvements

  • Remove obsolete SQL procedures

  • Performance improvement for high number of data changes.

  • Performance improvement for sampling trending.

Fixes

  • get_aggregated_trending_value_bins procedure is slow on MariaDb – fixed.

1.0.10

Dec 15, 2022

Improvements

  • Improve error logging.

Fixes

  • Invalid trending values (NAN or infinite double values) result in continues error messages – fixed.

1.0.9

Oct 13, 2022

Improvements

  • Support for new functions of Reporting extension.

1.0.8

Aug 16, 2022

Improvement

  • Trending value timestamps are set to 0.0 seconds when using schedule at full hour option. Existing data is migrated in background.

1.0.7

Jun 2, 2022

Improvement

  • Reporting server: update to .NET 6

  • SQL stored procedures for LaMPS extended

1.0.6

Mar 31, 2022 

Improvements

  • Faster aggregation queries.

Fixes

  • Possible loss of access to Web Manager elements – fixed.

1.0.5

Nov 11, 2021 

New features

  • Support for new Trending Table Multi report.

Fixes

  • Report instances cannot be executed on non-English systems – fixed.

1.0.4

Jul 20, 2021 

Fixes

  • Auto purge not working if connection fails – fixed.

1.0.3

Jun 14, 2021 

Fixes

  • Trending plot query does not finish in time on MS SQL Server – fixed.

  • Auto-purge for MS SQL Server Express Edition not working – fixed.

1.0.2

May 18, 2021 

New Features

  • Support for UPS-powered DALI emergency lighting test results.

Improvements

  • Simplified view for latest test results.

1.0.1

May 14, 2021 

New features

  • Internal release

1.0.0

Dec 3, 2020 

New features

  • Database-related functions are now available as extension for easier deployment.

 

Article applies to the following products:

  • NETx BMS Platform