PI OLEDB Enterprise 2017 R2
PI OLEDB Enterprise exposes time series data and asset information in a relational view, through SQL queries.
PI OLEDB Enterprise 2016 R2
This release re-introduces dynamic transpose functions to the PI SQL Commander. The Commander can also fix custom transpose functions that have been invalided by AF edits. PI OLEDB Enterprise now supports the Location Traits in AF 2016 R2, and fixes an inefficiency when querying Event Frames with captured attribute values.
PI OLEDB Enterprise 2016
This release brings various performance enhancements as well as bug fixes.
This release brings various performance enhancements as well as bug fixes. This includes support for future data,and hidden and excluded attributes in AF 2.7.
PI OLEDB Enterprise 2012
This release introduces support for PI Event Frames.
This release aligns with the overall PI Server 2012 launch and provides overall performance enhancements and significant new functionality around PI Asset Framework and PI Event Frames.
PI OLEDB Enterprise 2010 R3
This release brings several significant performance enhancements, support for LEFT OUTER JOIN, as well as support for AF attribute searches and AF attribute value searches (without the need to traverse the AF element hierarchy).
This release brings several significant performance enhancements for both time series data access and asset metadata access. It also supports the LEFT OUTER JOIN statements, which is very useful for more sophisticated queries that combine asset metadata and time series data. Last but not least, it supports AF attribute searches and AF attribute value searches anywhere in the asset structure, without the need to traverse and reference AF elements from the hierarchy.
PI OLEDB Enterprise 2010 R2
This release provides performance enhancements as well as enhanced compatibility with Microsoft SQL Server Linked Server (in-process).
This release brings performance enhancements, including AF Attributes searches based on the Attribute values (as opposed to starting from the Element to perform an Attribute search). This version also features enhanced compatibility with the Microsoft SQL Server Linked Server technology and allows to run it "in-process".
PI OLEDB Enterprise 2010
This is the first release of PI OLEDB Enterprise, which exposes time series data and asset information in a relational view, through SQL queries.
This first release of the PI OLEDB Enteprise provider provides read-only access to asset metadata stored in the PI Asset Framework (AF), as well as data from PI Servers, since AF Attributes can be configured to reference PI points.
It exposes this information through a relational view of AF Databases, which is accessible through SQL queries.
Please note: All announced and anticipated software releases are subject
to change in both timing and content at the sole discretion of OSIsoft and neither
the information provided above, nor any other pronouncement should be construed
as a commitment by OSIsoft to deliver any specific feature or attribute at any specific
time. As such, the information provided here should not be used as a basis for purchasing
any software OSIsoft currently offers. All information contained herein is subject
to change at any time at OSIsoft’s sole discretion and is for informational purposes
only. OSIsoft does not warrant the accuracy or timeliness of the information contained