PI SQL Client JDBC R2

PI SQL Client JDBC R2 is a JDBC driver that lets Java applications and JDBC‑compatible tools query PI System data using standard SQL. It connects to a PI SQL Data Access Server endpoint to expose time‑series events and asset context as relational tables and views, making operational data easy to integrate with analytics, reporting, and ETL workflows.

Key capabilities

• Standard JDBC interface for seamless use with Java apps and BI tools
• Read‑optimized access to time‑series data and asset/metadata views via SQL
• Support for prepared and parameterized queries, pagination patterns, and connection pooling
• Works with existing PI SQL Data Access Server deployments to centralize data access
• Designed for analytics, dashboards, ad‑hoc querying, and data integration

Typical use cases

• Building Java services that consume PI data without custom APIs
• Feeding BI/reporting platforms through JDBC
• ETL/ELT pipelines that join PI data with business data in relational workflows

Requirements and notes

• Requires network access and permissions to a compatible PI SQL Data Access Server
• Behavior, available schemas, and performance depend on server configuration and data volume
• Generally read‑only; writing to PI data typically uses other clients or APIs

This R2 release of the JDBC client emphasizes straightforward SQL access to operational data, helping teams reuse existing SQL skills and JDBC tooling to work with PI System information efficiently.

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