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. Allow csv file rerun in PI Integrator for Business Analytics

    Allow PI Integrator for Business Analytics to rerun a view that outputs to a csv file. Currently the "Update Data" button is grayed out.

    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 →
  10. 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 →
  11. Provide support for automatic updates for PI data in Event Views

    There are automatic updates for PI data in Asset Views and Streaming Views, but not currently in Event Views which is what's used for Event Frames. This is important for propagating changes in EFs

    Use case example: GADS classification. Data comes in and EFs are created. The integrator picks this up and sends the info along. Some time later (maybe a few days / maybe month end) data comes in re-classifying / updating the original data (ex. GADS code or attributes). In order to accommodate this manual intervention using the "Update Data" button is required.

    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. Allow PiView to be removed from Identities "Allowed Publish Target"

    This is very similar to the "Allow PI View Target to be disabled" suggestion below (I voted for that one as well). - I can understand if PiView needs to remain to simplify installation, but if I have a specific group of users that I want to just be able to publish to specific targets, I CAN"T currently remove "Pi View", and it always comes up 1st on the list of potential dropdowns.

    In this case, I don't want users publishing to PIView, rather I just one to give them a single choice, that is controlled at the Admin level.…

    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 →
  13. 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 →
  14. 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 →
  15. 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

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