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 to include open Event Frames

    The integrator only includes EventFrames that are closed (have end time). That is not included in the documentation, so a major issue for me now.
    The reasoning is that an open EF may not have all data or correct data. I would prefer to let the user decide on that and allow to include open eventframes. After all we can filter out the open ones using row filters.

    I planned to use the integrator to get rid of OLEDB Enterprise. Now it turns out i cannot reach all my data. Looking seriously into returning the license.

    The reasoning is

    64 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 →
  2. Provide Bulk Column Configuration

    The current method for adding columns and changing their Data Content type (value, average, min, max, etc) is clunky and time consuming.  You can only change (or add) one column at a time, and you have to wait for the data view to refresh after each change.

    Ideally, I would like to have the ability to switch from the default UI (Column headers with real data) to a configuration UI that has a more tabular configuraiton layout or a layout similar to AF. 

    I want to be able to select multiple data items and change them all to be "Average"…

    49 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

    7 comments  ·  PI Integrator for Business Analytics  ·  Flag idea as inappropriate…  ·  Admin →
    Joy Wang responded

    Correction to earlier comment made by Matt Zieger: PI Integrator for Business Analytics 2018 does not support bulk column configuration. This idea is currently not planned. Feel free to contact me if you’d like to discuss more. Thank you!

  3. Increase 100k stream limit

    As an engineer looking to leverage hundreds of thousands of tags for BI, I would like to use a single integrator instance to publish all of the data rather than installing multiple instances on different nodes.

    34 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

    EVALUATING  ·  3 comments  ·  PI Integrator for Business Analytics  ·  Flag idea as inappropriate…  ·  Admin →
  4. Option to delete target data table when view is deleted

    When a PI View is deleted from the Integrator User Interface, the Publication Metadata and target data tables are both deleted for that view. For a view with a non-PI View target such as a SQL target, however, only the Publication Metadata table is deleted. The Integrator will no longer consider that view name to be reserved after deleting the view, but using that name again for a new view with the same target requires us to manually delete the target table if there is a change to the shape or we do not want to append to the existing…

    34 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

    9 comments  ·  PI Integrator for Business Analytics  ·  Flag idea as inappropriate…  ·  Admin →
    Joy Wang responded

    Correction to earlier comment by Matt Ziegler: This idea was not fulfilled in PI Integrator for Business Analytics 2018 release. This idea is currently not planned for a future release. If you have a use case and desired behavior for a particular writer and want to discuss further, please comment below or email me. Thank you!

  5. 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 →
  6. Automatically remove data from continuous views

    As an engineer using PI View or SQL writers for a report, I would like option to remove data older than a certain cutoff. For example, a continuous view is used to generate data for a report on the last 8 hours. Data older than that are no longer needed for the report and should be removed to avoid unnecessarily large tables.

    One workaround with Text and Hadoop writers is the Append Timestamp option, but there's no ability to remove data from other targets.

    44 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

    7 comments  ·  PI Integrator for Business Analytics  ·  Flag idea as inappropriate…  ·  Admin →
    TELL US MORE  ·  Joy Wang responded

    For supporters of this idea, what is the downstream client tool that consumes the data prepared by the PI Integrator? Is the concern about disk space or how to only display data for a specified time range?

    For the former, this seems to be a different type of “rolling” reporting use case that we do not currently have a solution for. In the mean time, as Rory mentioned below, a stored procedure on SQL would work if this idea is intended for SQL writers.

    For the latter, is it possible to create “rolling timespans” for your graphs, reports, tables, etc.? For example, here’s a video on how to create calculated measures for a table based on last day or month of data: youtube.com/watch?v=NevFWL2JoMU

  7. 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 →
  8. 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 →
  9. Display more than 100 records (or show the total number of matching records)

    Allow the user to display more than 100 records in Modify View screen or at least show the total number of rows as additional information.

    7 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. AzureSQL Target should not need access to the master database

    The AzureSQL Target should not need access to the master database

    Current version of PII4BA gives this error message:
    Ref the error message
    The server principal "sqluser" is not able to access the database
    "master" under the current security context.

    Microsoft's words:
    “Generally, non-administrator accounts do not need access to the master database”
    https://docs.microsoft.com/en-us/azure/sql-database/sql-database-manage-logins

    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

    1 comment  ·  PI Integrator for Business Analytics  ·  Flag idea as inappropriate…  ·  Admin →
1 2 3 4 5 7 Next →
  • 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