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 the ability to export/import views via automation or command line

    The current feature in PII4BA 2020 to export/import views requires the user to go into the UI, connect to the target AF Server/DB and then import the (json) file in question.

    It would be ideal to be able to perform the same operation through a command line or REST API using arguments to select the AF Server/DB or other required configuration. This would greatly ease the operation of bulk loads and make the whole process more seamless to the end user.

    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

    1 comment  ·  PI Integrator for Business Analytics  ·  Flag idea as inappropriate…  ·  Admin →
  2. Have the option with streaming views to only send updated values to the target

    In PI Integrator for Business Analytics 2020 Patch 1 (2.3.0.426) streaming views has the option to send messages when any selected key values are updated, but this publishes the complete message to the target, including attributes which have not updated.

    It should be possible with the "any" message trigger to only send the updated values to the publish target. This option to only send updated data could be listed as one of the Value Options when configuring the message content.

    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 →
  3. Support to Azure SQL Databases

    Support PI Integrators under Azure SQL Databases (PaaS).

    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 Esri ArcGIS  ·  Flag idea as inappropriate…  ·  Admin →
  4. Add a toggleable switch for text file targets to allow the ID Column

    With previous versions when you would create a text file view, the first column would be an index/ID column numbering each row. With upgrade to PI Integrator for Business Analytics 2020 the column is no longer there as a part of the enhancements released in this version.

    One of the users of a view has a system already configured to account for the ID column and has requested that I put the ID column back in one of my views.

    For this use case, it would be useful to have the ID column be toggleable when I configure the text…

    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 →
  5. Allow connecting to Read-only Domain Controller

    As a IT administrator, I would like to be able to configure the PI Integrator for Business Analytics to allow connection to my read-only domain controllers (RODC) so that the PI Integrator for Business Analytics is in line with the Windows Active Directory best practices that we employ for other applications in our organization. Currently, the PI Integrator for Business Analytics will use DNS queries based on its own server's domain to determine to which DCs it should connect, and this returns writeable DCs.

    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 →
  6. Azure IoT Hub: Allow specifying contentType and contentEncoding in the message system properties

    Certain data applications, such as Azure Blob storage, require the contentType and contentEncoding to be specified within the message header. In order to use these applications, the PI Integrator should allow the two to be configurable during target creation.
    Reference link: https://docs.microsoft.com/en-us/azure/iot-hub/iot-hub-devguide-routing-query-syntax#system-properties

    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 →
  7. Support ESRI ArcGIS 10.8.1

    Please update testing to include support for ESRI Arc GIS 10.8.1 which was released in July 2020

    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 Esri ArcGIS  ·  Flag idea as inappropriate…  ·  Admin →
  8. Allow a custom column in PI Integrator UI My Views page

    Allow a custom column in PI Integrator UI My Views page for notes/comments, such as on how we intend to use the 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 →
  9. 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 →
  10. 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 →
  11. Bypass Certificate Prechecks for PI Integrator Upgrade

    Similar to PI Web API certificate feedback recently implemented in PI Vision 2020.

    If PI Integrator is currently using a 3rd party certificate and is upgraded- have installer bypass certificate prechecks and continue to use the same certificate with the upgrade. Some customers have restrictions on the servers where we need to install the SSL certificates, that make it impossible to verify the validity (e.g. no access to revocation servers).
    The certificate is accepted by clients as those have different authorisations.

    I would like to optionally bypass the certificate checks in the PI Integrator installer to allow using the same…

    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  ·  Installation  ·  Flag idea as inappropriate…  ·  Admin →
  12. 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 →
  13. Improve source AF migration/rename procedure for PI Integrator for Business Analytics

    current procedure <What are the steps to point the PI Integrator to a new AF server for the element and attribute data that it publishes in views?> requires exporting/importing and republishing every single view, which is tremendous amount of work. On top of this, all existing data tables are dropped and re-created. Please provide a utility or an easy way to accomplish it.

    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 →
  14. 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 →
  15. Allow csv file rerun in PI Integrator for Business Analytics

    Allow PI Integrator for Business Analytics to rerun a view that outputs to a csv file. Currently the "Update Data" button is grayed out.

    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 →
  16. 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 →
  17. Allow PI Integrator to create a new file per publication in Amazon S3

    As a PI Integrator user, I'd like PI Integrator to create a new file per publication in Amazon S3. Currently there is a workaround with Maximum Rows/Objects option in target configuration, but it is not straightforward and cumbersome.

    12 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 →
  18. Configuration improvements

    Post configuration (for this installation we're only using manually configured services/layers), you must walk through the wizard again to see how the data store / service / layer might be defined in GeoEvent Server. For support in these conditions, it would be helpful on the layer pages under ArcGIS tab to see how the layer is actually configured.

    In addition, once created, it is not possible to change descriptions of services / layers. I could potentially use these fields to provide links to the above in external documentation, but cannot edit it.

    Perhaps there are ways to do this, but…

    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 Esri ArcGIS  ·  Flag idea as inappropriate…  ·  Admin →
  19. 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 →
  20. 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 →
  • 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