PI Integrators

Welcome to the PI Integrators feedback page!

We created this forum to hear your ideas, feature suggestions and feedback on PI Integrators. 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.

How can we improve PI Integrators?

(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. Show a note for the user in Preview Data that only the first 100 rows are shown

    At first I thought the Integrator only retrieved 100 rows of data.  It would be nice to know that the actual publication is not reflective of the preview and that the page is limited to the first 100 rows of results.

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

    We’ll send you updates on this idea

    1 comment  ·  PI Integrator for Business Analytics  ·  Flag idea as inappropriate…  ·  Admin →
  2. Save the original First Run Time field when modifying a view

    When modifying a view that has already ran successfully, the First Run Time is not preserved.  The last time I configured it, it was set to a future date at 1AM.  When I modify it again, the field is populated with '*'.  It would be nice to have the last configuration saved even if it's not valid, so that I have the context of what I last configured.

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

    We’ll send you updates on this idea

    0 comments  ·  PI Integrator for Business Analytics  ·  Flag idea as inappropriate…  ·  Admin →
  3. Customize text file target

    Ability to set the locales for each text file target individually.

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

    We’ll send you updates on this idea

  4. Allow the user to customize the decimal separator

    Currently, the only available decimal separator is the period (.). In some cases, the customer may want to use other decimal separators such as the comma (,). It would make sense for the decimal separator to follow the convention of the region and language selected in the UI, or have an option in the menu set it to something custom.

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

    We’ll send you updates on this idea

    0 comments  ·  General  ·  Flag idea as inappropriate…  ·  Admin →
  5. Support SAP HANA multitenant database

    We would like the Integrator to support connecting to SAP HANA multitenant databases. The SAP ODBC writer used for PI Integrator for SAP HANA assumes that <port> takes the form 3<instance number>15 as stated in the HANA v2.0 SPS00 documentation. Since this is not true for multitenant databases, PI Integrator for SAP HANA does not currently support multitenant databases.

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

    We’ll send you updates on this idea

    0 comments  ·  PI Integrator for SAP HANA  ·  Flag idea as inappropriate…  ·  Admin →
  6. Allow for default AF DB/Server to be reflected when building a new shape

    When a user starts making a new Shape in the Designer UI they are given a list of AF Servers/DBs to choose from.The list is currently in alphabetical order and the first item is selected. It would be great if there were some default could be reflected so the user can immediately start working on the shape.

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

    We’ll send you updates on this idea

    0 comments  ·  PI Integrator for Business Analytics  ·  Flag idea as inappropriate…  ·  Admin →
  7. UoM conversions should be optional

    Currently the integrator takes the Unit-of-Measure Class of the first element found that matches the asset shape, and uses that for all elements. This causes UoM conversion problems if other elements have units from a different class.

    I want the UoM conversion to be optional, as only at design time one can determine if the current set of elements, AND the future set of elements returned by the asset shape would support any UoM conversion or not.
    There are no technical means to ascertain the UoM class for future elements returned by the asset shape would match the current class.

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

    We’ll send you updates on this idea

    0 comments  ·  PI Integrator for Business Analytics  ·  Flag idea as inappropriate…  ·  Admin →
  8. Disable automatic matches in Modify View screen

    As a PI View creator with an AF Database with several thousands of elements, I need to disable automatic matches so the GUI would run faster, and when I have finished shaping my data I should be able to enable matches again.

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

    We’ll send you updates on this idea

    0 comments  ·  PI Integrator for Business Analytics  ·  Flag idea as inappropriate…  ·  Admin →
  9. Text file / ADLS Targets : Option to remove line number

    add an option to skip line numbers in the output files

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

    We’ll send you updates on this idea

    0 comments  ·  PI Integrator for Business Analytics  ·  Flag idea as inappropriate…  ·  Admin →
  10. Text file / ADLS Targets : Split output files based on elementname or date

    The output files can grow quite large.
    Suggestion :Split the files. Here is an example using AF element name and date :
    C:\Viewname\elementname\YYYY\elementname_YYYYMMDDHHssmm.csv

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

    We’ll send you updates on this idea

    0 comments  ·  PI Integrator for Business Analytics  ·  Flag idea as inappropriate…  ·  Admin →
  11. AzureSQL Target should not need access to the master database

    The AzureSQL Target should not need access to the master database

    Current version of PII4BA gives this error message:
    Ref the error message
    The server principal "sqluser" is not able to access the database
    "master" under the current security context.

    Microsoft's words:
    “Generally, non-administrator accounts do not need access to the master database”
    https://docs.microsoft.com/en-us/azure/sql-database/sql-database-manage-logins

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

    We’ll send you updates on this idea

    1 comment  ·  PI Integrator for Business Analytics  ·  Flag idea as inappropriate…  ·  Admin →
  12. Allow filtering and/or sorting in Integrator Admin page - Licensing tab

    As an Integrator administrator, I would like to be able to easily find specific Views in the Licensing tab of the admin page by filtering and/or sorting the table. Currently, when many Views have been created and deleted, it is hard to find specific Views or even find ones that have streams that can be recovered.

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

    We’ll send you updates on this idea

    1 comment  ·  PI Integrator for Business Analytics  ·  Flag idea as inappropriate…  ·  Admin →
  13. Two way communication / write back to PI

    Write back to PI from the Integrator for Machine Learning. Currently we are writing back to Excel from Azure Machine Learning Service but would like to do this with less integrations.

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

    We’ll send you updates on this idea

    0 comments  ·  General  ·  Flag idea as inappropriate…  ·  Admin →
  14. Allow default schema to be configurable

    Our Database Administrator would like the Integrator to publish using a different schema than dbo for SQL targets, so I would like this to be configurable in the Integrator. Currently it is not possible to change it from the default dbo.

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

    We’ll send you updates on this idea

    2 comments  ·  PI Integrator for Business Analytics  ·  Flag idea as inappropriate…  ·  Admin →
  15. Throttle Data Archive reads

    As an Integrator user, I do not want to overwhelm the PI Data Archive when the Integrator reads data, either for an initial view backfilling operation or when I have multiple views running in real-time. I would like the Integrator to throttle Data Archive reads so as to not overwhelm the Data Archive or give me insight when I am making an expensive Data Archive call with the Integrator.

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

    We’ll send you updates on this idea

    0 comments  ·  PI Integrator for Business Analytics  ·  Flag idea as inappropriate…  ·  Admin →
  16. Allow multiple directories in Azure Data Lake Target

    As an integrator for Business Analytics user I would like to be able to choose which directory in Azure data lake my view is published to so that is is easier to manage and analyse data once it is there.

    Currently this is only possible through setting up additional targets, which is cumbersome.

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

    We’ll send you updates on this idea

    0 comments  ·  PI Integrator for Business Analytics  ·  Flag idea as inappropriate…  ·  Admin →
  17. Support authentication to Apache Hive via Kerberos

    I would like to be able to publish data from the PI Integrator for Business Analytics to Apache Hive that is set up for only Kerberos authentication.

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

    We’ll send you updates on this idea

    0 comments  ·  PI Integrator for Business Analytics  ·  Flag idea as inappropriate…  ·  Admin →
  18. Implement Testing methodology for Microsoft Patches

    Implement Testing methodology for Microsoft Patches
    PI System owners need to ensure that their deployed systems both meet internal IT policies regarding recommended OS and other component recommended and critical patches, and that their PI applications are not adversely affected by these patches.

    Consider a testing methodology similar to what PI AF employs which is currently to automatically monthly test all critical and recommended patches against the currently released application version.

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

    We’ll send you updates on this idea

    0 comments  ·  General  ·  Flag idea as inappropriate…  ·  Admin →
  19. Provide more detailed error logging

    Error message logs sometimes are not detailed enough to properly troubleshoot. The customer would like to increase logging available in order to get more insight as to what is going on.

    One example - the PI Integrator for BA does not publish any message when there is a permissions/access issue to output data to a Kafka Topic.

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

    We’ll send you updates on this idea

    0 comments  ·  PI Integrator for Business Analytics  ·  Flag idea as inappropriate…  ·  Admin →
  20. Option to permanently delete views

    I often create test views and then delete them from the User Interface when they are no longer needed. The Licensing page in the User Interface and the configuration database, however, still show these deleted views, which can be confusing when we are trying to recover streams. It would be nice if there were a way to permanently delete a view from the Licensing page and backend configuration database when we are sure they are no longer needed.

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

    We’ll send you updates on this idea

    1 comment  ·  PI Integrator for Business Analytics  ·  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