PI Developer Technologies

Welcome to the PI Developer Technologies feedback page!  

This forum covers the PI AF SDK, PI Web API, PI OPC DA and HDA Servers, and the PI SQL family. We created this forum to hear your ideas, feature suggestions and feedback. Please suggest your most important features and design change ideas on this site, and vote for your favorite ideas.

Please note that your ideas and comments posted here are visible to all other users.

  • For bugs, please open a case with OSIsoft Tech Support through myOSIsoft Customer Portal  (https://my.osisoft.com) instead of sharing them on this site.
  • For documentation feedback and bugs, please report to documentation@osisoft.com instead of sharing them on this site.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Add DATEADD and DATEDIFF functions to PI SQL Commander

    When any time related functions need to be performed against timestamp columns in PI SQL Commander, one needs to utilize a significant amount of conversions to make this work. For example, if one needs to round timestamps to the nearest minute or the nearest hour, a CASE statement with multiple CASTs needs to be done to get this to work.

    If T-SQL DATEADD and DATEDIFF commands were implemented, this would simplify the query by a significant amount. Similarly, in PL/SQL, the ROUND function is able to round the datetime value directly, which would fit perfectly to this scenario.

    16 votes
    Sign in Sign in with OSIsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI OLEDB Enterprise  ·  Flag idea as inappropriate…  ·  Admin →
    PLANNED  ·  Ray Verhoeff responded

    We are planning to add several functions that are equivalent to T-SQL functions. This will make it easier for the PI SQL products to integrate with the Linked Server in Microsoft SQL Server.

  2. Allow PIOLEDB Enterprise to connect directly to a PI Data Archive

    If PI OLEDB Provider is not going to be further developed, allow PI OLEDB Enterprise to connect directly to a PI Data Archive.
    There are times when an SQL type query is needed, but the data structure has not been mapped to an AF server yet.

    7 votes
    Sign in Sign in with OSIsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    5 comments  ·  PI OLEDB Enterprise  ·  Flag idea as inappropriate…  ·  Admin →
    PLANNED  ·  Ray Verhoeff responded

    We have a new SQL query processing engine under construction. We call it the Real-Time Query Processing Engine, or RTQP Engine. We are targeting improved performance and scalability but we are also improving some of the table designs to make common queries a bit easier. We have talked to many customers about their use cases. It turns out that direct access to PI Data Archive tags is still very important. We also found several hybrid use cases such a summarizing values from a PI tag over the period of an Event Frame, and Kenneth Barber’s excellent example of aligning AF Attributes with PI Point attributes. So, we will be adding direct access to PI tags and data but not in the first release.

  • Don't see your idea?

Feedback and Knowledge Base

Posted ideas will have one of the following statuses.
Full definition of these statuses can be found on the Home Page.
No status
NEEDS MORE DISCUSSION
RESEARCHING/EVALUATING
DECLINED
PLANNED
STARTED/IN DEVELOPMENT
IN BETA
COMPLETED