AVEVA™ PI System™ Feedback Portal

Welcome to our feedback site!


We created this site to hear your enhancement ideas, suggestions and feedback about AVEVA products and services. All of the feedback you share here is monitored and reviewed by the AVEVA product managers.

To start, take a look at the ideas in the list below and VOTE for your favorite ideas submitted by other users. POST your own idea if it hasn’t been suggested yet. Include COMMENTS and share relevant business case details that will help our product team get more information on the suggestion. Please note that your ideas and comments are visible to all other users.


This page is for feedback specifically for AVEVA PI System. For links to our other feedback portals, please see the tab RESOURCES below.

Add a new idea Subscribe
Status Tell us more
Product AVEVA™ Adapters
Categories AVEVA Adapter for RDBMS
Created by Ee Sheing Lee
Created on Jul 25, 2023

RELATED IDEAS

Adapter for RDBMS to support multiple rows with same "Timestamp" colum as IndexColumn

As of version 1.x, with the IndexColumn being specified in the dataselection, the Adapter will require that each row in the source Database to have its own unique timestamp. If there are multiple rows with the same timestamp, first value with the timestamp will be processed but subsequent values would be skipped.

Removing IndexColumn, and let the Adapter timestamp the data, Adapter will be able to process all the rows retrieved. However, this is not an ideal workaround as the data's timestamp will not be as per the source Database.

Interface is able to process these rows and send to PI Data Archive depending on the configuration set (for example, append/replace/do nothing if value is the same).

This enhancement request is such that the Adapter is able to process multiple rows with same the timestamp and send the data.

  • Attach files
  • Admin
    Ellery Murdock
    Reply
    |     Nov 7, 2023

    Would it be possible to add additional context to this enhancement request?

    My current understanding is that you would like multiple rows to be associated with a singular timestamp. Are these multiple rows associated with different data streams, or the same data stream?


    Would you be able to provide a brief example of the data you're trying to ingress?