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 Declined
Product AVEVA™ PI Server
Categories Data Archive
Created by Kenneth Barber
Created on Aug 20, 2022

RELATED IDEAS

Store PI Data Archive information in an SQL Server database

Most of the PI Data Archive information that is accessible from PI System Management tools is perfect for a relational database: PI Identities, PI Mappings, PI Point attributes, PI Message Logs, etc. Moving all of this to an SQL Server database would make it easier for the PI Data Archive to communicate with: • PI Asset Framework (which already uses SQL Server), • PI OLEDB Enterprise (currently responsible for translating SQL queries to native PI requests), • PI Builder (translates the PI file format to a relational database format anyways), and, most importantly, • the user (users know relational databases, but they do not currently know how the PI Data Archive stores its information, so they are stuck with PI System Management Tools and its limitations) The use of an SQL Server database can lead to a simpler, more transparent, more flexible PI Data Archive. There would be less "translation" code for OSIsoft to maintain and the user can write queries to the PI Data Archive more easily.
  • ADMIN RESPONSE
    Aug 20, 2022
    Our data access tools purposefully obfuscate the underlying database implementation so that we can make changes without users having to make any changes to their custom code. If users build custom code using, for example, the AF SDK, then if we have to change the underlying database implementation, we will make sure the AF SDK supports the change. In this way, we can preserve backwards compatibility.
  • Attach files
  • Kenneth Barber
    Reply
    |     Aug 20, 2022
    If users can query the PI Data Archive more easily, then that makes the PI Data Archive more extensible. Also, replace "PI OLEDB Enterprise" with "PI SQL Client".