AnsweredAssumed Answered

Synchronization of PI Data into SQL

Question asked by dpilc on Dec 1, 2016
Latest reply on Dec 1, 2016 by rdavin


I am working on an application that requires synchronization of some subset of data collected on pipoints in PI Data Archive. The data is to be synchronized once a day. The challenge I am adressing now is how to detect which data should be synchronized. In basic scenario we just read the last non-yet-synchronized data set and load it into the sql, but we have to somehow handle situation when the historical data (like a couple of months old) is changed in PI data archive.

Do you have any suggestions what mechanism we should use to detect what hsitorical data changed and which tags/time periods have to be resynchronized?

I am thinking of calculating some simple "checksums" like count of events over longer period of time, but maybe there are better options...


thank you in advance