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. 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 →
  2. 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 →
  3. 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 →
  4. Don't recreate SQL View tables for minor changes

    As a Developer, it would be useful if the SQL tables outputted by the PI Integrator for Business Analytics were not deleted and recreated when minor changes are made to the Integrator View, such as the schedule. This would stop connections/queries being made to these tables from being broken.

    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 →
  5. Expose counters to track communication health between PI Integrator Framework and the Worker Nodes

    As a PI Administrator, I need to determine the health of the PI Integrator. I wish to monitor the connection and inter-process behaviour between the integrator and multiple worker nodes. I would like to be able to determine when a worker node disconnects from the integrator framework/host, hangs or becomes unavailable as this will result in no data being published. By monitoring the health and performance of all components of the PI Integrator, I can take a proactive approach to system health and performance.

    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 →
  6. 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 →
  7. 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 →
  8. 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 →
  9. 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 →
  10. 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 →
  11. 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 →
  12. 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 →
  13. 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 →
  14. 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 →
  15. 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 →
  16. 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 →
  17. 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 →
  18. Create non-clustered index via the Integrator front end

    Our end users tend not to have SQL access. We would like to allow them to create clustered indexes to increase the performance of a SQL query on the target view.

    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. Text file / ADLS Target: Split output files based on elementname, attribute, or date

    The output files can grow quite large.
    Suggestion :Split the files. Here is an example using AF element name and date :
    C:\Viewname\elementname\YYYY\elementname_YYYYMMDDHHssmm.csv

    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 →
  20. Have the option to preserve or change GUID during View import

    During View import process, have the option to preserve or change the View's GUID. This comes into play if multiple Integrators share the same SQL backend; there will be a GUID collision. Use case: split a large view among Integrators (for performance reasons) by using the Export/Import option.

    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
NEEDS MORE DISCUSSION
RESEARCHING/EVALUATING
DECLINED
PLANNED
STARTED/IN DEVELOPMENT
IN BETA/PREVIEW
COMPLETED