PI OLEDB Enterprise 2010 R2 Released: Access AF Data with SQL

OSIsoft has announced the release of PI OLEDB Enterprise 2010 R2—a significant milestone in simplifying access to PI Asset Framework (AF) data. If you work with PI System data and have been seeking easier, programmatic integration of AF metadata with your organization's business intelligence or reporting tools, this release is for you.

What Is PI OLEDB Enterprise?

PI OLEDB Enterprise is an OLE DB data provider that creates a bridge between your PI AF metadata and a wide range of data consumers that support SQL access.

Key Features:

• Read-Only Access: PI OLEDB Enterprise enables secure, read-only access to AF Server data.
• AF Asset Namespaces: Only approved AF Asset namespaces are exposed, ensuring that your mission-critical configuration remains protected.
• PI Data Access: Since AF Attributes can reference PI Points, users can access real-time and historical PI Server data via the same interface.
• Relational View: The product exposes AF databases and their structure in a familiar, relational format—empowering you to use SQL queries for rapid, scalable data extraction and reporting.

Why Use PI OLEDB Enterprise?

• Simplified Integration: You can now use standard SQL tools and skills to access and analyze your PI AF metadata.
• Business Intelligence Compatibility: Easily connect AF data to Excel, Power BI, or other OLE DB/ODBC-compatible BI solutions.
• Centralized Data Access: Bridge your PI Server infrastructure with enterprise data warehouses and reporting systems without bespoke development.

Getting Started

To download PI OLEDB Enterprise 2010 R2, visit the OSIsoft vCampus Download Center and select PI Data Access from the dropdown list.

For more in-depth insights, be sure to check out Steve Pilon's detailed blog post on the release (link may require OSIsoft vCampus access).

Ready to streamline your PI AF data access? Try the new PI OLEDB Enterprise 2010 R2 and unlock seamless reporting and analysis with the power of SQL.