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. "Start Time" and "End Time" of a view reflect the data the view contains.

    As someone who uses the UI to get a summary of what my views contain, I would like the view's "Start Time" and "End Time" to reflect the actual data contained within the view in the case that I "Update Data" in the view to be something outside of the original bounds.

    6 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. 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.

    5 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 →
  3. Have PostgreSQL as a output target for PII4BA

    We have customers which neither use Oracle or MSSQL as datawarehouse but have standardized heavily on PostgreSQL as Data Warehouse. We should support this as a target System for PII4BA.

    5 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. Select all the attributes in a row

    When I click on the "Select All" button in order to select all the attributes of a view, the child attributes are not automatically selected and it is needed to select them one by one.

    Could it be possible to implement a new version of this functionality in order to facilitate our work?

    5 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 →
  5. Support filtering Integrator time-enabled layers by boolean fields

    The customer is displaying grid sensors on their map. The grid sensor error attribute is a boolean, True or False. They would like to be able to filter on a time-enabled layer based on whether the sensors are in error or not.

    5 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 →
  6. Add support for OAuth2 authenication for the Hadoop target

    It would be good to support more types of authentication. The current release of Hadoops add OAuth2 support to WebHDFS. This helps PI Integrator for BA to integrate with enterprise data lakes utilizing single-signon systems.

    5 votes
    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 →
  7. Keeping AF structure consistent with the Map layer

    There is a new map feature created, while adding a new element based on the same element template in AF.

    However, while deleting one of the existing AF elements does not delete the map feature.

    Customer is monitoring oil wells. They are rebuilding the AF structure (using custom AF SDK script) once a day. They want to display only the active oil wells. The newly added oil wells are displayed alongside the updated ones and the removed ones (features) from the AF structure. They want to remove the map features for the non-existent elements (inactive wells).

    5 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 →
  8. Edit Value Mode

    Provide an opportunity to choose a month in the Edit Value Mode. File as an attachment.

    5 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. 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.

    4 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 →
  10. 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.

    4 votes
    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 →
  11. 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.

    4 votes
    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 →
  12. AF Audit Trail is incompatible with the Integrator for BA

    Refer to the details of ticket #881602.
    In short, the integrator leads to excessive amounts of Auti records. I see at least 50% of the Audit enties being related to the Integrator, when that is only used very lightly.

    1) it should be documented that these are effectively incompatible
    2) preferred there should be a way such that the Integrator does not cause any audit records for the internal housekeeping of the tool.

    4 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. Add Json format as output targets

    Add the possibility of adding a target as a json gile format

    4 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 →
  14. Enable searching time-enabled layers using Portal map search.

    Searching the time-enabled feature layer data items using portal map search doesn’t work. According to the Esri manual, Hosted feature layers with Query enabled should be searchable.

    Attached is an example of this behavior from case #875453

    4 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 →
  15. Option to disable Integrator REST Services Directory

    Allow Integrator administrators to disable the Integrator's REST API Services Directory as recommended by Esri for production systems. See https://enterprise.arcgis.com/en/server/latest/administer/linux/disabling-the-services-directory.htm

    4 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 →
  16. Support Amazon S3 Bucket as a file endpoint

    Add the ability to define an Amazon S3 Bucket as an endpoint for text files. Some external vendors are using this as a preferred method for data ingress. The only way I could find to do this today is using a powershell script we've published on PI Square.

    4 votes
    Sign in
    Signed in as (Sign out)

    We’ll send you updates on this idea

  17. Allow English PI Time to be used regardless of integrator language settings

    Other products (such as DataLink) will allow for English PI Time to be utilized regardless of the language settings. For instance, both "*-8h" and "*-8horas" will work in DataLink if Spanish is the selected language. However, only "*-8horas" will work if Spanish is the selected language for the integrator in the UI.

    The request is to bring the integrator more inline with how other OSIsoft products handle PI Time in different languages.

    4 votes
    Sign in
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  General  ·  Flag idea as inappropriate…  ·  Admin →
  18. Add option to limit time period for 'Last Recorded Value' Data Context

    For data such as daily volumes produced, we need exact values from PI and Interpolated data just doesn't fit in this case. So we need to configure such columns with 'Last Recorded Value' Data Context. With this setting we certainly get the last archived data from PI, however we do not know if the data is stale.
    It would be great to have an option to limit time period for 'Last Recorded Value' data context.
    Example: Replace stale data with NULL if data is older than a month/year.

    4 votes
    Sign in
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  PI Integrator for SAP HANA  ·  Flag idea as inappropriate…  ·  Admin →
  19. BI Integrator preserve Column Configuration on Filter Change

    When you copy a BI Integrator Job ans change some settings in the Filter all attributes are added to the column view.

    We remove Attributes that are not needed e.g. Level1 Attributes when we only Need the Level2 Child Attributes. On a change the Level1 Attributes are always added.

    We rename Attributed and change the export settings e.g. Aggregstion or UOM. On a filter change the original Attributes are added again.

    We would prefer an option/setting in PI BI that no column is added to the column view and you can select them by the Add Column function.

    4 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 →
  20. Remove the need for PI ODBC for "PI Views"

    Using the integrator for BA - BI edition, you need to use the PI ODBC driver to read the data from PI views. That is a lot of hassle, given the fact that in most clients it is way easier to read from SQLserver where the data is in the first place. With the only exception that the tablename is the GUID instead of the view name.

    I created some scripting to create views based on the data in SQL and the data in the Integrator DB just to read the data directly from SQL.

    I think this limitation makes…

    4 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 →
  • 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