PI SQL Client ODBC R2

PI SQL Client ODBC R2 is an ODBC-compliant driver that enables standards-based SQL access to PI System data. Through the PI SQL Data Access Server, it presents PI Asset Framework and PI Data Archive information as relational tables and views, allowing you to query time-series measurements and asset metadata with familiar SQL. This makes it easy to connect BI, analytics, and ETL tools, join PI data with business data, and build dashboards or automated reports without custom integration.

Key capabilities:

• Standards-based ODBC driver for broad tool compatibility (32- and 64-bit)
• Optimized for time-series scenarios, including time filtering and windowed queries
• Schema and metadata discovery to browse available tables and views
• Supports parameterized queries and prepared statements for performance and security
• Works with common analytics, reporting, and data integration tools that support ODBC
• Centralized access via PI SQL Data Access Server with authentication and authorization managed by your PI environment

Typical requirements:

• A deployed PI SQL Data Access Server with connectivity to PI Asset Framework and/or PI Data Archive
• An ODBC-capable client environment; match driver bitness to your client application

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