PI SQL Client OLEDB 4.2

PI SQL Client OLEDB is an OLE DB provider that enables standards-based SQL access to PI System data. Through the PI SQL Data Access Server, it exposes time-series measurements, asset metadata, and event/event-frame information as relational tables and views, making operational data easy to query from reporting tools and custom applications that support OLE DB.

Key capabilities:

• SQL-based queries over PI data, including filtering, joins, aggregations, and parameterized queries
• Access to historical and near-real-time values, asset hierarchies, and events via table-like schemas
• Designed for Windows and compatible with common OLE DB consumers (for example, Excel, SSRS, and BI tools)
• Centralized server-side administration and enterprise-grade security via the data access layer
• Optimized for read-focused analytics, reporting, and integration workflows

Typical uses include building reports and dashboards, combining PI data with relational datasets, and enabling ad hoc analysis without specialized PI APIs.

PI SQL Client OLEDB is developed by OSIsoft, LLC.. The most popular versions of this product among our users are: 4.0 and 4.2.