About AVEVA PI Developer Technologies

AVEVA PI Developer Technologies is a set of products designed to support the implementation of custom applications that work with the PI System. PI Developer Technologies also helps you integrate PI System data with other applications and business systems such as Microsoft Office or SQL Server, enterprise resource planning (ERP) systems, reporting and analytics platforms, web portals, geospatial, and maintenance systems, to name just a few examples.

PI Developer Technologies cover a wide range of use cases in various environments, programming languages, operating systems, and infrastructures. The different technologies in this product set include the following:

• AF SDK

  Provides comprehensive, high-performance, Windows-based .NET programmatic access to the PI System. AF SDK:

  • Has the best performance of all PI development technologies.

  • Has more available methods and options than any other technology.

    Is limited to Windows operating systems running .NET Framework.

• PI Web API

  Enables operating system and device-independent programmatic access to the PI System through a REST API, and is the recommended cross-platform offering for any operating system that is able to use a modern web browser such as Google Chrome, Mozilla Firefox, or Microsoft Edge. PI Web API:

  • Is not dependent on a specific operating system or programming language.

  • Has limited methods and options available compared with AF SDK.

• PI SQL Framework

  Makes the data on PI Server available for querying as if it was on a relational database. PI SQL Framework:

  • Is compatible with other systems that use Structured Query Language (SQL).

  • Has limited methods and options available compared with AF SDK (for example, setting security on assets and creating units of measure).

  • Is limited to read-only PI AF access (but can create and write to tags on your PI System).

There are more ways to access the PI System programmatically; however, the above three methods describe the vast majority of use cases.

You might also want to consider using PowerShell cmdlets to assist in the administration of Data Archive and PI Asset Framework servers. These can be used in a variety of ways to create scripts for commonly needed functionality or for bulk system management operations. See Powershell Tools for the PI System for more information.