implement the option to choose between append or replace in the configuration
It would be nice to be able to choose between append or replace when configuring a new source in a PI system connector, to be able to choose how to copy the data in real time. Since right now by default it is like replace. In the RDBMS interfaces of the source we have several data with the same timestamp, and when copying that data the connector to the destination system only copies the last value, that is, it replaces it. We would like it to be possible to choose between append or replace data copy and that the data be copied even if they had the same timestamp, being real time or out of order.
Planning is underway to enhance PI System Connector to support global configuration for an append write behavior.
Are there any news on this topic? it would be great if it gets implemented soon. it will help to ensure required data quality. i suggest to make this configuration granular, so we are able to choose what tags should use append or replace mode.
Based on the user guide "PI System Connector provides a convenient and autonomous solution to constantly sync and move data from a source PI System to a destination PI System." We are experiencing data loss, therefore the source and the destination is not identical. This function should be implemented
It's important to get this soon as possible. Base Requirement to the System Connector is to have identical Data on source and destination Data Archive. This only works with append. at the moment it works with replace (in my opinion a bug - the feature might be replace).
Good idea. Please, implement that feature.
Good idea, our main interest is that archive data in the source and destination are identical. Right now the archives are not identical when there are multiple values having the same timestamp for a tag in the source system.
We are addressing the same problem so it would be nice to develop SheilaG's solution.