PI JDBC Driver Overview
PI JDBC Driver is a Java Database Connectivity driver that provides robust data access to the PI System through SQL queries. PI JDBC Driver offers much of the same functionality as the PI OLEDB Enterprise Provider, and is also backward compatible with the behavior of the classic PI OLEDB Provider.
PI JDBC is a type 1 JDBC driver (bridge) that uses the PI OLEDB Enterprise Provider to connect to the PI Server and execute SQL queries. Communication from PI JDBC to PI OLEDB Enterprise includes the PI SQL Data Access Server (PI SQL DAS) as a gateway, which provides secure network communication (HTTPS). PI OLEDB Enterprise Provider and PI SQL DAS run on Windows, whereas PI JDBC Driver is supported on both 32-bit and 64-bit Windows and Linux operating systems. PI JDBC Driver is based on the JDBC 4.0 API (Java Platform SE 6) specification.