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. 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 →
  2. 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
    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 →
  3. 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 →
  4. 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 →
  5. 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 →
  6. Support connecting to a different DNS listener for each of the Integrator's backend SQL databases

    The Integrator currently supports only a single SQL server connection string to access all of its backend databases (PIIntegratorDB, PIIntegratorLogs, PIIntegratorStats). Our organization's SQL Server cluster provides high availability at the SQL database level, however, with a separate DNS listener for each database. When either of the other PI Integrator backend databases fails over to another SQL server, we see errors like the following:
    “SqlUtilities:GetBackendSqlConnection: Error: Unable to obtain open SqlConnection to database, ‘PIIntegratorLogs’,at SQL server path, '(Server)'".

    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 →
  7. Allow default schema to be configurable

    Our Database Administrator would like the Integrator to publish using a different schema than dbo for SQL targets, so I would like this to be configurable in the Integrator. Currently it is not possible to change it from the default dbo.

    12 votes
    Sign in Sign in with OSIsoft
    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. Support for "BoD" (beginning of day) in Start Time End Time

    As a user who creates daily reports with the Integrator, it would be great if setting the period had a function similar to AF's Analysis "BoD" which returns the beginning of a day regardless of time input so that it will avoid confusion and ease the dependency between the job running time and the selection period.  Currently if I want a job to get data from midnight to midnight at 1AM everyday, I have to use Start time *-25h and End time *-61m (to avoid 2 values of the daily interpolation).

    5 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 →
  9. Sort View Statistics tab

    As a user, I'd like to utilize the columns in Statistics tab more effectively by being able to sort on the column so that I can sort by duration, error count, etc.

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

    Currently we don’t enable sort because each statistic such as “duration, error count, etc” is indexed on time. There is a time-series graph showing error count over the last X number of runs. And when there are anomalies, you can click into those runs to see more details. You can also easily click back out and see the trend for error count or duration. How would being able to sort add more or different value than what is currently available?

  10. Add support for "Limits" in PI System Explorer

    As a user of AF, we would like it to be the system of record for our data.  For some of our KPIs, we would like to leverage the Limits feature in PI System Explorer and have the ability to add those limits to the Integrator.  Then we can leverage the limits downstream when creating our dashboards to show if a KPI is below or above a limit.

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

    6 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. Customize text file target

    Ability to set the locales for each text file target individually.

    5 votes
    Sign in Sign in with OSIsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

  13. Provide support for Element Attribute with Value Retrieval Method by time Not Supported when requesting sampled data with an interval

    When retrieving AF attributes with a by Time Range setting of Not supported, the integrator will not return the data for the intervals as defined by the Query.

    34 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. Allow for default AF DB/Server to be reflected when building a new shape

    When a user starts making a new Shape in the Designer UI they are given a list of AF Servers/DBs to choose from.The list is currently in alphabetical order and the first item is selected. It would be great if there were some default could be reflected so the user can immediately start working on the shape.

    6 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 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 →
  16. 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 →
  17. 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.

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

    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