Principles of operation

AVEVA Adapter for RDBMS (Relational Database Management System) is a data-collection component that collects time-series data and sends it to configured Open Message Format (OMF) endpoints in AVEVA Cloud Services or PI Servers. The time-series data can originate from any relational database management system that supports Open Database Connectivity (ODBC) drivers.

The RDBMS adapter's operations focus on data collection and stream creation.

• Adapter configuration

  Determine how to configure your RDBMS adapter.

• Data connection

  Review where the RDBMS adapter can retrieve data from.

• Data collection

  Review how the RDBMS adapter collects data.

• Stream creation

  Explore stream creation and its properties.

• Failover

  Explore how failover keeps your systems resilient and responsive—automatically switching to a backup so your data never stops flowing

Adapter installation

You can install the adapter with a download kit that you can obtain from the Customer Portal. You can install the adapter on devices running either Windows or Linux operating systems.

Adapter configuration

Using the REST API, you can configure all functions of the adapter. The configurations are stored in JSON files. For data ingress, you must define an adapter component in the system components configuration for each device to which the adapter will connect. You configure each adapter component with the connection information for the device and the data to collect. For data egress, you must specify destinations for the data, including security for the outgoing connection. Additional configurations are available to egress health and diagnostics data, add buffering configuration to protect against data loss, and record logging information for troubleshooting purposes.

After you have configured the adapter and it is sending data, you can use administration functions to manage the adapter or individual ingress components of the adapter. Health and diagnostics functions monitor the status of connected devices, adapter system functions, the number of active data streams, the rate of data ingress, the rate of errors, and the rate of data egress.

EdgeCmd utility

We also provide the EdgeCmd utility, a proprietary command line tool to configure and administer an adapter on both Linux and Windows operating systems. EdgeCmd utility is installed separately from the adapter.

The EdgeCmd utility manual offers a summary of how to set up and manage AVEVA adapters on both Linux and Windows platforms through command line options.