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 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 →
  2. 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 →
  3. 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 →
  4. 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 →
  5. 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 →
  6. 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 →
  7. 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 →
  8. 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 →
  9. 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. 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 →
  11. 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 →
  12. 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 →
  13. Be able to access the UOM database as tables

    The current method of accessing UOM data is inconsistent with the rest of PI OLEDB Enterprise. Instead of tables, we have functions such as UOMAbbreviation and UOMClassName. Imagine if we had a function for each non-ID column of information that we wanted to access (e.g. ElementName, ElementTemplateDescription). It doesn't make sense. Please make the UOM database available as tables.

    This would also make it easier to manage and clean up the UOM database. For example, an administrator might want to make sure that compound units (e.g. m/s) are named consistently with their base units (e.g. Canadians might change "meter" to…

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

    We’ll send you updates on this idea

    1 comment  ·  PI OLEDB Enterprise  ·  Flag idea as inappropriate…  ·  Admin →
  14. support server side aggregation in AFSDK

    I would like to aggregate multiple tag values in a server side operation using naturally scheduled or sampled intervals in some form similar or extending FilteredSummaries.

    Most common case is finding the maximum aggregate of two or more tags.

    It's not practical to rely on Analysis for adhoc use cases.

    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 →
  15. Automatically update Transpose Function in SQL Commander when referenced Element Template name is updated

    In PI SQL Commander, users can create Transpose Functions that are linked to Element Templates in AF. When the referenced Element Template is renamed in PI System Explorer, the Transpose Function in PI SQL Commander is no longer able to find the Element Template which breaks the Function and underlying Data Table.

    Users are not aware that the Transpose Function or the underlying Transpose Data Table are broken until they attempt to query the Table or Transpose Function. It would be ideal if the Transpose function could either update this reference automatically or if the function referenced the GUID of…

    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 Enterprise  ·  Flag idea as inappropriate…  ·  Admin →
  16. Add Ability to Create Item Groups on the PI OPC DA Server

    As a PI OPC DA Server User, I would like to be able to create groups of tags (items) on the OPC Server, so that when I look for a specific tag in an OPC Client tool I don't have to search through the thousands of other tags that exist on my PI Server. This will make using the PI OPC DA Server more efficient and enjoyable.

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

    We’ll send you updates on this idea

    0 comments  ·  PI OPC DA & HDA Servers  ·  Flag idea as inappropriate…  ·  Admin →
  17. Custom forms with PI Web API using Infopath

    How to use infopath with web API the same way it was documented how to use infopath with web services.

    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 →
  18. AF Dependency Removal

    Can the PI Web API be configured to store its configuration information in a flat file or some other (non AF) mechanism?

    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. Permanently show descriptions underneath check boxes in PI SDK Utility → KST Cleanup

    In PI SDK Utility → KST Cleanup, there are 3 check boxes and 1 text box. When a check box is checked, the check box's label and description are added to the text box.

    Since there are only 3 check boxes, just eliminate the text box and have each check box description show underneath its corresponding check box. This would look a lot neater.

    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. Allow Direct PI Data Archive Server exposure

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

    0 votes
    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 →
  • 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