PI Developer Technologies

Welcome to the PI Developer Technologies feature suggestion box. 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, suggestions and feedback.

Please suggest your most important features and design change ideas on this site! Also vote for your favorite features now! We welcome your feedback.

  • NOTE: for documentation feedback and bugs, please report to Documentation@osisoft.com rather than entering them on this site.

How can we improve PI Developer Technologies for you?

(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. 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.

    4 votes
    Sign in
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  General  ·  Flag idea as inappropriate…  ·  Admin →
  2. 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
    Sign in
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI ODBC Driver  ·  Flag idea as inappropriate…  ·  Admin →
  3. 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.

    2 votes
    Sign in
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  4. 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
    Sign in
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  PI AF SDK  ·  Flag idea as inappropriate…  ·  Admin →
  5. 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
    Sign in
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI Web API  ·  Flag idea as inappropriate…  ·  Admin →
  6. 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
    Sign in
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI Web API  ·  Flag idea as inappropriate…  ·  Admin →
  7. Expose Values with Duplicate Timestamps in Transpose Function

    https://pisquare.osisoft.com/message/116957-pi-sql-commander-and-ssrs-how-to-retrieve-multiple-values-with-the-same-timstamp

    In the current implementation of the transpose archive in OLEDBEnt, a user is unable to retrieve data that may exist at the same timestamp as  another piece of data. This is because the time column is treated as the primary key of the transpose table. I would like to be able to retrieve all data using the archive transpose function regardless if timestamps are duplicated.

    5 votes
    Sign in
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  PI OLEDB Enterprise  ·  Flag idea as inappropriate…  ·  Admin →
  8. AF SDK Async Data Methods for multiple AFAttributes

    Expose interfaces for asynchronous data method calls (ex. InterpolatedValues, PlotValues, RecordedValues, Summaries) that:
        1. Take an asynchronous enumerable of `AFAttribute`s as input
        2. Output an asynchronous enumerable of results
        3. Throttle the calls made to PI Data Archive so that it does not overwhelm it

    The use case is to be able to make end-to-end asynchronous data method calls on a set of AFAttributes.

    6 votes
    Sign in
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI AF SDK  ·  Flag idea as inappropriate…  ·  Admin →
  9. Restrict Access to Web API Endpoint by User

    As a PI Web API administrator, I would like to natively restrict which users can and cannot see particular URLs and controllers on my PI Web API endpoint.

    5 votes
    Sign in
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  PI Web API  ·  Flag idea as inappropriate…  ·  Admin →
  10. Introduce a PI OPC UA Server

    The OPC landscape is shifting away from DA/HDA and towards UA servers. A significant number of OPC client tools are being created that connect to OPC UA servers, and none of these are compatible with PI without the use of a third party UA wrapper since we only provide DA and HDA servers.

    73 votes
    Sign in
    Signed in as (Sign out)

    We’ll send you updates on this idea

    18 comments  ·  OPC DA & HDA Servers  ·  Flag idea as inappropriate…  ·  Admin →

    We have been gathering use cases and information about OPC UA Server functionality as it pertains to OSIsoft products.

    There are a number of different requirements to consider, and as such we’re changing the status back to “UNDER REVIEW / RESEARCHING” to more accurately reflect the current status of the work.

    At this time, we are not committing to bringing this capability to market.

    We will update this thread if the status changes.

  11. Tag Creation

    As a developer of custom applications that use the PI  AF SDK, I'd like to be able to easily determine if an attribute based of an attribute template is configured for tag creation. Currently the AF Attribute Template class does not have this property. The current work around is to look at the configuration string which is less efficient.

    6 votes
    Sign in
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI AF SDK  ·  Flag idea as inappropriate…  ·  Admin →
  12. 1 vote
    Sign in
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  PI Web API  ·  Flag idea as inappropriate…  ·  Admin →
  13. Add Options for PI Web API Call Statistics

    Add auditing or a view of statistics for the calls or requests done by each individual application. Allow a PI Admin to see which user or application is making a specific call and see how long it takes to complete to monitor performance and potentially resource intensive Web API calls.

    28 votes
    Sign in
    Signed in as (Sign out)

    We’ll send you updates on this idea

    5 comments  ·  PI Web API  ·  Flag idea as inappropriate…  ·  Admin →
  14. OPC DA Server should periodically update its cache from the PI Server after the initial start

    The OPC DA Server service uses %PIPC%\PI_OPCDA2\Data\SavedNamespace.xml to load the tags and does not update the  cache until  the service is stopped and started again. If any new tag is added to the PI Server, it is not picked by the OPC DA Server. The service should periodically update its cache from the PI Server after the initial start.

    8 votes
    Sign in
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  PI OPC DA & HDA Servers  ·  Flag idea as inappropriate…  ·  Admin →
  15. Backfill/Recalculate over future data

    The ability to backfill an analysis using an end time in the future. This would read data from future inputs and write the results as future values.

    12 votes
    Sign in
    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  PI AF SDK  ·  Flag idea as inappropriate…  ·  Admin →
  16. 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.

    5 votes
    Sign in
    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.

  17. Support attribute types referencing AF Elements and Attributes

    We use attributes to reference elements and attributes extensively to model context and relationships in our AF models. Is this going to be supported in the future? Kind regards, Gregor

    5 votes
    Sign in
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    This item is under review. Currently considering the following behavior for attributes links:
    Current behavior:
    Error returned: “Unsupported data type: ‘OSIsoft.AF.Asset.AFAttribute’.”
    Similar error for AFElement.

    Change under consideration:
    Value link for Attributes of value type “Attribute” returns the referenced attribute’s GET response (“/attributes/[webid]”)
    Value link for Attributes of value type “Element” returns the referenced element’s GET response (“/elements/[webid]”)

  18. Add bulk delete methods in the Web API

    As a PI Web API user, I would like a simple method to perform bulk deletes of a particular attribute or PI tag. Currently, a bulk delete requires 2 calls. One to retrieve the event I wish to delete and another to delete it.

    9 votes
    Sign in
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI Web API  ·  Flag idea as inappropriate…  ·  Admin →
  19. PI OLEDB Enterprise access to AF Tables

    Allow PI OLEDB Enterprise access to AF Tables.  The current workaround is to have the table live on a SQL database and then link to them from AF.

    2 votes
    Sign in
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI OLEDB Enterprise  ·  Flag idea as inappropriate…  ·  Admin →
  20. 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.

    12 votes
    Sign in
    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.

← 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
NEEDS MORE DISCUSSION
RESEARCHING/EVALUATING
DECLINED
PLANNED
STARTED/IN DEVELOPMENT
IN BETA
COMPLETED