Tabular Database Sink block
The online Tabular Sink block writes field data to a database table. A tabular database is configured with a single table containing all field data (i.e. value, timestamp and/or quality). The execution mode of this block, i.e. online mode or simulation mode is determined by the source.
Note that this connector may or may not be available on the user palette, according to your license type.
Tabular Database Sink block
Description
During execution (online or simulation mode) the value, and/or timestamp and/or quality for each field is written to the database table. An option can be set to only write the data when the value has changed or on each execute.
tabular sink block
Block Type
Input-Output block
Input-Output ports
The Tabular sink has one input port and no output ports. All fields in the input port must be of data type either double or integer.
Functions performed on tags
- On the values
- The value will be written as received at the input port to the database, unless the Save only Good quality data option is selected, so that only good quality values are written to the database. If any of the values to be written for double fields are positive infinity, negative infinity, or NaN (Not a Number), they are instead set to a value of 0.
- On the timestamp
- If the option is selected, the timestamp will be written to the database as received in the input port.
- On the quality
- Depending on the option selected, the quality attribute of a field can be written to the database, or the master quality of all the fields (if one bad quality sample exists in the input fields the master quality will be bad) can be written to the database. Alternately, the option can be set to write only the good quality values to the database. A value of 1 signifies good quality, while any other value is interpreted as bad quality. If any of the values to be written for double fields are positive infinity, negative infinity, or NaN (Not a Number), their quality is changed to Bad. This also affects the master quality, which is set to Bad, so that the row is not written to the database if the option to write only good quality rows was selected.
Related topics: