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.

How can we improve PI Integrators?

(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. 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.

    1 vote
    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. Allow the user to customize the decimal separator

    Currently, the only available decimal separator is the period (.). In some cases, the customer may want to use other decimal separators such as the comma (,). It would make sense for the decimal separator to follow the convention of the region and language selected in the UI, or have an option in the menu set it to something custom.

    1 vote
    Sign in Sign in with OSIsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  General  ·  Flag idea as inappropriate…  ·  Admin →
  3. Text file / ADLS Targets : Option to remove line number

    add an option to skip line numbers in the output files

    1 vote
    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. Text file / ADLS Targets : Split output files based on elementname 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

    1 vote
    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 →
  5. AzureSQL Target should not need access to the master database

    The AzureSQL Target should not need access to the master database

    Current version of PII4BA gives this error message:
    Ref the error message
    The server principal "sqluser" is not able to access the database
    "master" under the current security context.

    Microsoft's words:
    “Generally, non-administrator accounts do not need access to the master database”
    https://docs.microsoft.com/en-us/azure/sql-database/sql-database-manage-logins

    1 vote
    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 →
  6. Two way communication / write back to PI

    Write back to PI from the Integrator for Machine Learning. Currently we are writing back to Excel from Azure Machine Learning Service but would like to do this with less integrations.

    1 vote
    Sign in Sign in with OSIsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  General  ·  Flag idea as inappropriate…  ·  Admin →
  7. Allow multiple directories in Azure Data Lake Target

    As an integrator for Business Analytics user I would like to be able to choose which directory in Azure data lake my view is published to so that is is easier to manage and analyse data once it is there.

    Currently this is only possible through setting up additional targets, which is cumbersome.

    1 vote
    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. Implement Testing methodology for Microsoft Patches

    Implement Testing methodology for Microsoft Patches
    PI System owners need to ensure that their deployed systems both meet internal IT policies regarding recommended OS and other component recommended and critical patches, and that their PI applications are not adversely affected by these patches.

    Consider a testing methodology similar to what PI AF employs which is currently to automatically monthly test all critical and recommended patches against the currently released application version.

    1 vote
    Sign in Sign in with OSIsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  General  ·  Flag idea as inappropriate…  ·  Admin →
  9. Provide more detailed error logging

    Error message logs sometimes are not detailed enough to properly troubleshoot. The customer would like to increase logging available in order to get more insight as to what is going on.

    One example - the PI Integrator for BA does not publish any message when there is a permissions/access issue to output data to a Kafka Topic.

    1 vote
    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 →
  10. Ability to use a shape between different AF servers and databases

    As an Integrator user with multiple AF servers and databases organizing my data, I would like the ability to use a shape from a view pointed towards AF Server 1 to populate a new view for assets on AF Server 2 that match the shape. Currently, when I try the "Use a shape from a different view" option in the Integrator Designer, the asset shape clears as soon as I select a different server.

    1 vote
    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 →
  11. Send Notification When Publish Job Complete

    Not sure this would help with continuous jobs, but for large jobs that are scheduled to run one time (for example: publish last 2 years of history) it would be nice to be able to have PI Integrator send off a notification when the job is complete. In the administration section where you can create publish targets, you could add a section, notification targets, where you could define a group of people to send a notification to by email. In the email I could see it stating that the publish job is complete and maybe some high level stats, but…

    1 vote
    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. add Output format

    When PI outputs multiple TAGS data to the SQL database, the output table needs only three fields (TAGS, time, value).

    1 vote
    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. PI Integrator should add an AF property to all assets that it is monitoring

    We have a large team that builds and manages our PI system. I need a way to tell users an asset is used by PI Integrator for publishing data so they know not to delete or edit that asset. For our PI Server, we use custom PI Point attributes to track what systems use a given PI tag. It would be nice if we could do the same with AF properties to track which AF elements are used by PI Integrator.

    1 vote
    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. Maintain column order when adding attributes to view

    When you add a new attribute to a view, that column is placed at the end of the table. The column should be added in the correct placement like it would be if that attribute was added when the view was first created.

    1 vote
    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. Compress files written using file target

    I am using PI Integrator to write data to file and then importing the file into a system PI Integrator does not natively support. Since I have to copy files over the network to get them to my other system, it would be nice if PI Integrator compressed the files once publishing is complete.

    1 vote
    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. Automatic View removal after a publication

    Being be able to delete one View after the data is posted to the destination. The use case would be a one time needed data exportation to a database. This way the list of views will be better managed. There would be no need of waiting until the publication is performed.

    1 vote
    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. Add support for allowing the user to specify the file extension for ADLS

    Currently, it is not possible to set the file extension that is published to Azure Data Lake Store by the PI Integrator for Microsoft Azure. It is currently hardcoded to .txt format.

    The end user should have the option to choose which file format (txt /csv/etc) that is to be eventually published to ADLS.

    1 vote
    Sign in Sign in with OSIsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  18. Aggregate data across event frames

    As a PI admin using the integrator with event frames for reporting, I would like the integrator to calculate summaries across event frames. For example, I'm interested in the average value of an attribute from the beginning of one phase to the end of the operation, where the phase and operation events are generated by a batch interface.

    1 vote
    Sign in Sign in with OSIsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  General  ·  Flag idea as inappropriate…  ·  Admin →
  19. Limit historical data retrieval for new elements

    As a PI admin working with the integrator, I would like to be able to limit the amount of data returned for new elements added to existing views. This avoids the situation where a long-running view is unintentionally slowed when the integrator backfills data for the new element over the whole history of the view.

    1 vote
    Sign in Sign in with OSIsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  General  ·  Flag idea as inappropriate…  ·  Admin →
  20. Amazon Redshift publication target

    Add an Amazon Redshift publication target. In talking with some customers, some have decided to go with this data warehouse service. Right now some are trying to use the flat file target as an intermediate before feeding it to Amazon Redshift.

    1 vote
    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
COMPLETED