3 of 3 people found this helpful
Sorry I don't have any external references for you, but in general I really do like your approach. I wrote some blogs about MES-PI integration:
And you are correct: As long as you stay within the ISA 95 and 88 frameworks, there isn't a problem for the migration. The logic for your additional user requirement to validate a metric will be in your client app and stored as an attribute\property. If it is AF or your Oracle database the underlying structures are just SQL tables that are being accessed\modified\updated by your client app.
If these are sensor/real time data you could also consider migrating them into the PI archive data and store the acknowledgments either in a separate tag or as an attribute.
1 of 1 people found this helpful
Hi Holger thanks for linking to those excellent blog posts you created!
I wanted to address the other part of the question which had to do with auditing changes through AF, so here is a few pieces of our documentation regarding the AF Audit Trail:
Thanks Taylor for sharing the information. I went quickly thru the links and got a feeling that this kind of audit trail is from static data like elements. My scenario is related more to PI values. In Oracle, we have a huge 'Readings' table that contains aggregates of hourly and daily readings for tags that serve our apps, when a user needs to modify the reading of a certain time-stamp, there is an app that allows him to overwrite the value and create a record in another table 'Reading_changes' where we store the old value, new value, time-stamp,username and reason of change. appreciate thoughts to implement this on PI without using RDBMS.
Hi Emad, so basically you guys already have your own auditing process running and storing data for this 'Reading_changes' table.
Are you familiar with Linked Tables in PI AF? Here is the start of our documentation on the topic: PI AF Server - Linked Tables
Linked Tables allow you to access data from sources external to the PI System, such as SQL or Oracle databases. Once linked, this data can then be referenced within AF