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.
  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Create non-clustered index via the Integrator front end

    Our end users tend not to have SQL access. We would like to allow them to create clustered indexes to increase the performance of a SQL query on the target view.

    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 →
  2. 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 →
  3. 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 →
  4. 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 →
  5. 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 →
  6. 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 →
  7. 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 →
  8. 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 →
  9. add Output format

    When PI outputs multiple TAGS data to the SQL database, the output table needs only three fields (TAGS, time, 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 Integrator for Business Analytics  ·  Flag idea as inappropriate…  ·  Admin →
  10. Maintain column order when adding attributes to view

    When you add a new attribute to a view, that column is placed at the end of the table. The column should be added in the correct placement like it would be if that attribute was added when the view was first created.

    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. Add support for allowing the user to specify the file extension for ADLS

    Currently, it is not possible to set the file extension that is published to Azure Data Lake Store by the PI Integrator for Microsoft Azure. It is currently hardcoded to .txt format.

    The end user should have the option to choose which file format (txt /csv/etc) that is to be eventually published to ADLS.

    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. Aggregate data across event frames

    As a PI admin using the integrator with event frames for reporting, I would like the integrator to calculate summaries across event frames. For example, I'm interested in the average value of an attribute from the beginning of one phase to the end of the operation, where the phase and operation events are generated by a batch interface.

    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 →
  13. Limit historical data retrieval for new elements

    As a PI admin working with the integrator, I would like to be able to limit the amount of data returned for new elements added to existing views. This avoids the situation where a long-running view is unintentionally slowed when the integrator backfills data for the new element over the whole history of the view.

    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. Time shifting data to align with plant process flow and tank retention

    This concept would really apply to all integrators except Esri. 
    We are careful to interpolate data in evenly spaced samples for large matrix analytics.  What happens when some of the data is upstream and the rest of the data is downstream and a tank sits in the middle with a 2 hour retention?  The data will not align.  We need to take into account the asset time retention as the process flows from the beginning to the end.  This can easily be calculated by time shift analytics that would shift data on the inlet to match the data on the…

    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 →
  15. Make Attributes for PI Coresight Ad-hoc Trend Selectable

    Provide a mechanism to filter out attributes that are not wanted on the PI Coresight ad-hoc trend. Customer Issue: All of the layer's fields (attributes) are included on the ad-hoc trend by default. This makes for a crowded trend that often includes unnecessary attribute data.Ê

    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 Esri ArcGIS  ·  Flag idea as inappropriate…  ·  Admin →
  16. Widget Styling: PI Coresight Widgets and their Dialogs do not Uniformly Implement Operations Dashboard Customizable Styles

    Provide widgets to Operations Dashboard for ArcGIS that respect the skinning and style customization that a user wants. Customer Issue: Users want the PI Coresight widgets and their dialogs to respect customization through the dashboard's extensibility model in order to control the look and feel of their environment.

    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 Esri ArcGIS  ·  Flag idea as inappropriate…  ·  Admin →
  17. Support Altitude ('z') When Creating Layers

    Allow layer configuration to include an altitude (z) component of location. Customer Issue: Features with an altitude attribute in the PI System do not have that reflected through the Integrator to the ArcGIS Platform.

    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 Esri ArcGIS  ·  Flag idea as inappropriate…  ·  Admin →
  18. Localization

    Provide localized versions of the PI Integrator for Esri ArcGIS. Customer Issue: Users prefer to interact with the application in their native language so they can more fully understand it and be sure that it works with localized versions of other OSIsoft products.

    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 Esri ArcGIS  ·  Flag idea as inappropriate…  ·  Admin →
  19. Incorporate Manual GeoEvent Steps for Integrating with an Existing ArcGIS Feature Layer into Wizard

    Improve the Integrator's native support for appending PI System data to an existing ArcGIS feature layer rather than creating a new layer. Customer Issue: Appending PI System data to an existing ArcGIS feature layer with geometry necessitates several manual, time-consuming steps.

    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 Esri ArcGIS  ·  Flag idea as inappropriate…  ·  Admin →
  20. PI Integrator for SAP AIN

    Currently we can only use the SAP Integrator for HANA.

    An Integrator directly for SAP AIN would be helpful for predictive maintenance use cases.

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