Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

AVEVA™ Production Management

Database2RuntimeData integration

  • Last UpdatedFeb 24, 2025
  • 1 minute read

The Database2RuntimeData integration effectively converts a database table into an historian. It enables you to define which column is the name of the tag, which column is its value, which is its quality, and which is the time the value was taken. This integration does not insert or update records in AVEVA™ Production Management. It pushes data into HDP streams on variables, so that expressions can be used on them, thus the ability to create a record.

Studio project hierarchy view showing the database integration items.

Note: All date times, timestamps, that are returned by queries in this integration must be local time on the server.

Database sample

The database table has an historical view of tags and their values. This screen shows a data sample.

Database sample table.

Integration variables

The integration variables can be considered the same as any other OPC-HDA variable, and they can be used in expressions.

TitleResults for “How to create a CRG?”Also Available in