System requirements

AVEVA Adapter for RDBMS is supported on a variety of platforms and processors. Install kits are available for the following platforms:

Alternatively, you can use tar.gz files with binaries to build your own custom installers or containers for Linux. For more information on installing the adapter with Docker containers, see Installation using Docker.

PI Web API compatibility

This version of AVEVA Adapter for RDBMS is compatible with PI Web API and later.

Data connectivity

When collecting data through Open Database Connectivity (ODBC), AVEVA Adapter for RDBMS requires that the appropriate ODBC driver for your data source is properly installed and configured. For more information on ODBC drivers, refer to Microsoft's ODBC Programmers Reference and the manual for the ODBC driver you are using.

When collecting data from a SQL Server, additional driver installation is not necessary.

The following ODBC drivers have been tested and work with this adapter. This is not a comprehensive list of ODBC drivers that work with this adapter. Most recent ODBC drivers should work, but it is not guaranteed.

• Microsoft ODBC Driver for SQL Server Version 18.5.2.1

• MariaDB Connector/ODBC 3.2.7

• MySQL Connector/ODBC Version 9.5

• Oracle Instant Client ODBC

  • Microsoft WIndows 23.9.0.25.07

  • Linux x86-64 (64-bit) 23.26.0.0.0

The following versions of SQL Server have been tested and work with this adapter. Again, this is not a comprehensive list. Most recent SQL Server versions should work, but it is not guaranteed.

• Microsoft SQL Server 2022

• Microsoft SQL Server 2019

  Note: AVEVA Adapter for RDBMS supports 64-bit DSN's only, 32-bit DSN's are not supported.

Performance metrics

A wide range of Linux and Windows based devices support AVEVA adapters, from small single board computers to large servers. Stream count and event throughput vary based on the device's hardware specification.

Performance guidelines for AVEVA adapters when running on typical small and large devices are as follows:

• Small Devices - 4 Core CPU, 4 GB RAM (Raspberry Pi 4B equivalent). 10k events/sec, 10k streams total

• Large Devices - 4 Core CPU, 8 GB RAM. 50k events/sec, 50k streams total

Actual performance of AVEVA adapters vary depending on different factors, such as the performance of data source, network latency, and hardware resource consumption by other applications on the device. We recommend solid state storage on the device to improve the performance, robustness, and reliability of the AVEVA adapter data buffering mechanism.