PI System Roadmap
Release Schedule: PI OLEDB Enterprise (View all)
2018-12-10
ReleaseRelease
Service PackService Pack
Current Release
 
Product
Version
Date
Description
Features
Service Pack
PI OLEDB Enterprise 2017 R2
1.4.3.17
2017-12
PI OLEDB Enterprise exposes time series data and asset information in a relational view, through SQL queries.
Bug fixes
Previous Releases
 
Product
Version
Date
Description
Features
Release
PI OLEDB Enterprise 2016 R2
1.4.2.95
2016-10

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.
Release
PI OLEDB Enterprise 2016
1.4.1.63
2016-04
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.
Release
PI OLEDB Enterprise 2012
1.3.1.5
2013-01
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.
Release
PI OLEDB Enterprise 2010 R3
1.2
2012-02
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.
Release
PI OLEDB Enterprise 2010 R2
1.1
2011-04
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".
Release
PI OLEDB Enterprise 2010
1.0
2010-08
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 herein.