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. Always produce output table on publication: if there is no data to export when an asset view is published, produce an empty output table

    I build asset views on a schedule with interpolated time points based on a PI Point. I also set these up before any data is added to the PI Point so on first publication there is no data to export. Currently the PI Integrator for Business Analytics does not produce an output table if there is no data to export so any downstream SQL queries will fail since the table does not exist. If the output table was always created on publication, and an empty table was created when there is no data to export, this problem would be fixed. …

    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 →
  2. Create ArcGIS Feature Services and Layers with More Descriptive Names

    Update the naming convention used to create ArcGIS feature services and layers to use names that more accurately reflect the services and layers stored on the Integrator side. Customer Issue: The current convention is to use numbers instead of the layer names which causes confusion when trying to locate published items in ArcGIS Online or Portal for ArcGIS.

    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 Esri ArcGIS  ·  Flag idea as inappropriate…  ·  Admin →
  3. Add a "Written" timestamp column when publishing a view to indicate when the data row was modified/written

    Have an extra column in the view that indicates when the data row is actually written to the target.
    The current timestamp column is the timestamp of the value itself, not when the data row is written.
    This will be especially useful for troubleshooting, or when PI Integrator is updating existing value in a target table (will give indication of which data row was recently updated).

    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. Improve performance on narrow table queries

    Improve performance of queries resulting in a narrow table. This can happen for queries with many Elements, each with a few Attributes, where bulk queries to the data source are not possible. A narrow table can also result when using * for the Attribute criteria, as each Attribute is then considered a separate match.

    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. Grant permissions only to configure targets

    As a PI Integrator Administrator I need to grant permissions to a group of users to configure targets since they are the administrators of the target systems (SQL Server, ADLS, etc.), but they don't need access to other administrator tasks like security management.

    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 →
  6. Display full path of the element in the column name

    When there are multiple attributes named the same for different elements, the full path is automatically done to avoid duplicated column names. Element without name duplication issue should also have the option to display the full path column name.

    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 →
  7. Enhance Scheduling Options

    Would like the ability to schedule publishing a view during specific times of the day, for example between 6 PM and 3 AM every day (to reduce network load)

    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. Make it easy to find updated security patches to OSISoft Products

    As a PI Administrator for a power company I am asked twice a month to verify that none of the products I support have had a security patch released.  Any such products in a NERC zone need to be patched within the next 12 days.

    It used to be fairly easy to look at updates to all PI Client tools to find released security patches.  So far I haven't been able to find out if any have been patched.  This would also include interfaces which are prone to being run in a NERC environment.

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

    We’ll send you updates on this idea

    1 comment  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  9. Allow to Manually execute a publish once view

    To execute a view with the same parameters, it is actually mandatory to edit the view to be able to execute it again.
    It would be nice to be able to force its execution using a right clic on it for example

    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. Display the total number of matches for a shape

    When applying a filter when building a shape, the Integrator displays a limited amount of matching elements which is fine.
    It would be useful do display the number of element matches as an additional info

    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. Validate any link entered in the endpoint section (Vision, Portal, GeoEvent)

    The PI Integrator should validate any link entered in the endpoint section (PI Vision, Portal, GeoEvent). It should warn the user of any certificate issues or port that are not opened.

    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 →
  12. ESRI Integrator support for Element references

    Support for element references within PI Integrator for Esri ArcGIS.

    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 →
  13. 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 →
  14. 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 →
  15. 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 →
  16. 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 →
  17. 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 →
  18. 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 →
  19. 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 →
  20. 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 →
  • 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