The classic PI OLEDB Provider, based on the Microsoft Object Linking and Embedding Database (OLE DB) standard, allows relational queries to the PI Server using SQL queries.

Please note there are no more planned releases for the classic PI OLEDB Provider; it is recommended to use PI OLEDB Enterprise, which provides access to PI System data through the PI Asset Framework (AF).

Release Announcements

	21-Feb-2012	PI Data Access 2010 R3 suite of products is released
	05-Jan-2012	PI OLEDB Provider 2010 R3 (3.3.1.2) is released
	14-Feb-2011	PI OLEDB Provider 3.3.0.1a is released
	02-Mar-2010	PI OLEDB 4.0 Beta 2 is available
	13-Jul-2009	PI OLEDB Provider 3.3.0.1 is released
	17-Apr-2008	PI OLEDB Provider 3.2.2.10 is released
	28-Jan-2008	PI OLEDB Provider 3.2.2.7 is released
	23-Mar-2007	PI OLEDB Provider 3.2.1.1 is released
	25-Jan-2007	PI OLEDB Provider 3.2.0.11 (PR1) is released
	19-Apr-2006	White paper on Utilizing MS SQL Server Tools (DTS and SSIS) for Data Exchange between PI and RDBMS is available

More...

Support Bulletins

	31-Jan-2012	Upgrading from PI OLEDB Provider 3.3.0.1 to 2010 R3 (3.3.1.2) causes PI Tag search and PI DataLink add-in problems
	18-Mar-2010	PI Products and Windows 7 Compatibility
	30-Apr-2008	Oracle 11g no longer supports PI OLEDB or PI ODBC with Generic Connectivity
	23-Apr-2008	Batch queries may return incorrect results when using PI OLEDB 3.2.2.7
	04-Oct-2006	PI SDK 1.3.3.304 installation problem with Windows 2003 Server x64

More...

KB Articles

	10-Jan-2013	PI OLEDB: Using Strings in SQL pass-through queries
	31-Oct-2012	How to replace a specific archive value over a given time range
	31-Oct-2012	PI OLEDB Provider behavior when used with PISDK Buffering
	08-Jun-2012	How to use PI OLEDB Provider to query for PI data in Excel
	07-Jun-2012	How to use the PI DataLink PITimeFilter function in PI OLEDB

More...

Version	3.3.1.02
Release Date	05-Jan-2012

Information

Home

Overview

System Requirements

Additional resources may be available after sign in.

Development Info

Known Issues

Site Map