Optimized Database Source block
The Optimized Database Source block reads field data from an Optimized Database. An Optimized Database is configured with a table containing all field information (i.e. field ID and name) while another table contains the actual tag data. The two tables are linked by a foreign key relationship.
Note that this connector may or may not be available on the user palette, according to your license type.
NOTE: This block has a discrete source version. For more information on configuring the discrete version of this block, click here >>
Optimized Database Source block
Description
During execution the value and quality for every tag for the given timestamp are read from the database. If an entry for the given tag and timestamp is not found the value is set to 0 and the quality is set to bad.
Optimized Database Source block
Block Type
Input/Output block
Input/Output ports
The Optimized Database Source has no input ports and one output port.
Functions performed on tags
-
On the values - The value will be set as read from the database.
-
On the timestamp - The timestamp will be set as read from the database
-
On the quality - The quality will be interpreted as follows: a value of 1 signifies good quality, while for any other value, the quality will be interpreted as bad.
Related topics: