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. Add automatic "Update Data" configuration option

    Add the option to automatically update data that were previously published by a continuous view when data have changed since the last publish time. For example, a continuous view runs once every 24 hours to gather interpolated hourly data from devices. These devices typically report back every 24 hours, but sometimes there are connectivity issues that cause data to come in late. Currently the Integrator will publish the previous value for each hour until a current value comes in and will not go back to recalculate the interpolated values that were already published. There is a workaround to manually select…

    33 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 →
  2. Allow asset views to run now and on a schedule

    I need to create asset views that perform daily aggregation at midnight. Currently once I create an asset view I must wait until after the following midnight to see the output. It would be very useful to have the option to publish once and thereafter on a schedule so there is data to work from immediately.
    Alternatively if it was possible to upgrade an existing single published asset view to running on a schedule this would solve the problem.

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

    Since the 2018 release, it is possible to select Run Once to work with the data now. If it’s acceptable, a user has the ability to modify the view to Run on a Schedule and schedule the first run time in the future (midnight tonight for every month etc.) Therefore, we consider the idea of “upgrade an existing single published asset view to running on a schedule” to be solved and completed. Please let me know if you have another idea or use case related to this idea that is not addressed by the 2018 release! Thank you!

  3. Expose Integrator's "Health" via performance counters

    Not just the BA integrator, but all integrators should expose performance counters for health & performance monitoring?
    Including a true heartbeat counter than we can reliably watch to determine the successful end to end flow of data through the integrator?

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

    The 2018 release includes a new feature called Statistics which documents each time a view was published, how many rows of data were read and written, and how many errors if any during each publishing event.

    This feature technically tracks the run history of all published views. Under the tab Statistics for each view, the history lists all runs with information on date and time of each run, total duration of run, rows of data written, rows filtered out by filters and cleansing, and error counts (which can then reviewed in the logs). It also includes time duration of each step: reading from PI, filtering and calculating, and writing to .

    For more details, see Release Notes and User Guide for PI Integrator for Business Analytics 2018.

  4. Preserve view model when PI AF Server is changed

    As a PII4BA user I need to create same views pointing to different PI AF Servers, when I change the AF Server, the view model is lost. It should check if templates and attributes exists on this AF Server, and if it is consistent, preserve the view model.

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

    This capability is available through the Import/Export feature under Administration > Views. You can export the view and import it and change the AF server/database during the import stage and UI. This capability has been released since PI Integrator for Business Analytics 2018.

  5. Allow users to modify existing views

    Currently, it is not possible to modify an existing view in the PI Integrator. End users would like to be able to modify an existing view and reuse the same table name.

    The end user should have the option to choose whether or not the view should be purged and republished, or to delete and backfill only a certain amount. For example, if a new column is added, and historical data does not exist, it would be good to be able to keep all previous data instead of republishing again.

    20 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. Add support for Kerberized Hadoop

    We would like to use the Integrator to publish to a  Kerberized Hadoop cluster (Hadoop that uses Kerberos tickets). Currently this is not supported by the Integrator (Enhancement 148795.), and if you try to set up a Hadoop target that is a Kerberized Hadoop cluster, you will see the error:
    "HadoopHDFSWriter::GetHomeDirectoryAsync: Request failed. Authentication required Result: ...401 Authentication required..."

    Current workaround: publish to a SQL Server target instead and then use a Hadoop tool such as Sqoop to bulk copy data from the SQL Server to Hadoop.

    17 votes
    Sign in Sign in with OSIsoft
    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 →
  7. Add the ability to export/Import views

    As a Systems Integrator I need to be able to develop BI views in a test environment then after customer acceptance, there needs to be a mechanism to move that view to production environments.

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

    We’ll send you updates on this idea

    3 comments  ·  PI Integrator for Business Analytics  ·  Flag idea as inappropriate…  ·  Admin →
  8. Remove default columns from text file target

    In the output file for the text file target there are some default columns that get added to the file "ID, PIIntTSTicks, and PIINTShapeID ". It will be good if those columns are not automatically added to the output file.

    15 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 →
  9. Allow assets to be filtered based on template inheritance

    We currently have Elements built on inherited templates. For example, we have ElementTemplate, which has inherited child templates,  ChildTemplateA and ChildTemplateB.

    In PI System Explorer, we can do an Element Search and apply a template filter for ElementTemplate. The results will include any elements based on ElementTemplate, as well as any Elements based on both inherited child templates, ChildTemplateA and ChildTemplateB.

    However, when building a shape in the integrator, there is currently no corresponding way to filter based on the parent template, ElementTemplate.

    In order to provide a consistent user experience, the PI Integrator for Business Analytics should allow the…

    13 votes
    Sign in Sign in with OSIsoft
    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 →

    This feature has been completed since PI Integrator for Business Analytics 2018. It shows up as a checkbox for “Search Derived Templates” when you click into a filter. A related feature supporting Event Frame templates in Event Views was added in PI Integrator for Business Analytics 2018 R2.

  10. 'Download Logs' should download all logs within the specified time range

    Currently it only downloads logs that are loaded in the display pane. In order to get it to download everything, I have to scroll down until everything is loaded.

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

    This behavior was a bug that was fixed in the latest release, PI Integrator for Business Analytics 2018 R2. Please upgrade to the latest version if you are still experiencing this issue.

  11. Add monthly publish option

    The Integrator can currently publish on a schedule of minutes, hours, days, and weeks, but there is no "months" option. If we have meter data, for example, that are entered once a month on the 5th, we would like the Integrator to be able to publish on the 8th every month to capture these data. Setting the publishing interval to 31 days works for several months but eventually drifts to later and later in the month, at which point the view needs to be recreated.

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

    This is now supported in PI Integrator for Business Analytics 2018.

    You can type in an integer value for the “day of the month” in the “First Run” field and schedule the view to recur every 1 month.

  12. Allow users to add GUID of the Event Frame to a view

    The abillity to add an Event frame's GUID is necessary to allow advanced solutions like genealogy to report on and link to a specific event frame.

    8 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 Conversion Factor configuration to PI Integrator for BA

    When adding Total column in PI Integrator for BA it is one day total (Conversion Factor = 1) by default. This should be configurable.

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

    We’ll send you updates on this idea

    4 comments  ·  PI Integrator for Business Analytics  ·  Flag idea as inappropriate…  ·  Admin →
  14. Add delimiter option to file writer

    Allow to choose delimiter for output file.

    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 →
  15. Make "PI Views" easier for BI access or support SQL in the BI edition

    Using the integrator for BA - BI edition, you need to use the PI ODBC driver to read the data from PI views. That is a lot of hassle, given the fact that in most clients it is way easier to read from SQLserver where the data is in the first place. With the only exception that the tablename is the GUID instead of the view name.

    I created some scripting to create views based on the data in SQL and the data in the Integrator DB just to read the data directly from SQL.

    I think this limitation makes…

    5 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 →
  16. Edit Value Mode

    Provide an opportunity to choose a month in the Edit Value Mode. File as an attachment.

    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 →
  17. Support Amazon S3 Bucket as a file endpoint

    Add the ability to define an Amazon S3 Bucket as an endpoint for text files.  Some external vendors are using this as a preferred method for data ingress.  The only way I could find to do  this today is using a powershell script we've published on PI Square.

    4 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 →
  18. Allow target configuration changes to be pushed out to previously created views

    This would be useful if you have many views and the configuration for a target changes (SQL login changes, hostname changes, etc).

    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 →

    This functionality was added as a part of the last release, PI Integrator for Business Analytics 2018 R2. After changing target configuration parameters and clicking Save Changes, all views writing to the target should pick up the changes upon the next scheduled scan.

  19. Support element renames

    As someone who works with both the integrator and other PI admins, I would like the integrator to detect element renames and include the new name in future publications. PI admins may need to rename elements, but currently this will cause a discrepancy between the name stored in AF and the name sent by 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  ·  General  ·  Flag idea as inappropriate…  ·  Admin →

    This request is addressed and completed in the 2018 release. Added, renamed, and deleted elements will be propagated to the views automatically. See release notes and user guide for additional details.

  20. Represent the PI real time data in AWS Cloud

    We are planning to represent the PI real time data in AWS Cloud (in any suitable format) using some weblink or any other way.

    We trying to build a Dashboard kind of thing (using Dimensional modelling) to pull equipment data based on Several filter condition on AWS Cloud Solution.  I am not actually trying to put PI Server on AWS Cloud,

    Going forward we need the ability to display the AF data related to equipment.

    Will any PI Integrator help me to achieve my goals?

    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 →

    Preparing PI data for data science enablement through Amazon S3, Redshift, and Kinesis Data Streams is now possible through the latest release: PI Integrator for Business Analytics 2018 R2, released in November 2018.

← Previous 1
  • 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