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 Completed
Product PI Integrators
Categories AVEVA™ PI Integrator for Business Analytics
Created by Guest
Created on Aug 16, 2022

RELATED IDEAS

Make "PI Views" easier for BI access or support SQL in the BI edition

Using the integrator for BA - BI edition, you need to use the PI ODBC driver to read the data from PI views. That is a lot of hassle, given the fact that in most clients it is way easier to read from SQLserver where the data is in the first place. With the only exception that the tablename is the GUID instead of the view name. I created some scripting to create views based on the data in SQL and the data in the Integrator DB just to read the data directly from SQL. I think this limitation makes no sense. Even the BI version should be able to write to SQL tables.
  • ADMIN RESPONSE
    Aug 16, 2022
    Since the original reason the idea was created has been resolved with the 2018 releases of PI Integrator for Business Analytics, this idea will be marked as complete.
  • Attach files
  • Guest
    Reply
    |     Aug 16, 2022
    This is long overdue, but hopefully everyone got the news that we have merged BI and DW editions into a new Standard Edition of PI Integrator for Business Analytics. All BI Edition customers can now write to SQL directly. However, this doesn't address the original idea, which is to remove PI ODBC for PI Views. Are PI Views still useful for your use cases?
  • Guest
    Reply
    |     Aug 16, 2022
    With the removal of the difference between the BI and DW editions this resolves the reason why i created this item. The title is slightly confusing though, of course if one wishes to use PI Views, PI ODBC is still needed.