PI ODBC Driver

PI ODBC Driver Overview

PI ODBC Driver is an ODBC 3.8 API-compliant driver that provides robust data access to the PI System through the use of SQL queries.

PI ODBC Driver uses the PI SQL Data Access Server (PI SQL DAS) as a gateway, which provides secure network communication (net.tcp and HTTPS) and executes the queries. PI SQL Data Access Server is available as a separate install Kit.

ODBC is a specification for a database application programming interface (API). This API is not dependent on any one database management system (DBMS) or operating system. The ODBC API is based on the Common Language Infrastructure (CLI) specifications from Open Group and ISO/IEC.

This version of PI ODBC supports connections and queries for:
  • PI Data Archive
  • PI AF Server
  • PI Integrator for Business Analytics
PI ODBC is part of the PI Developer Technologies suite of products, designed to support both the implementation of custom PI System applications and the integration of PI System data with other applications and business systems, such as Microsoft Office or SQL Server, Enterprise Resource Planning systems (ERPs), reporting and analytics platforms, web portals, geospatial and maintenance systems, and so on. The PI Developer Technologies suite covers a wide range of use cases in various environments, programming languages, operating systems and infrastructures.

For more information on other PI Developer Technologies products and about licensing these products in your environment, please contact your account manager.