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. New target Azure Cosmos DB

    Implement new target Azure Cosmos DB - this is today not available and not on roadmap

    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 →
  2. Allow Arrow keys to navigate sequential message logs in the Web UI

    Allow Arrow keys to navigate sequential message logs in the Web UI

    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. Sort View Statistics tab

    As a user, I'd like to utilize the columns in Statistics tab more effectively by being able to sort on the column so that I can sort by duration, error count, etc.

    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 →

    Currently we don’t enable sort because each statistic such as “duration, error count, etc” is indexed on time. There is a time-series graph showing error count over the last X number of runs. And when there are anomalies, you can click into those runs to see more details. You can also easily click back out and see the trend for error count or duration. How would being able to sort add more or different value than what is currently available?

  4. Add support for "Limits" in PI System Explorer

    As a user of AF, we would like it to be the system of record for our data.  For some of our KPIs, we would like to leverage the Limits feature in PI System Explorer and have the ability to add those limits to the Integrator.  Then we can leverage the limits downstream when creating our dashboards to show if a KPI is below or above a limit.

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

    6 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 →
  8. "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 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. For timestamp columns, provide more timezones in addition to local and GMT

    The timestamp columns in Pi Integrator only have "local" and "GMT" options. If possible, it would be useful to add additional timezones which would return the timestamp converted to that timezone.

    5 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 →
  10. Support for "BoD" (beginning of day) in Start Time End Time

    As a user who creates daily reports with the Integrator, it would be great if setting the period had a function similar to AF's Analysis "BoD" which returns the beginning of a day regardless of time input so that it will avoid confusion and ease the dependency between the job running time and the selection period.  Currently if I want a job to get data from midnight to midnight at 1AM everyday, I have to use Start time -25h and End time -61m (to avoid 2 values of the daily interpolation).

    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 →
  11. Send a notification if a view fails to publish successfully

    As a user, I would like a notification or email when a view did not succeed so that I can take action to backfill or triage the situation.  Currently I can only use the Last Run Time and it takes a long time to verify when each view's expected run time matches with the actual Last Run Time.  The Integrator does show an error icon when a view fails, but if the next run of the view succeeds, the icon disappears and the user has no way of knowing unless the user checks the 3rd party destination.

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

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

    5 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 →
  14. 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 Audit records. I see at least 50% of the Audit entries 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.

    5 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 →
  15. Schedule to publish a view certain days of the week or month

    The possibility of publishing as view certain days of the week or month.

    For example publish the view
    - The first 15 days of the month.
    - Different days in a month: 1,5,11,22..
    - Every Monday, Wednesday and Friday

    This will allow to have the data right when needed being able to schedule properly analyzing tasks.

    5 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. 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 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 →
  17. 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. …

    5 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. Expose additional Kafka target configuration options

    To accommodate high frequency messages to Apache Kafka brokers, additional tuning of Kafka producers can be necessary to prevent high CPU and Disk I/O load. The PI Integrator should expose these parameters to allow users the ability to adjust their system as necessary. The following are common parameters that would allow for this:

    - Batch Size (batch.size)
    
    - Linger time (linger.msg)
    - Buffer memory (buffer.memory)
    - LZ4 compression

    Additionally, many projects may require that acknowledgements be sent back to the producer to confirm that they were properly received. The PI Integrator should provide the option as for whether or not…

    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 →
  19. After manually updating data, the next scheduled publish should ensure it does not publish duplicates

    As a PI Integrator user, if I use the manual "Update Data" option to correct a time period that includes data that will be published on the next scheduled publication run I do not want this next scheduled run to publish duplicate rows. For example, if I have an Event View that publishes on the hour every hour and the last run was at 1:00 PM, if I run update data at 1:25 PM specifying start time 1:00 PM to end time *, the next scheduled publish will look at the 1:00 PM to 2:00 PM time range and therefore…

    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 →
  20. Allow change of target configuration after publish

    Once a View has been published, you cannot change the Target--the dropdown is greyed out on the 'Publish' screen in the designer. You have to re-create the View to publish to a new target, which is a lot more work and opens up the potential for issues or misconfigurations. Use case: if I was publishing to a sandbox environment and now want to publish the View to production, I could change the existing View's target in the drop-down instead of re-creating it.

    Note: This is different from another, completed idea (https://feedback.osisoft.com/forums/555136-pi-integrators/suggestions/35776837-allow-target-configuration-changes-to-be-pushed-ou) as I don't want the configuration of…

    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 →
  • 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/PREVIEW
COMPLETED