Provide possibility to create stream metadata from table data

Today we are collecting data from our AspenTech IP21 Server thorugh the PI Adapter for OPC UA and the related AspenTech OPC UA Server. This works perfectly fine for analogue data but not for data which is providing us equipment status information as enumerated strings (0=On/1=Off etc.). This is just exposed as Int32 variable by the OPC UA Server but the enumeration strings are not exposed according to the OPC UA standards so that it is not being collected by PI Adapter for OPC UA natively. To get around that, we can use the PI Adapter for RDBMS and collect the data through AspenTech SQL+ as a workaround.

Challenge:

Our Tags contain a lot of information like a descriptor or a UoM but when reading the data from a data table, this information can't be carried over into the stream in AVEVA Data Hub. However, this information is important for end users to understand, what the stream data contains. Also to have some metadata attached to the stream would be helpful (e.g. the corresponding enumeration).

Workaround:

provide a script which would pull the metadata from Aspen SQL+ and write it to the corresponding streams using REST API

Solution:

provide the possibility to read from a table which contains all the related metadata and write it to the corresponding stream in order to provide all necessary information to the end user.