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. Support publish data directly to AWS RDS Oracle Database 19c

    Support publish data directly to AWS RDS Oracle Database 19c to allow easier data integration and processing.

    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 →
  2. custom target

    all to develop custom targets, if Osisoft is not planning to support it

    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 →
  3. 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 →
  4. SQL Views include a column for time of the export

    I would like a column to be configured for "time of export" For instance, if I have scheduled the periodicity of 1h, I would like the value of the column changed each hour. Currently, this is not possible as I can only add the timestamp (local and EF) but both are giving the same timestamp (EF one), which is not useful.

    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. Include DST to the sampling interval

    If values in the view are sampled by more than few minutes (12 ours for example) DST change can be an issue, especially if you want to have values exactly at 12 am/pm. It should be optional to include DST into sampling interval.

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

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

    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 →
  8. Disable the functionality deleting existing files when modified view is republished

    When a view that publishes to a file-based publish target is republished, the existing published data files are deleted. Disable this functionality or show a confirmation message before republishing. If a user is unaware of this functionality and republish, all previous work will be deleted.

    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 →
  9. Expose additional Kafka target configuration options

    To accommodate high frequency messages to Apache Kafka brokers, additional tuning of Kafka producers can be necessary to prevent high CPU and Disk I/O load. The PI Integrator should expose these parameters to allow users the ability to adjust their system as necessary. The following are common parameters that would allow for this:

    - Batch Size (batch.size)
    - Linger time (linger.msg)
    - Buffer memory (buffer.memory)
    - LZ4 compression
    

    Additionally, many projects may require that acknowledgements be sent back to the producer to confirm that they were properly received. The PI Integrator should provide the option as for whether or not…

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

    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 →
  11. 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 →
  12. Create an intermediate file cache for file writers that do not support append data

    Some targets, for example S3, do not support append data. Therefore, anytime the PI Integrator for Business Analytics tries to update the file, it needs to reupload the entire file with additional data. As a consequence, during publications, the PI Integrator needs to upload the delta files multiple times as opposed to generating the file once locally and uploading it to S3, which would improve performance.

    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. Allow the creation of global filters so that they do not need to be created individually for each view

    As a user that creates multiple views, allow the creation of global filters so that they do not need to be created individually for each view manually

    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 →
  14. Rest access to Results

    Allow to access the results of a view directly via REST

    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 →
  15. Support latest Oracle database and ODAC version

    As a user who publishes to Oracle, I would like the PI Integrator to support the latest Oracle database and ODAC versions so that I can take advantage of Oracle bug fixes.

    For example, the PI Integrator 2020 version supports only ODAC 12.1.0.2.4 , but nuisance messages due to the following were resolved in a later version of ODAC: ORA-03137: Malformed TTC Packet From Client Rejected.

    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 →
  16. Enable Parquet as a file format for the text file writer

    Allow the text file writer to create more efficient file formats such as Parquet

    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. 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 →
  18. Add BA Target for Snowflake

    Snowflake is a common SaaS data lake solution. BA should be able to write to it.

    6 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 →
  19. Allow PI Integrator to transform data before publishing it

    We have data coming from an RDBMS Interface with the format XXX|YYY|ZZZ.

    In some cases, we have several records with the same timestamp, so we cannot use an Analysis in AF to separate XXX|YYY|ZZZ into 3 different tags with the values XXX, YYY, and ZZZ.

    When we push this tag to a SQL Server through PI Integrator for BA, we would like to have the option to do this transformation there (from 1 column to 3 different ones), instead of finally creating a view in the SQL Server where we do the transformation.

    Feedback written as a recommendation from case…

    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. For timestamp columns, provide more timezones in addition to local and GMT

    The timestamp columns in Pi Integrator only have "local" and "GMT" options. If possible, it would be useful to add additional timezones which would return the timestamp converted to that timezone.

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