PI Integrators

Welcome to the PI Integrators feature suggestion box. We created this forum to hear your ideas, suggestions and feedback.

Please suggest your most important features and design change ideas on this site! Also vote for your favorite features now! We welcome your feedback.

  • NOTE: for documentation feedback and bugs, please report to Documentation@osisoft.com rather than entering 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. 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.

    2 votes
    Sign in
    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. Announce to user that current browser is unsupported

    This request applies to any OSIsoft product that requires a web browser: If certain browsers or browser versions are not supported by an OSIsoft product, the browser version should be detected and an error message shown to the user so they know to use a different browser or version.

    2 votes
    Sign in
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  General  ·  Flag idea as inappropriate…  ·  Admin →
  3. Have the option to preserve or change GUID during View import

    During View import process, have the option to preserve or change the View's GUID. This comes into play if multiple Integrators share the same SQL backend; there will be a GUID collision. Use case: split a large view among Integrators (for performance reasons) by using the Export/Import option.

    2 votes
    Sign in
    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. Integrator should have a status page

    The Integrator application server should have a status page ("OK" or "Running") so that clients or load balancers can easily determine whether the site is up or not.  This should be implemented when the Integrator eventually supports high availability.

    2 votes
    Sign in
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  General  ·  Flag idea as inappropriate…  ·  Admin →
  5. Represent the PI real time data in AWS Cloud

    We are planning to represent the PI real time data in AWS Cloud (in any suitable format) using some weblink or any other way.

    We trying to build a Dashboard kind of thing (using Dimensional modelling) to pull equipment data based on Several filter condition on AWS Cloud Solution.  I am not actually trying to put PI Server on AWS Cloud,

    Going forward we need the ability to display the AF data related to equipment.

    Will any PI Integrator help me to achieve my goals?

    2 votes
    Sign in
    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. Replace carriage return and other bad characters in attribute values

    We are using PI Integrator to write operator comments to a file target. The operator comments can include carriage returns which mess up the data written to file. Carriage returns and other bad characters should be replaced before writing to the target.

    2 votes
    Sign in
    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. Option to specify max file size

    When publishing to a file, the file can get extremely large. There should be an option in the file target to specify the maximum file size before rolling over to a new file.

    2 votes
    Sign in
    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. Allow to configure the format of the output file

    The actual version just allows to create a text file output. It would be nice to be able to manage the format of the columns in that target

    2 votes
    Sign in
    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. Option to split date and time into separate columns

    SAP recommends using compression on column store databases to conserve RAM and disk space resources (https://blogs.sap.com/2016/08/12/how-and-why-to-do-compression-of-column-store-tables-in-sap-hana/). Since date+time values are typically unique and compression in SAP HANA is column-based, compression of timeseries data like the data published by the Integrator is more effective if date and time are in separate columns as opposed to a single time column containing both date and time.

    2 votes
    Sign in
    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 →
  10. Be able to Write data to PI from Integrator Hosted Time Enabled Feature Services

    Native ArcGIS Feature Services allow for features to be updated by performing a POST to the REST endpoint to "Apply Updates".  It would be good to be able to record new values to the PI Data Archive by "Applying Edits" to the features / Elements made available for read access by the Integrator Hosted Time Enabled Feature Services.

    2 votes
    Sign in
    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 →
  11. Overlapping Time Ranges for Continuous View updates (Rolling Publications)

    I wish that the start time of a continuous view update cycle could precede the end time of the last cycle.

    For example every day query the last 30 days of data and replace rows that have already been written to the target table with the most recent data. This would be a straightforward way to ensure that data in PI and the integrator View are the same for the last 30 days. Manual corrections up to 30 days old could then be captured automatically.

    2 votes
    Sign in
    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 →
  12. Add the ability to Backup/Restore views

    As a system administrator, I need a mechanism to backup and restore system configurations. The ability to export and import all or selected views is something that would help us maintain our system.

    2 votes
    Sign in
    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 →
  13. 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
    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 →
  14. ESRI Integrator support for Element references

    Support for element references within PI Integrator for Esri ArcGIS.

    1 vote
    Sign in
    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 →
  15. 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
    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 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
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  General  ·  Flag idea as inappropriate…  ·  Admin →
  17. 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.

    1 vote
    Sign in
    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. Text file / ADLS Targets : Option to remove line number

    add an option to skip line numbers in the output files

    1 vote
    Sign in
    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 →
  19. 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
    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. 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
    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