SQC Charts and Table Lookup Data

Discussion created by mikeloria on Sep 10, 2014
Latest reply on Sep 11, 2014 by Gregor

I have a business case where I have data values in an oracle database that I wish to display in an SQC chart or trend chart or XY chart. I want to avoid having to duplicate the values in PI(not writing and storing into PI tags). Can anyone think of how this could be accomplished without duplicating in a PI Tag? I was thinking I could have a linked table lookup query that retrieves the last 20 records(samples). Is it possible to utilize these records in this lookup table for SQC or trending or XY without writing t a PI tag. We wish to avoid data duplication so we maintain "one version of the truth" Thank you so much for your thoughts and considerations.