A unique text string used to identify this connection. This label is used to identify the connection when configuring store and forward, and to create the database name or retention policy in some historians. The label can contain only letters, numbers and the underscore ( _ ) character.

The Data Source Name associated with the database.

The user name for the database.

The password associated with the User name.

The number of milliseconds that the DataHub instance will buffer data in memory before sending it to the database. Setting this value to zero means that no accumulation time will be enforced.

If both this value and Maximum # of buffered values (below) are specified, then the DataHub instance will write all buffered values to Kinesis whenever the first of these two limits is reached.

The maximum number of values that the DataHub instance will buffer in memory before transmitting them to the database. Setting this value to zero means that all values will be sent as soon as possible.

Prevents the DataHub instance from writing to the database.

Checking this option causes messages regarding successful writes to the database to be logged at the Information level in the DataHub Event Log. If this is not checked then these messages are logged at the Debug level and are therefore normally hidden from the user.

The database table name. You may need to surround the name in quotes or brackets if the database server requires it. You can do that either here or in the insert and query scripts.

The name of the column that holds the point name. This column should be a VARCHAR or other string type that is long enough to hold the longest point name.

The name of the column that holds the point value. This column is typically a high-resolution numeric type, but can be any string or numeric type.

The name of the column that holds the numeric point quality. Point qualities are 16-bit integers.

The name of the column that holds the timestamp for a point value. This column should be a type that can store timestamps to at least millisecond precision.

The index column is optional when using the database as a source for OPC UA or WebView historical data, but is necessary for store-and-forward. Store-and-forward requires a way to identify which values from the table have been transmitted, and which have not. This is done by remembering the index of the last successfully transmitted row.

Ideally, the index is a monotonically increasing integer that is automatically incremented whenever a new row is inserted into the table. When it is not possible to use an integer row index, the timestamp can be used. Using a timestamp as an index is imperfect. It is possible to miss rows if they are inserted out of time order relative to previously inserted rows. A 64-bit auto-incrementing integer is the best choice for an index column.

Must return the name, value, quality and timestamp for a specified point within a given start and end time. The result set must include any values whose timestamp exactly matches the start or end time. Special variables startdate, enddate and pointname are provided to the query script.

Must return the name, value, quality and timestamp of the row with the earliest timestamp for the specified point. Special variable pointname, is provided to the query script.

Must return the name, value, quality and timestamp of the row with the latest timestamp for the specified point. Special variable pointname, is provided to the query script.

Must return the unique set of names of all data points for which at least one value appears in the table.

Returns a single value containing the number of rows matching a specified point name within a given time range, inclusive of the start and end time. Special variables startdate, enddate and pointname are provided to the query script.

Returns the name, value, quality and timestamp from the row whose timestamp is less than or equal to the specified time, for the specified point name. Special variables startdate and pointname are provided to the query script.

Returns the name, value, quality and timestamp from the row whose timestamp is greater than the specified time, for the specified point name. Special variables startdate and pointname are provided to the query script.

The query used by store-and-forward. If you are not using this database as a source for store-and-forward, you do not need to provide this query. If you provide this, it must produce all rows in the table whose index value is greater than or equal to the value of the variable start, in index order, up to a maximum row count of limit. Special variables start and limit are provided to the query script. This script does not depend on a particular point name. It returns rows in index order across all point names.