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

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

    3 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. 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 →
  7. 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 →
  8. Support attribute renames

    When an attribute(s) name changes, I would like the Integrator to propagate that change to existing views that contain the attribute. The Integrator does support element renames but not attribute name changes. Currently, we have to republish the affected views in order to continue publishing data for the renamed attributes.

    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 offset options

    I'd like the ability to configure offsets so that 1) my Views are consistently run for the same time intervals (important for statistical calculations) and 2) I can stagger the publishing of my Views to improve performance.

    If I were publishing a relative Continuous View with Start: *-10m to End: * and my goal publishing period were to be something like 08:40 to 08:50--

    For the first, I envision this similar to interface scan class offsets. I'd like to schedule an offset so the View runs every ten minutes but must start at 00:00. This would help avoid accidentally clicking…

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

    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. Send Notification When Publish Job Complete

    Not sure this would help with continuous jobs, but for large jobs that are scheduled to run one time (for example: publish last 2 years of history) it would be nice to be able to have PI Integrator send off a notification when the job is complete. In the administration section where you can create publish targets, you could add a section, notification targets, where you could define a group of people to send a notification to by email. In the email I could see it stating that the publish job is complete and maybe some high level stats, but…

    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. 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 →
  13. Compress files written using file target

    I am using PI Integrator to write data to file and then importing the file into a system PI Integrator does not natively support. Since I have to copy files over the network to get them to my other system, it would be nice if PI Integrator compressed the files once publishing is complete.

    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 →
  14. 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 →
  15. 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 →
  16. 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 →
  17. 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 →
  18. Azure IOT backfill

    The backfill option in Azure IOT integrator should handle the raw data, instead of pushing the 1 minute interpolated values.

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

    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. Allow to configure the number of decimals for an analog column

    I would to force the number of decimals the Integrator writes for a given analog value

    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