PI JDBC Driver Overview

PI JDBC Driver is a JDBC 4.0 compliant driver that provides data access to the PI System through the use of SQL queries.

PI JDBC Driver uses the PI SQL Data Access Server (PI SQL DAS) as a gateway, which provides secure network communication (HTTPS) and executes the queries. PI SQL Data Access Server is required for PI JDBC Driver.

Java is a programming language that allows you to create platform independent software. This platform independence is made possible by the Java Runtime Environment (JRE), which handles Java code and makes it runnable on most operating systems. Typically, Java programming environment is chosen when there is a demand to run software on multiple platforms such as Linux, Windows, Mac OS, etc.

Java Database Connectivity (JDBC) is an API that is built into every JRE and defines how a client can access a database. For relational database access, Java applications should use JDBC.
This version of PI JDBC supports connections and queries for:

This version of PI JDBC supports connections and queries for:

• PI Data Archive
• PI AF Server
• PI Integrator for Business Analytics

PI JDBC Driver 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.