New to the PI system and AF but coming from the RDBMS world!
We are currently investigating the feasability to rewrite an old SQL-based system (where times series data resides in Oracle), to a system where times series data will reside in PI (customer is moving to PI).
Metadata and other data will reside in an RDBMS.
Currently I'm testing to insert/update/delete values in bulk or one by one AFListData.UpdateValues. I have figured out how to do that and it seems to work ok.
Now, I just wonder if there is a way to define a transaction scope enclosing the AFListData.UpdateValues statements?
The data will be uncompressed (mostly) lab values that must be possible to load in bulk but also be changeable from a user interface.
I have looked at the IAFTransactable interface but I'm not sure that's the way to go.
Is there any other way to preserve data integrity.
And how does the AFBufferOption affect data integrity?