The following parameters are important for trending and metering data recording.
Name | Description | Scope | Unit | Default | Annotation |
---|---|---|---|---|---|
XDB.DatabaseType | Sets the database type (MS SQL or MySQL (Maria DB)). | MySQL, MSSQL | None | MySQL | |
XDB.UserID |
Username that is used to connect to the database. | String | None | sa | |
XDB.Password |
Password that is used to connect to the database. | String | None | netxnetx_123456 | ||
XDB.Hostname | The host name or IP address where the database is running. Use ".", "127.0.0.1", or "localhost" for connecting to the local machine. | String, IP-address | None | . | |
XDB.Database | Database name to use. If not set, the default database name "netx_ef_<workspace>" will be used. Following special characters are not allowed: |
|
, | String | None | <empty> | since 4.1.2010 | |
XDB.Port | Communication port of database. If not set, the port will not be provided in the connection string – otherwise, the specified port number will be used. | None, 1 – 65535 | None | None | |
XDB.Instance |
MS SQL Server only: Name of the used database instance. | String | None | NETX_SERVER_SQL | ||
XDB.UseDefaultInstance | If enabled, the server connects to the default i.e. unnamed database instance of the MS SQL Server. | ON, OFF | None | OFF | |
XDB.ConnectionTimeout | Connection timeout in seconds. | 0 – 30 | s | 15 | |
XDB.CommandTimeout | Command timeout in seconds. | 0 – 3600 | s | 60 | |
XDB.LongCommandTimeout | Command timeout in seconds for long running commands like selecting trending values, auto purge or report generation. | 0 – 7200 | s | 300 | |
XDB.AutoPurge |
MS SQL Server Express Edition only |
(10 GB max. database size): If the |
database is more than 9 GB filled then the oldest trending data is deleted until the database size dropped below 8 GB. | ON, OFF | None | OFF | ||
XDB.DeleteOldTrending | ON: The values of deleted trending definitions will be deleted from the database. OFF: The values of deleted trending definitions will be kept in the database, e.g. for future evaluation. | ON, OFF | None | ON | |
XDB.SkipMigration | BMS Platform |
R1 Build 2000 |
introduced a |
certain SQL database schema. |
Since that version, the Core Server |
migrates from the old schema (database name NETX4_) to the new |
one (NETX_). Enable this option to |
disable this migration. |
ON,OFF | None | OFF |
Article applies to the following products:
NETx BMS Platform