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.

How can we improve PI Integrators?

(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. BI Integrator preserve Column Configuration on Filter Change

    When you copy a BI Integrator Job ans change some settings in the Filter all attributes are added to the column view.

    We remove Attributes that are not needed e.g. Level1 Attributes when we only Need the Level2 Child Attributes. On a change the Level1 Attributes are always added.

    We rename Attributed and change the export settings e.g. Aggregstion or UOM. On a filter change the original Attributes are added again.

    We would prefer an option/setting in PI BI that no column is added to the column view and you can select them by the Add Column function.

    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 →
  2. Unique Output Streams Consumed/Remaining notification

    I would like to get notified for Unique Output Streams Consumed or Remaining in PI Integrator Administration page under Licensing.

    3 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. Throttle Data Archive reads

    As an Integrator user, I do not want to overwhelm the PI Data Archive when the Integrator reads data, either for an initial view backfilling operation or when I have multiple views running in real-time. I would like the Integrator to throttle Data Archive reads so as to not overwhelm the Data Archive or give me insight when I am making an expensive Data Archive call with the Integrator.

    3 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 →
  4. Support authentication to Apache Hive via Kerberos

    I would like to be able to publish data from the PI Integrator for Business Analytics to Apache Hive that is set up for only Kerberos authentication.

    3 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. Replace carriage return and other bad characters in attribute values

    We are using PI Integrator to write operator comments to a file target. The operator comments can include carriage returns which mess up the data written to file. Carriage returns and other bad characters should be replaced before writing to the target.

    3 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 →
  6. Option to specify max file size

    When publishing to a file, the file can get extremely large. There should be an option in the file target to specify the maximum file size before rolling over to a new file.

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

    2 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 →
  8. Have the option to preserve or change GUID during View import

    During View import process, have the option to preserve or change the View's GUID. This comes into play if multiple Integrators share the same SQL backend; there will be a GUID collision. Use case: split a large view among Integrators (for performance reasons) by using the Export/Import option.

    2 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. Add attribute configuration string/PI tag name to view

    My users want to see the PI Point names in their views and not just the attribute name. I would like to be able to add the attribute configuration string as a column in my view.

    2 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. Allow to configure the format of the output file

    The actual version just allows to create a text file output. It would be nice to be able to manage the format of the columns in that target

    2 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 →
  11. Overlapping Time Ranges for Continuous View updates (Rolling Publications)

    I wish that the start time of a continuous view update cycle could precede the end time of the last cycle.

    For example every day query the last 30 days of data and replace rows that have already been written to the target table with the most recent data. This would be a straightforward way to ensure that data in PI and the integrator View are the same for the last 30 days. Manual corrections up to 30 days old could then be captured automatically.

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

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

    1 vote
    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. Improve performance on narrow table queries

    Improve performance of queries resulting in a narrow table. This can happen for queries with many Elements, each with a few Attributes, where bulk queries to the data source are not possible. A narrow table can also result when using * for the Attribute criteria, as each Attribute is then considered a separate match.

    1 vote
    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. Grant permissions only to configure targets

    As a PI Integrator Administrator I need to grant permissions to a group of users to configure targets since they are the administrators of the target systems (SQL Server, ADLS, etc.), but they don't need access to other administrator tasks like security management.

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

    1 vote
    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. Enhance Scheduling Options

    Would like the ability to schedule publishing a view during specific times of the day, for example between 6 PM and 3 AM every day (to reduce network load)

    1 vote
    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. Allow to Manually execute a publish once view

    To execute a view with the same parameters, it is actually mandatory to edit the view to be able to execute it again.
    It would be nice to be able to force its execution using a right clic on it for example

    1 vote
    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. Display the total number of matches for a shape

    When applying a filter when building a shape, the Integrator displays a limited amount of matching elements which is fine.
    It would be useful do display the number of element matches as an additional info

    1 vote
    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. Create non-clustered index via the Integrator front end

    Our end users tend not to have SQL access. We would like to allow them to create clustered indexes to increase the performance of a SQL query on the target view.

    1 vote
    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
COMPLETED