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 System Access (PSA)
Categories PI SQL Client
Created by Guest
Created on Aug 23, 2022

RELATED IDEAS

Let PI SQL Client access SQL Tables

Let PI SQL Client access SQL Tables
  • ADMIN RESPONSE
    Aug 23, 2022
    PI SQL Client provides access to the PI System in a relational view. It is purely a tool for access OSIsoft resources, and there are no plans to allow access to external resources. That being said, we do support adding the PI System as a linked server inside SQL Server Management Studio, so that both SQL calls and PI OLEDB calls can be made in the same work space. More information is available here: https://customers.osisoft.com/s/knowledgearticle?knowledgeArticleUrl=KB01143
  • Attach files
  • Guest
    Reply
    |     Aug 23, 2022
    PI SQL tables that are created are PI resources. They are created inside pi and are used by PI. To be clear, I am talking about tables that are set up inside pi. I am not talking about external tables that PI links to. What you are telling us is that any information in PI Sql tables is not really usable except for the use case where you are using the PI Explorer. thats fine, but our recourse is to not use PI SQL tables. Instead, put those tables outside pi and then link them. Its not a big technical shift at all. Just one we have to be aware of. why not just have a name space Master.Element.SQLTables and let us do selects using the PI SQL client ? Maybe its technically challenging? Ive never written a sql parser so I dont kow . Thanks for the consideration.