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 | If the integrated security mechanism is not used, the specified user will be used to connect to the database. | String | None | sa | |
| XDB.Password | If the integrated security mechanism is not used, the specified password will be 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 | (MSSQL only) Instance name of the used database. | String | None | NETX_SERVER_SQL | |
| XDB.ConnectionTimeout | Connection timeout | 0 – 30 | s | 15 | |
| XDB.CommandTimeout | Command timeout | 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 | (MSSQL with SQL Server Express Edition only, 10 GB max. database size) If the cyclic check finds 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 version < R1 Build 2000 was using a different SQL schema. Therefore the Core Server tries to start a migration from the old schema to the new. This migration process can be deactivated by setting this option to OFF. | ON,OFF | None | OFF |
Article applies to the following products:
- NETx BMS Platform