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. Have PI Integrator support Azure Active Directory integrated authentication to Azure SQL and Azure Synapse Analytics

    As a PI Integrator user, I would like PI Integrator to support Azure Active Directory integrated authentication to Azure SQL and Azure Synapse Analytics.

    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 →
  2. AWS Timestream support

    AWS Timestream should be supported ..

    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. Apply the Row Filter criteria in the data preview screen for an Asset View before applying the 100 row cutoff

    Have the row filter that you define in the preview screen for an Asset View be applied before the 100 row cutoff. Currently it applies that cutoff first which means you won't see any rows returned if the columns that have the value you're filtering for are outside of the first 100 rows.

    I need to be able to preview the data that'd be returned and applying the 100 row cutoff first can make that impossible for larger datasets.

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

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

    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. Have the Column Headers show up regardless whether this is the first of second file of an export data file?

    Have the PI Integrator for Business Analytics always create Column Headers regardless if it appending to the same file or a different file, and ID to reset to 1. Currently, "Append Timestamp" is unchecked and upon the program removing the file from the original export location, sometimes the column headers will not show up and the ID will not reset as the Integrator believes that it is appending data when the first file that is gone. The First file will always contain the Column Headers and ID will start at 1. Please let all subsequent file Column Headers and ID…

    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

    2 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

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

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

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

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

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

    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 →
  15. Allow for an IT policy requiring fixed database sizes by optionally preventing the PI Integrator Log database from dynamically shrinking

    As a system administrator working under our IT department's policies, I want to be able to prevent the PI Integrator's Log database from shrinking, so that I can conform to IT policies that require fixed SQL database sizes with the goal of preventing fragmentation.

    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. Update Data for Hadoop endpoint

    Add the Update Data Function to allow for backfilling or updating of values to the Hadoop Endpoint

    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. Export data in rows instead of columns

    Data is usually exported under column headers, but I'd like to know whether it's possible to export data in rows (e.g. tags in one row, values in another row). I can transpose this data in SQL after the fact, but is this possible to do from the Integrator itself?

    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 →
  18. Allow streaming view for Event Frames in the PI Integrator for Business Analytics

    It would be useful to be able to stream Event Frames via the PI Integrator for BA so that the associated and aggregate data for events can be used in targets.

    This opens the possibility of using Event Frames to identify specific situations, gather the data and then share that data in real-time with other systems so that those systems can make event-based analyses.

    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 →
  19. Provide option to pause a backfill

    PI Integrator views can be backfilled using the Update Data or automatically with the PI Integrator Sync service. Having the ability to pause these backfills could allow users to resume them at a later time if their PI System is experiencing any temporary issues.

    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 →
  20. Provide prompt whenever data will be deleted by an action

    There are multiple PI Integrator actions that will cause data to be deleted such as Update Data or republishing a view. Whenever data will be deleted by the PI Integrator, a prompt should be returned so users are aware that their actions will result in this.

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