PI SQL Client OLEDB R2

PI SQL Client OLEDB R2 by OSIsoft, LLC. is an OLE DB provider that gives SQL-based access to PI System data. It connects through PI SQL Data Access Server to present a relational view of PI Asset Framework (AF) elements and attributes, Event Frames, and PI Data Archive time-series data. This lets you query operational data with standard SQL, making it easy to integrate PI System information into reporting, analytics, and ETL workflows without writing custom code.

Key capabilities:

• SQL access to PI AF, Event Frames, and PI Data Archive (snapshots, sampled, interpolated, and summary data)
• Time-aware queries with support for time ranges and interval-based retrieval
• Works with any OLE DB–compatible tool (for example, Microsoft Excel, SQL Server linked servers, SSIS, and custom applications)
• Uses PI System security and Windows integrated authentication via PI SQL Data Access Server
• Consistent, read-oriented access to operational data for reporting and analytics
• Designed for blending PI System data with enterprise relational data sources

PI SQL Client OLEDB R2 is part of the PI SQL Client suite, providing a familiar SQL interface to operational data so teams can build reports, dashboards, and data pipelines quickly and reliably. It requires a connection to PI SQL Data Access Server and appropriate access to PI Asset Framework and PI Data Archive.

PI SQL Client OLEDB R2 is developed by OSIsoft, LLC.. The most popular version of this product among our users is 4.1.