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

    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 →
  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. Please have the PI Integrator for Business Analytics support Windows Server Core

    As a user of PI Integrator for Business Analytics, I'd like to have it support Windows Server Core operating systems.

    2 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 →
  4. Add the ability to select all child elements and replicate parts of the AF hierarchy when using Streaming Views

    As an end user utilizing existing AF hierarchies with the PI Integrator for Business Analytics, I would like the ability to select entire parts of the AF hierarchy when creating streaming views such as the ability to select all child elements and their respective attributes. Filters can work when the hierarchy has been optimized with the Integrator in mind but not in all situations.

    1 vote

    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 →
  5. 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 →
  6. Support element and attribute versioning for all value retrieval methods

    As a PI Integrator user, I would like the Integrator to support retrieving element and attribute versioned data and metadata (PI Point, element GUID, etc.) so that the data I publish with the Integrator are correct in their respective time context. For example, my attribute's data reference may be Tag1 until the equipment was decommissioned a month ago, and then a new element version is created to reference Tag2. I would like the Integrator to respect the AF element/attribute versioning effective dates to determine the correct data to publish.

    2 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. PI Integrator for BA support for Amazon RDS database

    It would be useful if the Integrator could use Amazon's RDS in addition to SQL Server as a backend for publishing views.

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

    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 →
  10. 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 →
  11. Add value option to publish element version metadata

    As a PI Integrator user, I would like to be able to publish metadata about a given element's/attribute's AF version metadata (such as number like 0, 1, 2) so that I am aware when an element/attribute version has changed.

    1 vote

    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 →
  12. Add Boolean row filter

    In PI Integrator for BA, to use filter on an attribute configured as Boolean Value Type, we can use Numeric filter. However, 'attribute' = 1 does not work because it filters out all the rows. We have to use 'attribute' = True. It is not intuitive that we can use string value in a numeric filter. Is there any way OSIsoft can improve the UI, like add a row filter option for Boolean?

    3 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 →
  13. Add Questionable as Data Content option

    As a data science user, I would like to be able to include additional PI/AF tag information such as is Questionable so that I may filter out data down stream easier.

    4 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  ·  General  ·  Flag idea as inappropriate…  ·  Admin →
  14. New target Azure Cosmos DB

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

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

    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

    1 comment  ·  PI Integrator for Business Analytics  ·  Flag idea as inappropriate…  ·  Admin →
  16. Sign up for updates on the PI AF Server for new event frames

    Currently, the PI Integrator for BA 2018 will add rows for event frames ending within the scheduled update time range. It would be better if the PI Integrator signed up for updates on the database and gets a list of all new or modified event frames to handle the cases where event frames are closed with an end time in the past that is not covered by the run period anymore.

    29 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

    3 comments  ·  PI Integrator for Business Analytics  ·  Flag idea as inappropriate…  ·  Admin →
  17. 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

    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 a "Written" timestamp column when publishing a view to indicate when the data row was modified/written

    Have an extra column in the view that indicates when the data row is actually written to the target.
    The current timestamp column is the timestamp of the value itself, not when the data row is written.
    This will be especially useful for troubleshooting, or when PI Integrator is updating existing value in a target table (will give indication of which data row was recently updated).

    2 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 →
  19. 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.

    6 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 →
  20. Display full path of the element in the column name

    When there are multiple attributes named the same for different elements, the full path is automatically done to avoid duplicated column names. Element without name duplication issue should also have the option to display the full path column name.

    2 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