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