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. 19 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  PI Integrator for Business Analytics  ·  Flag idea as inappropriate…  ·  Admin →
  2. Specify desired logging level

    As a PII4BA administrator I would like to specify a logging level so I can filter which logs I want to store and which ones I don't want to store in the database.

    19 votes

    We're glad you're here

    Please sign in to leave feedback

    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 →
    TELL US MORE  ·  Joy Wang responded

    Is this an issue of limited SQL storage? We have a log retention policy that can be configured by the user in the CAST.UI.WindowsService.exe CONFIG file today. By default it only retains a maximum of 2 months of data AND no more than 100k rows AND no more than 1000MB of disk space. Similar retention policies can be created for the PIIntegratorStats database as well.

    Let me know if this would satisfy the requirement. Or provide more information on how specifying the logging level would help. If you could, which logging levels would you keep vs. throw away and why?

  3. Allow attribute annotations to be published with the Integrator

    I want to publish the attribute annotation for a time series event using the Integrator. For example, if a user enters data in PI Manual Logger, they enter comments as annotations to the tag event. I would like to publish those annotations along with the attribute event's timestamp and value.

    18 votes

    We're glad you're here

    Please sign in to leave feedback

    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 →
  4. Allow PI Integrator to create a new file per publication in Amazon S3

    As a PI Integrator user, I'd like PI Integrator to create a new file per publication in Amazon S3. Currently there is a workaround with Maximum Rows/Objects option in target configuration, but it is not straightforward and cumbersome.

    17 votes

    We're glad you're here

    Please sign in to leave feedback

    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 →
  5. Support different TimesStamp formats when Modifying Views

    Currently it is not possible to change the TimeStamp format from MM/dd/yyyy 12h AM/PM to other formats. Since there are many potential different data endpoints, it may be a good idea to allow users to change to other formats, such as 24h Military time.

    15 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  PI Integrator for Business Analytics  ·  Flag idea as inappropriate…  ·  Admin →
  6. Add AMQP message queuing (like RabbitMQ) as a target to the PI Integrator for BA

    As a BigData analyst, I need to be able to add PI information to a global AMQP message queuing middleware, RabbitMQ being one example amongst others. From this message queue other consumers will have access to PI information along with message queues from other sources for offline or streaming analysis.

    14 votes

    We're glad you're here

    Please sign in to leave feedback

    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. Ability to Create View Templates

    For a large implementation of the Integrator, the ability to create View Templates would be very helpful. While the ability to create a View based on an existing View and the ability to export/import Views are both steps in the right direction, I'd like a View template to be source agnostic with regard to the Asset Shape. For example, I want to configure a metadata view that will have PI Points, uoms, paths, categories, descriptions, etc. for each Attribute I'm publishing in another View. We're talking hundreds of columns as a result. If I try to import this View, then…

    13 votes

    We're glad you're here

    Please sign in to leave feedback

    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 selection of US region for languages other than English

    Users should have the option to select the US as their region for languages other than English.

    Currently, the US does not appear in the region list when selecting French as the language.

    This would be useful for non-English users who wish to maintain an American date format.

    12 votes

    We're glad you're here

    Please sign in to leave feedback

    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 →
  9. Lock or rename file when actively writing to file

    We are using file target to move data into a system that PI Integrator does not support writing to directly. We have a script that moves the files PI Integrator creates to our other system, but we need a way to tell when the Integrator has finished writing to that file. The Integrator should either lock the file it is writing to or have a processing naming pattern similar to UFL.

    12 votes

    We're glad you're here

    Please sign in to leave feedback

    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 →
  10. Allow Modification on PI Integrator published view

    Often, once a view is published, we would like to add a tag to it.

    Unfortunately, for this we need to copy the view and it'll create a copy of the target, forcing us to backfill again all the view.

    We would like this to change.

    Knowing that other companies would like to keep published view locked, this is our proposal:

    • when a copy of the view is made, on the publish panel, you can select a target and also choose to create a new table or select an existing table. -> This will allow us to publish to the…
    11 votes

    We're glad you're here

    Please sign in to leave feedback

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

    11 votes

    We're glad you're here

    Please sign in to leave feedback

    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 →
  12. Allow users to "Add Columns" while "Modifying View" even if there is no time series values selected.

    Allow users to "Add Columns" while "Modifying View" even if there is no time series values selected.

    This will let us export things like 'path', 'description', 'category', 'name', etc. Which may be useful on their own, or when joined with another table.

    This has the additional benefit of making table joins easier, as time series tables are almost guaranteed not to have any columns with unique entries.

    11 votes

    We're glad you're here

    Please sign in to leave feedback

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

    10 votes

    We're glad you're here

    Please sign in to leave feedback

    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 →
  14. Configurable message key for Apache Kafka targets

    Being able to specify message keys for Apache Kafka targets would allow users to configure partitions.

    10 votes

    We're glad you're here

    Please sign in to leave feedback

    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 →
  15. Send timestamps to esri ArcGIS along with values

    As a PI admin I would like to be able to optionally send through the timestamps of attributes to esri ArcGIS so that my end users can be sure that the data they are seeing in maps is current.

    10 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  PI Integrator for Esri ArcGIS  ·  Flag idea as inappropriate…  ·  Admin →
  16. Update data functionality for text file outputs

    Implement the ability to update data for continuously publishing views to text file outputs in same way that it is available for other data targets.  Use cases for this include:

    1) Ability to update data in the case of out of order events, late arriving data, or recalculated data.

    10 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    5 comments  ·  PI Integrator for Business Analytics  ·  Flag idea as inappropriate…  ·  Admin →
  17. Save the original First Run Time field when modifying a view

    When modifying a view that has already ran successfully, the First Run Time is not preserved.  The last time I configured it, it was set to a future date at 1AM.  When I modify it again, the field is populated with '*'.  It would be nice to have the last configuration saved even if it's not valid, so that I have the context of what I last configured.

    9 votes

    We're glad you're here

    Please sign in to leave feedback

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

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

    9 votes

    We're glad you're here

    Please sign in to leave feedback

    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 →
    TELL US MORE  ·  Joy Wang responded

    If you voted for this idea, did you mean JSON format in the Text File target, or to support JSON format in a new target or existing target? Currently we support JSON format for the Apache Kafka, Azure Event Hubs, Azure IoT Hub, Amazon Kinesis Data Streams, and Amazon S3 writers.

  19. Add ability to export stored Events for Event-based analysis, not only interpolated

    Currently we can export PI data using a given interval, returning evenly-spaced rows of data.

    However, for some uses i need to have the original events stored in PI, not interpolated.

    E.g. i need to create a report that contains every value that the operator has entered (e.g. a catalyst dosing volume) in the duration of an EventFrame.
    For that i would need Archived values like i have in OLEDB Enterprise.

    9 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    6 comments  ·  PI Integrator for Business Analytics  ·  Flag idea as inappropriate…  ·  Admin →
  20. Allow large queries to be split up into manageable pieces

    If I build a view in the Integrator that asks the Data Archive for a large amount of information my query can timeout. This will result in the Integrator writing NULL values to certain columns of my view. As a current workaround I just build a view that spans a shorter time frame to decrease the amount of data I ask for in my query to avoid NULL values. I then can use the Update Data functionality to additional time frames in manageable pieces. This is not ideal and I do not believe it was the intended use of the…

    8 votes

    We're glad you're here

    Please sign in to leave feedback

    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
TELL US MORE
EVALUATING
PLANNED
IN DEVELOPMENT
COMPLETED
DECLINED