Learn about output processing: updating an RDBMS with PI data

To write values from the PI Data Archive to RDBMS tables, you define output tags, which execute an SQL query or stored procedure containing INSERT, UPDATE or DELETE statements. Output tags can be scanned (Location4 is set to a scan class) or event-driven (SourceTag specifies a tag which, when changed, triggers execution of the query.) For an event-driven output tag, if the query succeeds, the output tag’s value is set to the value of its source tag. If the query fails, its value is set to the "Bad Output" digital state.

Note: When the output tag type is set to Float32, the SourceTag type cannot be set to Digital. These two tag types are not compatible and, if used, will cause the output tag to fail.

To insert a row to a table, create an output tag with an INSERT query that specifies the target table and a set of placeholders. The AVEVA Random Simulator interface, which is installed with the PI Server, is a useful source of test data.