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. 1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  PI Web API  ·  Flag idea as inappropriate…  ·  Admin →
  2. Commit to combining PI Web API and PI AF SDK

    By my understanding, PI Web API is cross-platform but is slower than and lacks some of the features of PI AF SDK. Over time, PI Web API's speed and feature set approach those of PI AF SDK, making platform compatibility a progressively more significant difference where PI Web API wins out. The writing is on the wall but no one is saying anything.

    Please officially commit bringing the speed and features of PI AF SDK into PI Web API so that PI Web API is the only API that developers use, and then PI AF SDK can be deprecated. This…

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  PI Web API  ·  Flag idea as inappropriate…  ·  Admin →

    PI Web API is based on the AF SDK, so deprecating the AF SDK is not a viable option.

    That being said, what specific capabilities are you looking for to enhance the PI Web API?

  3. Let PI SQL Client access SQL Tables

    Let PI SQL Client access SQL Tables

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  PI SQL Client  ·  Flag idea as inappropriate…  ·  Admin →

    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

  4. Allow Direct PI Data Archive Server exposure

    Extend the capability of PI SQL Client to connect directly to PI Data Archive Server

    10 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  PI SQL Client  ·  Flag idea as inappropriate…  ·  Admin →

    We have reviewed this idea, and it’s not something we plan to implement at this time. Even though we are declining this idea for now, it is still open to comments. We do want to hear your opinion. Thank you for the feedback, and please, keep sharing!

  5. Return Event Frame Attribute Values with GetEventFrames Method

    Currently the GetEventFrames method returns only the properties of the event frame (start time, end time, extended properties, severity, ect.). In order to get a table including the event frame attributes, you need to get the event frame list first and then go through each event frame to get the related attribute values.
    It would be helpful if the GetEventFrames function returned a snapshot of the event frame's attribute values to improve the speed of custom applications.

    0 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI Web API  ·  Flag idea as inappropriate…  ·  Admin →
  6. Allow conditions in Batch Controller

    I would like to be able to have conditionals in my requests to the batch controllers.
    Consider this use case : I want to create an element and its parent, but the parent may already exists.

    At the moment, I have to make 2 seperate calls: One to check if the parent exists. Then a use the appropriate batch requests to create only the child or create both the parent and child

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI Web API  ·  Flag idea as inappropriate…  ·  Admin →

    Apologies as I meant to set this item to declined with my previous update.

    Thank you for your valuable feedback. We have no plans to work on this feature in the near future, so I am setting the status to declined. I will update the status if we eventually schedule this work.

  7. PI SQL Commander usability suggestions

    To make things easier for the user, please consider doing the following:
    • Move the contents of View, Query, Tools, and Help from the menu bar into the toolbar. This will reduce the click count from 2 to 1, and the toolbar has more than enough room to accommodate some additional buttons, especially when the window is maximized.
    • Add the keyboard shortcuts to the tooltips of the buttons in the toolbar.
    • Label more of the toolbar buttons so that the user does not have to hover over each button to know what each button does.
    • Eliminate the…

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  8. Expose Business Integrator statistics via AF SDK

    It will be nice feature addition in AF SDK, usability and publications management will also increased.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI AF SDK  ·  Flag idea as inappropriate…  ·  Admin →
  9. Add element reference information to to RTQP tables.

    In OLEDB Enterprise, we could find element references by type.  Currently, this information is not exposed in RTQP.  It would be helpful to be able to identify which type of reference an element is using.  One use case is for PI Admin's to generate reports on element hierarchy to ensure the proper reference is being used by builders of the AF DB.  This is especially helpful in AF DBs where element references are used to build multiple "views" using the same elements and the reference type could be used in conjunction with the new IsPrimaryPath column for reporting.

    5 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI SQL Client  ·  Flag idea as inappropriate…  ·  Admin →

    While we appreciate the interest the community has for this suggestion, we have decided to decline this item in favor of other high priority work. Thank you for your feedback, and please continue sharing suggestions for how we can improve the PI Developer Technologies for you!

  10. Create PI Web API performance counters to monitor the crawl state of various databases

    As an PI administrator I need to monitor the health of the index files created by the PI Web API Crawler. In particular, if the last crawl date has not been updated recently or other errors show up. This is currently done by manually visiting the PI Web API database page. A performance counter that reports things like "the number of databases who have not been updated in 1 hour" or  "the number of databases in error" existed, we could store that info in tags and act on the crawler getting in a bad state in a proactive manner.

    15 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI Web API  ·  Flag idea as inappropriate…  ·  Admin →

    Because the most common client for this application, PI Vision, no longer uses the PI Web API Crawler as of the 2020 release, this idea is declined.

  11. Don't install SQL Commander Lite with OLEDB Drivers Automatically

    We did install the SQL Client software on our SQL server, but there was no option to exclude the SQL Commander Lite. So, we had to turn around and uninstall SQL Commander Lite. I'd just like to suggest for future install packages that there be an option to exclude SQL Commander Lite.

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI OLEDB Driver  ·  Flag idea as inappropriate…  ·  Admin →

    SQL Commander Lite is included so that customers can easily test the functionality of their installation. As the default tool for testing functionality and building queries, we will continue to ship SQL Commander Lite with PI OLEDB.

  12. Write annotations on archive data via PI Web API

    My client is interested in writing annotations to Stream (time series) data via the PI Web API. I know it's possible to pull this data via the ?associations=annotations query parameters but the write feature is missing.

    8 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI Web API  ·  Flag idea as inappropriate…  ·  Admin →

    We are declining this item as we don’t feel it’s the right fit with our overall product strategy. Thank you for your feedback, and please continue sharing your thoughts on how we can better serve you.

  13. Expose Event Frame Annotations in PI SQL DAS (RTQP Engine)

    I would like the ability to access event frame annotations using PI SQL Client, in the same way as in PI OLEDB Enterprise.

    31 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  PI SQL Client  ·  Flag idea as inappropriate…  ·  Admin →

    We have reviewed this idea, and it’s not something we plan to implement at this time. Even though we are declining this idea for now, it is still open to comments. We do want to hear your opinion. Thank you for the feedback, and please, keep sharing!

  14. Add Annotations support for RTQP Engine

    I would like the RTQP Engine to be able to read annotations.
    My use case is the following :
    I have user that enter manual values into PI along with these values the operator will specify the reason for this manual input.

    The comment is stored in an annotations, there is currently no way to retrieve this information.

    Retrieving a string would be sufficient for my needs.

    17 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →

    While we appreciate the interest the community has for this suggestion, we have decided to decline this item in favor of other high priority work. Thank you for your feedback, and please continue sharing suggestions for how we can improve the PI Developer Technologies for you!

  15. PI ODBC driver for linus

    There is a pi JDBC driver for linux, but not an ODBC driver. This means that tools built around ODBC do not fully exploit the tools functionality. For example, RStudio has great database navigation tools that require ODBC.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI ODBC Driver  ·  Flag idea as inappropriate…  ·  Admin →
  16. Missing Open API (Swagger) specification for the Search controller

    The swagger specs for the search controller are not available. This will be useful in the client libs for searching

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI Web API  ·  Flag idea as inappropriate…  ·  Admin →

    We have reviewed this idea, and it’s not something we plan to implement at this time. Even though we are declining this idea for now, it is still open to comments. We do want to hear your opinion. Thank you for the feedback, and please, keep sharing!

  17. Support DST Transition on Second Granularity in PI SDK

    A user tries to retrieve date with timestamp 03-Nov-2018 23:59:59 (1 second before Daylight Saving Time beginning) in PI SMT, but the returned event has a timestamp of 04-Nov-2018 00:59:59. This is because PISDK timezone design is such that it can only transition DST on minute granularity, and the Windows TZ info for Brazil says the transition is at 23:59:59 so PISDK truncates the seconds for the transition rule.

    4 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →

    While we appreciate the interest the community has for this suggestion, we have decided to decline this item in favor of other high priority work. Thank you for your feedback, and please continue sharing suggestions for how we can improve the PI Developer Technologies for you!

  18. Have Status of an analysis

    I would like to have status of analysis (Enabled, Disabled, Running, Error or Warning) via PI AF SDK with the attribute 'Status' or the method 'GetStatus'.
    In the library, we already have in AFStatus all the Status declared but not used.

    Thanks to that it will be possible to see all analysis in error and try to resolve analysis in error with AF SDK.
    Morever, We won't do backfilling on analysis in error and create other error, it will be clean to do backfilling on all analysis Enabled if we know which analysis are in error.

    Sorry for my english…

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  PI AF SDK  ·  Flag idea as inappropriate…  ·  Admin →
  19. Reset Attribute to Template method in PI Web API

    Synced to PI Square at https://pisquare.osisoft.com/ideas/29447

    As a developer using PI Web API, I would like to have a Reset an attribute to template method using the Web API so I can program with greater flexibility.

    I am attempting to create a .NET Core App and this limitation prevents us from using PI Web API exclusively in automated AF Builds

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI Web API  ·  Flag idea as inappropriate…  ·  Admin →

    Apologies as I meant to set this item to declined with my previous update.

    Thank you for your valuable feedback. We have no plans to work on this feature in the near future, so I am setting the status to declined. I will update the status if we eventually schedule this work.

  20. Add more date and time functions to PI SQL Client

    As a PI SQL Client OLEDB user, I would like to have the TIME(), DATE(), LOCALDATE() and TOLOCALDATE() functions available in order to construct datetimes for my queries.

    These functions were available in PI OLEDB Enterprise, but are not available in PI SQL Client OLEDB.

    14 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  General  ·  Flag idea as inappropriate…  ·  Admin →

    We have reviewed this idea, and it’s not something we plan to implement at this time. Even though we are declining this idea for now, it is still open to comments. We do want to hear your opinion. Thank you for the feedback, and please, keep sharing!

← Previous 1 3 4 5
  • 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
TELL US MORE
EVALUATING
PLANNED
IN DEVELOPMENT
COMPLETED
DECLINED