PI ODBC Client Overview

The PI ODBC Driver is used to bring process data into any ODBC-compliant client application.

Open Database Connectivity (ODBC) is Microsoft's implementation of the SQL Access Group's call level interface standard, with some enhancements. Relational database vendors following this standard can be assured that any standard ODBC client applications can access their data.

The PI ODBC Driver is especially useful for applications that combine PI System data with data from other sources, such as cost accounting or laboratory systems. PI ODBC supports Level 1 compliance to the ODBC API, which allows client applications to browse such catalog information as table and column names. The ODBC standard also specifies levels of compliance for SQL processing: OSI Software implements the Core SQL Grammar.

This product is not related to the features of PI ProcessBook (Version 1.2 or later), which uses other vendors' ODBC drivers to access and display data from foreign databases.

The PI ODBC Driver is part of the Data Access (DA) add-on license, which also includes the PI OPC HDA Server, and the PI OLEDB Provider. It is not available separately.