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. Allow change of target configuration after publish

    Once a View has been published, you cannot change the Target--the dropdown is greyed out on the 'Publish' screen in the designer. You have to re-create the View to publish to a new target, which is a lot more work and opens up the potential for issues or misconfigurations. Use case: if I was publishing to a sandbox environment and now want to publish the View to production, I could change the existing View's target in the drop-down instead of re-creating it.

    Note: This is different from another, completed idea (https://feedback.osisoft.com/forums/555136-pi-integrators/suggestions/35776837-allow-target-configuration-changes-to-be-pushed-ou) as I don't want the configuration of…

    7 votes

    We're glad you're here

    Please sign in to leave feedback

    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. Change the friendly name of the self-signed certificate to "PI Integrator for Business Analytics Self-signed Certificate"

    To avoid confusion during certificate selection, please change the friendly name of the self-signed certificate from "PI Integrator for Business Analytics" to "PI Integrator for Business Analytics Self-signed Certificate"
    PI SQL DAS self-signed certificate has the friendly name "PI SQL Data Access Server Self-signed Certificate", which is quite clear.

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    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. Option to automatically create sub folders in AWS S3 per time period (hour/day/month)

    It would be nice to have an option to specify PI INT to create sub folders within a 'view' folder in AWS S3 so that data files dumped in S3 folder could be automatically organized by the time period, example: subfolder for all files created for that day.

    4 votes

    We're glad you're here

    Please sign in to leave feedback

    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. External triggers for streaming views

    Request to allow for streaming view triggers based on attributes that are not already in the schema. Need to be able to specify external triggers while defining the shape for a streaming view.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    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. After manually updating data, the next scheduled publish should ensure it does not publish duplicates

    As a PI Integrator user, if I use the manual "Update Data" option to correct a time period that includes data that will be published on the next scheduled publication run I do not want this next scheduled run to publish duplicate rows. For example, if I have an Event View that publishes on the hour every hour and the last run was at 1:00 PM, if I run update data at 1:25 PM specifying start time 1:00 PM to end time *, the next scheduled publish will look at the 1:00 PM to 2:00 PM time range and therefore…

    4 votes

    We're glad you're here

    Please sign in to leave feedback

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

    As a PI Integrator user, I would like to be able to specify a schema for my Oracle publish target so that the Integrator only uses the schema that my Database Administrator specifies for me. Currently it is not possible to specify a schema for the Integrator to use, so it will use the Oracle logon's schema by default.

    2 votes

    We're glad you're here

    Please sign in to leave feedback

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

    21 votes

    We're glad you're here

    Please sign in to leave feedback

    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. Allow PI Integrator Installation without requiring HTTPS/SSL

    Currently Pi4BA requires a SSL/HTTPS connection, and allows you to create an self-signed certificate. There is no option to modify this connection to HTTP or remove SSL, as Pi4BA doesn't use a standard IIS website, and none of the exposed configuration options allow switching between HTTP/HTTPS connections

    The self-signed cert approach causes client warnings about "not-secure" unless the certificated is locally installed on each client.

    While have SSL as a default option on the installation is fine, for internal projects connecting to internal servers, HTTP only (none SSL) should be provided as an installation option, to reduce the cost and…

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    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. Allow Modification on PI Integrator published view

    Often, once a view is published, we would like to add a tag to it.

    Unfortunately, for this we need to copy the view and it'll create a copy of the target, forcing us to backfill again all the view.

    We would like this to change.

    Knowing that other companies would like to keep published view locked, this is our proposal:

    • when a copy of the view is made, on the publish panel, you can select a target and also choose to create a new table or select an existing table. -> This will allow us to publish to the…
    11 votes

    We're glad you're here

    Please sign in to leave feedback

    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. Manually refresh point configuration changes

    As a PI System Admin, it would be useful to have a way of manually refreshing point configuration updates in the PI Integrator for Business Analytics user interface, instead of waiting for point changes to updated automatically. This would be useful for testing purposes and fast-moving projects. At present this is achieved by restarting the service however a button, similar to the Restart button in PI ICU for interfaces, would be helpful.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    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 SQL in Azure as a BA Integrator backend

    As an administrator, I want to use SQL Azure as the database backend for my PI IntegratorDB, Stats, Logs database, so that I can offload the SQL administrative tasks to Azure.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    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. Allow publishing to S3 with Roles instead of key / secrect key

    Rotating security keys on a regular basis is extremely time consuming when you have to change the key on each defined target.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

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

    We're glad you're here

    Please sign in to leave feedback

    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. Support Element metadata Modification for data synchronization with PI AF

    I would like the PI Integrator for BA to be able to detect an Element metadata modification (ex.: Category) and automatically add this element to published views where the element modification matches the view's shape

    4 votes

    We're glad you're here

    Please sign in to leave feedback

    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. Improve the Upgrade Installation Experience

    Allow the licensed size of the integrator to be increased on already deployed infrastructure without requiring a new installation of the software. License process similar to the current one with the PI Server is requested.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    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 DateTime row filter

    As a PI Integrator user, I would like to be able to use a DateTime row filter so that I can filter out rows based on certain date- or time-related criteria.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    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. Time zone configuration parameter should set up on Server site instead Client site

    The impact would be the timestamp format in the published file in Azure Data Lake Store.

    If we set PI integrator region to AU, the timestamp would be like 31/12/2019.

    If we set PI integrator region to US, the timestamp would be like 12/31/2019.

    If there are multiple support people and they use different region settings on their browser, it would mess up the data format in Azure Data Lake Store and this will cause an issue with data transformation process in Azure that we have.

    I was thinking the setting should have been on a server level if we…

    3 votes

    We're glad you're here

    Please sign in to leave feedback

    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. More control over view format (wide verse long tables)

    I would like to be able to have more control over the format of the views. For instance, right now it automatically populates every included attribute as a column. For my continuous data attributes I would like to be able to condense the 50+ individual attribute columns into 3 columns : attribute, value, timestamp. This would make the table a long format instead of wide.

    4 votes

    We're glad you're here

    Please sign in to leave feedback

    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 →
  19. Expose PI Integrator view statuses

    Customers who plan to have a significant number of views need a better way to manage the status of their views other than periodically checking the PI Integrator UI.

    There should be a way to obtain view statuses through other programs (custom or PI), so that users can receive alerts if a view goes into an error status.

    25 votes

    We're glad you're here

    Please sign in to leave feedback

    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 →
  20. Add support for multiple events with same timestamp in PI Integrator for BA

    The Integrator for BA appears to be a great fit for exporting event-based data such as Batch Interface Messages to external systems. Interpolation doesn’t apply in these cases so we can use a tag as the ‘Key’ in value mode selection.
    However, there are cases where a tag can have multiple entries at a given timestamp (e.g. EMDVB Recipe Parameter Downloads) and the current behavior is to only include the first value in the output view. This approach results in missing data and makes the integrator unusable in these cases.
    Ideally the view would return all records (as per PI…

    26 votes

    We're glad you're here

    Please sign in to leave feedback

    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 →
  • 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
TELL US MORE
EVALUATING
PLANNED
IN DEVELOPMENT
COMPLETED
DECLINED