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.
-
Allow publish to Azure data lake store gen. 2
Allow PI intergrator for Business Analytics to publish to Azure data lake store gen. 2.
63 votesDevelopment on an ADLS Gen2 writer for the PI Integrator for BA is well underway! Thank you all for your patience in waiting for this release. I will update this item’s status once we have the release available.
For anyone who has not yet seen Microsoft’s recent announcement, they have provided guidance and timelines around the Gen1 to Gen2 switch, with Gen1 having an end-of-life of Feb 2024 (at time of writing):
https://azure.microsoft.com/en-us/updates/action-required-switch-to-azure-data-lake-storage-gen2-by-29-february-2024/ -
Allow to include open Event Frames
The integrator only includes EventFrames that are closed (have end time). That is not included in the documentation, so a major issue for me now.
The reasoning is that an open EF may not have all data or correct data. I would prefer to let the user decide on that and allow to include open eventframes. After all we can filter out the open ones using row filters.I planned to use the integrator to get rid of OLEDB Enterprise. Now it turns out i cannot reach all my data. Looking seriously into returning the license.
The reasoning is
55 votes -
Expose PI Integrator Counters, Performance, and Status in Perfmon Counters
Add product specific Perfmon counters for Pi4BA, including specific counters for the Integrator Service, the Data Sync, and Worker processes, beyond the standard windows process data - Such as # active sessions, # views, # of AF syncs, number of views processed per worker, view status.
There was a previous feedback request that was marked as completed, as now some of this info is currently stored in the statistics table, but there is a separate table by view GUID, and a row of data stored per run per view - and the "stats" column seems to be encoded, making programatic…
47 votes -
Include Annotations of Event Frames into Event Views
Customer would like to do Batch reports in BI Tool and Annotations contain important information, like Operator comments, reasons for changed values etc.
47 votes -
Provide Bulk Column Configuration
The current method for adding columns and changing their Data Content type (value, average, min, max, etc) is clunky and time consuming. You can only change (or add) one column at a time, and you have to wait for the data view to refresh after each change.
Ideally, I would like to have the ability to switch from the default UI (Column headers with real data) to a configuration UI that has a more tabular configuraiton layout or a layout similar to AF.
I want to be able to select multiple data items and change them all to be "Average"…
46 votes
Joy Wang
responded
Correction to earlier comment made by Matt Zieger: PI Integrator for Business Analytics 2018 does not support bulk column configuration. This idea is currently not planned. Feel free to contact me if you’d like to discuss more. Thank you!
-
Automatically remove data from continuous views
As an engineer using PI View or SQL writers for a report, I would like option to remove data older than a certain cutoff. For example, a continuous view is used to generate data for a report on the last 8 hours. Data older than that are no longer needed for the report and should be removed to avoid unnecessarily large tables.
One workaround with Text and Hadoop writers is the Append Timestamp option, but there's no ability to remove data from other targets.
41 votesFor supporters of this idea, what is the downstream client tool that consumes the data prepared by the PI Integrator? Is the concern about disk space or how to only display data for a specified time range?
For the former, this seems to be a different type of “rolling” reporting use case that we do not currently have a solution for. In the mean time, as Rory mentioned below, a stored procedure on SQL would work if this idea is intended for SQL writers.
For the latter, is it possible to create “rolling timespans” for your graphs, reports, tables, etc.? For example, here’s a video on how to create calculated measures for a table based on last day or month of data: youtube.com/watch?v=NevFWL2JoMU
-
Organize views in Integrator User Interface
We would like a better way to manage views in the Integrator User Interface. For example, we would like the views to be able to be sorted into a folder structure. With many views it is hard to properly manage them without something to sort them.
36 votes -
Increase 100k stream limit
As an engineer looking to leverage hundreds of thousands of tags for BI, I would like to use a single integrator instance to publish all of the data rather than installing multiple instances on different nodes.
34 votes -
Option to delete target data table when view is deleted
When a PI View is deleted from the Integrator User Interface, the Publication Metadata and target data tables are both deleted for that view. For a view with a non-PI View target such as a SQL target, however, only the Publication Metadata table is deleted. The Integrator will no longer consider that view name to be reserved after deleting the view, but using that name again for a new view with the same target requires us to manually delete the target table if there is a change to the shape or we do not want to append to the existing…
33 votesJoy Wang
responded
Correction to earlier comment by Matt Ziegler: This idea was not fulfilled in PI Integrator for Business Analytics 2018 release. This idea is currently not planned for a future release. If you have a use case and desired behavior for a particular writer and want to discuss further, please comment below or email me. Thank you!
-
Sign up for updates on the PI AF Server for new event frames
Currently, the PI Integrator for BA 2018 will add rows for event frames ending within the scheduled update time range. It would be better if the PI Integrator signed up for updates on the database and gets a list of all new or modified event frames to handle the cases where event frames are closed with an end time in the past that is not covered by the run period anymore.
28 votes -
Have programmatic API and framework kit for Integrators
Many partners we work with would like to be able to configure views and data output from PI Integrator for BA directly from within their Analytics tools. This could also allow for better integration with third party analytics tools and open an OEM/Reseller market for OSIsoft partners.
27 votes -
PI to Maximo integration
When PI is used to gather equipment sensor information but Maximo is used for asset management, it would be helpful to have a simple way to get equipment information out of PI and into Maximo. This would be useful for scheduling preventative maintenance, among other things.
26 votesJoy Wang
responded
Thanks for the feedback and ideas so far! At this time, we have commitments and another planned release for PI Integrator for Business Analytics at the end of 2018. We will revisit this idea again after the next release. Please feel free to contact me with any questions or additional feedback.
-
Allow for capture of late-arriving in-order data by the PI Integrator
Currently the PI Integrator for BA captures out-of-order data and edits of existing data in the archive through PI Integrator sync service. However, it does not capture late arriving data which may happen as a result of network outages between a PI Interface/Connector and the PI Data Archive. For these situations, the PI Integrator publishes null values unless a key column attribute is used to generate the timestamps. Ideally changes should be captured for late arriving data so that data is automatically updated from the PI Integrator when it eventually arrives.
25 votes -
PI Integrator end point for MQTT
Support an end point for MQTT
25 votes -
Allow "PI View" target to be disabled
I would like the option to remove or disable the "PI View" target on the Data Warehouse, Azure, and SAP Hana editions.
In these editions, the PIIntegratorDB is expected to remain small because the data is published out to a separate database. The problem, however, is that users may accidentally publish very large views to the "PI View" target instead of, for example, Azure Data Lake. This can fill up drive space on the SQL server and prevent the Integrator (or other services that rely on that SQL server) from running.
For these editions, most users will not be publishing…
25 votes -
Please have PI Integrator for Business Analytics supports high availability (HA)
As a user of PI Integrator for Business Analytics, I'd like to have it support high availability (HA).
24 votesPlease specify what kind of high availability is requested. For PI Integrator for BA to run in a highly available fashion?
To support other applications that are highly available? If so, which ones?
-
Add support for multiple events with same timestamp in PI Integrator for BA
The Integrator for BA appears to be a great fit for exporting event-based data such as Batch Interface Messages to external systems. Interpolation doesn’t apply in these cases so we can use a tag as the ‘Key’ in value mode selection.
However, there are cases where a tag can have multiple entries at a given timestamp (e.g. EMDVB Recipe Parameter Downloads) and the current behavior is to only include the first value in the output view. This approach results in missing data and makes the integrator unusable in these cases.
Ideally the view would return all records (as per PI…23 votes -
Allow binding of a custom SSL certificate after installation of PI Integrator for Esri ArcGIS
As an administrator for the PI Integrator for Esri ArcGIS 2017, I want to be able to change the SSL certificate bound to the application through an installer wizard. Currently, the only option is to uninstall and reinstall the application, or manually bind the certificate using the command line netsh.
23 votes -
Expose PI Integrator view statuses
Customers who plan to have a significant number of views need a better way to manage the status of their views other than periodically checking the PI Integrator UI.
There should be a way to obtain view statuses through other programs (custom or PI), so that users can receive alerts if a view goes into an error status.
22 votes -
Support SAML authentication
The PI Integrator for Esri ArcGIS does not support SAML authentication through Portal. Support for SAML authentication would allow PI Integrator users to configure their own Identity Provider.
19 votes
- Don't see your idea?