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?

    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. 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 →
    TELL US MORE  ·  Joy Wang responded

    How would you like to be notified? Under what circumstances is a notification important? Please feel free to email me directly to discuss the use case! Thanks!

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

    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. 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 →
  6. 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 →
  7. Display next run time for scheduled views

    As a PI Integrator user, I would like to view the next run time of my scheduled view to ensure that I have configured it correctly.

    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 →
  8. Allow PI Integrator for Business Analytics to publish to an existing/pre-defined table

    PI Integrator creates tables in the destination database. I'd like to have PI Integrator publishes data to pre-defined tables.

    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. Support non-domain SQL server as PI Integrator backend

    PI Integrator supports SQL authentication to the backend SQL server. However, the install user is only authenticated to the SQL server by windows authentication, which makes using a non-domain SQL Server unfeasible. Please support a non-domain SQL server as the Integrator backend to allow more flexible architecture options.

    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. 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
    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 query all child event frames (based on different templates) and their respective attributes into a single event view

    The batch process can include multiple levels of child event frames which are based on different templates and thus contain different attributes. As a PI Integrator user, I would like to have the option to build a single event view which include all child event frames and their attributes. This will give a holistic view of a parent event. Currently I must use separate event views for each child event frame. This is difficult to manage.

    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. 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
    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 →
  13. 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
    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 →
  14. 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…

    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. Choose a shape's filter condition ('OR' or 'AND')

    Currently, two filters added means it's an "OR" condition. I would like to be able to choose the condition applied, so I could instead select it to be an "AND" condition so the elements must meet both or all criteria. This would be useful to apply multiple categories to the View, such as an element being x 'OEM' category and y 'Model' category. As an alternative, make the categories multi-selectable.

    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. Please have the PI Integrator for Business Analytics support Windows Server Core

    As a user of PI Integrator for Business Analytics, I'd like to have it support Windows Server Core operating systems.

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

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

    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 →
  20. Allow to Manually execute a publish once view

    To execute a view with the same parameters, it is actually mandatory to edit the view to be able to execute it again.
    It would be nice to be able to force its execution using a right clic on it for example

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