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. Expose most of PI-SMT functionalities to AF-SDK

    I have to admit that I am surprised and disappointed not seeing any real good administration methods in the AF-SDK. Of course there is Powershell but what I would really want is a nice way of getting all the information I see in SMT and more within C#. There are so much valuable information we could gather and analyse. We could also automate tasks etc...

    1 vote
    Sign in Sign in with OSIsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

    0 comments  ·  PI AF SDK  ·  Flag idea as inappropriate…  ·  Admin →
  3. PI Web API OMF send to multiple PI Systems

    I would like to be able to setup the PI Web API OMF endpoint to point to multiple PI Systems, so that way it is easy to send from this single instance to different production systems or to our development and production environments concurrently

    1 vote
    Sign in Sign in with OSIsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI Web API  ·  Flag idea as inappropriate…  ·  Admin →
  4. "Create or Update Data Reference" through OSIsoft.Powershell

    It is already possible to create an instance of an existing AF Element Template by using the powershell cmdlet Add-AFElement with the -AFElementTemplate option. The element is then created in the AF tree, however if there are tag creation rules defined in the template, the tags are not created until you manually perform an "Create or Update Data Reference" using the PI System Explorer. It should be possible to trigger "Create or Update Data Reference" via Powershell as well, either by an additional option of the Add-AFElement cmdlet or by a separate cmdlet.

    1 vote
    Sign in Sign in with OSIsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  5. PI SQL Commander Lite 2018 R2, view edition impacted by limited number of characters

    When you alter a view with many attributes, there is a characters number limitation that prevents you from seeing the total content of the view, so basically you cannot edit it because it's kind of "corrupt".

    1 vote
    Sign in Sign in with OSIsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Bugs *PLEASE SEND TO TECH SUPPORT*  ·  Flag idea as inappropriate…  ·  Admin →
  6. PI SQL Client to make use of the RecordedValue method and Retrieval Modes for the GetValue transposed function

    When making use of the GetValue transposed function when creating a new Template specific Data Model, we can see that under the hood it makes us of the AF SDK call AFData.InterpolatedValue method to capture the data at a specified timestamp provided in the transposed function. This method does make use of any Retrieval Modes.

    It would be good for this GetValue transposed function to make use under the hood of the AF SDK call AFData.RecordedValue method instead since this method offers the possibility of using Retrieval Modes like "AtOrBefore" which is really useful to capture the last archived value…

    1 vote
    Sign in Sign in with OSIsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI SQL Client  ·  Flag idea as inappropriate…  ·  Admin →
  7. Be able to expose AF with PI OPC DA Server

    Today PI OPC DA can only expose tags from DA.
    To have the option to expose information from AF.
    Both the AF structure and attributes.

    We are using AF for everything so why not in PI OPC DA.

    1 vote
    Sign in Sign in with OSIsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  OPC DA & HDA Servers  ·  Flag idea as inappropriate…  ·  Admin →
  8. 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
    Sign in Sign in with OSIsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

    0 comments  ·  PI AF SDK  ·  Flag idea as inappropriate…  ·  Admin →
  10. allow search where name contains space to return determinant results

    querying for names which contains spaces is non-determinant. AFSDK has methods to search on name, but webapi OR's the search. For results sets which should contain one or few rows, this can result in thousands of wasted rows.

    PI Query syntax EBNF specifies quotedescapedchar, which includes Char, so space should be honored.

    1 vote
    Sign in Sign in with OSIsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI Web API  ·  Flag idea as inappropriate…  ·  Admin →
  11. PROBLEMA NA ATUALIZAÇÃO PI JDBC 2017-2018

    Problemas encontrados na atualização da versão 2017 para 2018.

    Quando a biblioteca de conexão tenta acessar tal funcionalidade ocorre a excessão "PreparedStatement#addBatch() is not implemented yet".

    Problema similar ocorre com o uso da opção setReadOnly que deixou de ser suportada na versão 2018 do driver. Quando
    o método abaixo é invocado uma excessão é lançada o que causa problemas na nossa implementação. Talvez uma solução
    seja adicionar uma mensagem de warning como a realizada no método setTransactionIsolation.

    public void setReadOnly(boolean readOnly) throws SQLException {
        throw new SQLFeatureNotSupportedException("setReadOnly() is not supported by PI JDBC Driver.");
    }

    public void setTransactionIsolation(int level)…

    1 vote
    Sign in Sign in with OSIsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI JDBC Driver  ·  Flag idea as inappropriate…  ·  Admin →
  12. 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 Sign in with OSIsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI ODBC Driver  ·  Flag idea as inappropriate…  ·  Admin →
  13. 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 Sign in with OSIsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

    1 comment  ·  PI AF SDK  ·  Flag idea as inappropriate…  ·  Admin →
  15. Option to verify PI Data Archive connection during PI SDK installation

    During PI SDK installation, there is currently no option to verify the connection to the PI Data Archive. This can lead to complications if, for example, PI Interface Configuration Utility (which includes PI SDK) is the first piece of PI software installed on the machine and an invalid PI Data Archive name has been entered during the installation. Because there is no verification in the installer, the PI SDK and anything that relies on the Known Servers table entry such as interface.bat files must be corrected post-installation.

    1 vote
    Sign in Sign in with OSIsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Installation  ·  Flag idea as inappropriate…  ·  Admin →
  16. 1 vote
    Sign in Sign in with OSIsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  PI Web API  ·  Flag idea as inappropriate…  ·  Admin →
  17. 1 vote
    Sign in Sign in with OSIsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI AF SDK  ·  Flag idea as inappropriate…  ·  Admin →
  18. Configurable message sizes for PI Channels

    See https://pisquare.osisoft.com/message/112944-is-there-a-way-to-limit-the-size-of-pi-channel-messages for the originating question.

    Clients connecting via PI Channels have limits on the size of messages they can receive, for security reasons.  It is possible for PI Channel message sizes to exceed these limits.  There should be a way to configure the max message size for PI Channels.

    1 vote
    Sign in Sign in with OSIsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI Web API  ·  Flag idea as inappropriate…  ·  Admin →
  19. Allow applying PI AF attribute categories via the PowerShell commandlets

    We need to be able to apply PI AF attribute categories via PowerShell! We can do this today via the AF SDK, by referencing it within PowerShell, but it's a pretty convoluted solution to move back and forth in between command-lets and direct AF SDK references!

    1 vote
    Sign in Sign in with OSIsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  20. Specify Negative Time Offsets in SQL Commander

    Customer would like to write a query to return a time column with a negative offset in the PI OLEDB Provider such as:

    SELECT time, (time - 1d) as datekey
    FROM piarchive]..[picomp2]
    WHERE tag='sinusoid'

    This query works

    SELECT time, (time + 1d) as datekey
    FROM piarchive]..[picomp2]
    WHERE tag='sinusoid'

    A similar query can be written using a linked server but requires the additional overhead of a sql server or ssms.

    SELECT time, DATEADD(day, -1, time) as datekey
    FROM [PI_DA].[piarchive]..[picomp2]
    WHERE tag='sinusoid'

    1 vote
    Sign in Sign in with OSIsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

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