Optimized Database Sink block

The Optimized Database Sink block accumulates field data and generates a new database, or adds information to an existing database.  A 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.  The sink has the ability to create new field and field values tables. If fields do not already exist in the fields table, they will be created.  It is also possible to clear the tables of all field data before accumulating new data to the database.  

Note that this connector may or may not be available on the user palette, according to your license type.

Return to Overview of blocks

Optimized Database Sink block

Description

During execution all fields that do not exist in the database will be created.  The value and quality will be written to the database on every execution timestamp.  If an entry for the given timestamp and field does not exist in the destination table, a new entry will be created otherwise the existing value and quality will be updated.

If the destination tables do not exist, they will be created.

The block will delete the existing tables before creating new tables and populating these with data if this option is selected.

Optimized Database Sink BLOCK

Block Type

Input/Output block

Input/Output ports

The Optimized Database Sink has no output ports and one input port.

Functions performed on tags

This block performs no functions on the input data, it simply writes the data, for the configured tags, that it receives from the Blueprint to the database.  

Return to top


Related topics:

  

CSense 2023- Last updated: June 24,2025