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. 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 →
  2. 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 →
  3. 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 →
  4. 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 →
  5. 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.

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

    We’ll send you updates on this idea

    1 comment  ·  General  ·  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. 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?

  9. 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 →
  10. 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 →
  11. Support data aggregation when requesting data with a time interval filter through PI Integrator for Esri feature service

    Provide support for Element Attribute with Value Retrieval Method by time-Time Range, By Time Range-Maximum/Minimum/Average/Total when requesting data with a time interval through PI Integrator for Esri feature service.

    We are creating Esri Web App Builder chart and map widgets that show PI data, and we are using PI Integrator for Esri to access the PI data. One use case is to show max feeder load for a set of feeders over a set time range in a bar chart, the time range could be a particular month, year, quarter, or ad-hoc date range selected by the user through a…

    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 Esri ArcGIS  ·  Flag idea as inappropriate…  ·  Admin →
  12. 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

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

  14. Make it easy to find updated security patches to OSISoft Products

    As a PI Administrator for a power company I am asked twice a month to verify that none of the products I support have had a security patch released.  Any such products in a NERC zone need to be patched within the next 12 days.

    It used to be fairly easy to look at updates to all PI Client tools to find released security patches.  So far I haven't been able to find out if any have been patched.  This would also include interfaces which are prone to being run in a NERC environment.

    1 vote
    Sign in Sign in with OSIsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  15. 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 →
  16. 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 →
  17. Support Silent (Unattended) Installation and configuration to ease cloud deployment

    Please provide a silent installation capability for PI Integrators. A preferred implementation would be a command line approach (as opposed to a silent ini). This allows for the install to be execute via a command prompt or via PowerShell where configuration settings are passed as command line arguments as is done currently with the integrated PI Server install kit. An ability to export the command syntax from the PI Integrator install kit would be an added bonus. (Example of the specific implementation can be found on page 294 of the PI Server 2018 Installation and Upgrade Guide.)

    An extension to…

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

    We’ll send you updates on this idea

    0 comments  ·  Installation  ·  Flag idea as inappropriate…  ·  Admin →
  18. 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 →
  19. 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 →
  20. 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 →
  • 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