How can we improve the PI Server?

Use PI SQL Client OLEDB for PI Builder data imports

PI Builder has a few problems:
• It is specific to Excel.
• It does not store data in tables.
• Imported data is static and can become outdated easily, which can lead to frequent imports, the need to publish PI Builder edits soon after import, and the reluctance to save the results of a PI Builder import.

These problems would be solved if PI SQL Client OLEDB could query the same data as PI Builder and if PI Builder used PI SQL Client OLEDB for data imports.

This way, imported data would be stored in a query table. Query tables have all of the benefits of regular tables (data isolation, readable formulas, banded rows, etc.) and are also refreshable.

Rather than just being an edit publisher, PI Builder would also act as a query generator, which is easier than trying to modify the sample queries in PI SQL Commander Lite.

Lastly, by moving PI Builder's query functionality to PI SQL Client OLEDB, we reduce the amount of functionality that is specific to PI Builder. This should make it easier to make versions of PI Builder for other spreadsheet programs, such as LibreOffice Calc.

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

We’ll send you updates on this idea

Kenneth Barber shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
DECLINED  ·  AdminStephen Kwan (Product Manager, OSIsoft) responded  · 

As the name implies, PI Builder was envisioned to be used for building AF objects. Its chief goal is not for querying data. We would rather not blur the line between a (primarily) configuration tool vs. a data tool (for example, PI DataLink).


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

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