External interfaces

Introduction

External interfaces are used to read and write data from History. Different kinds of integration scenarios are main use case.

Vtrinlib is the most flexible interface and available as .NET client API. Other interfaces are built on top of Vtrinlib. VtrinLib is available also as REST API.

ODBC is a standard interface for databases, good alternative for maintenance and reporting.

OData API is good for doing calculations and analytics on top of History. It supports reading and writing timeseries data and reading structural data.

OPC UA Server implements standard interface to read and write data. Fits well with Vtrinlib and History.

OPC Classic Servers are widely used when legacy software should be integrated. Widely supported in the industry.

WSS Server API connections can be done with any standard WebSocket library compliant with RFC 6455.

Feature comparison

Feature comparison shows upper level view of functionalities available in each external interface. Vtrinlib, ODBC and OData are supported both in Windows and Linux, OPC Servers only in Windows. Classic OPC contains two servers OPC HDA Server and OPC DA Server and feature comparison is assuming both are used.

VtrinlibODBCOData APIOPC ClassicOPC UAWSS and REST
Reading classes and instances.YesYesYes 4)NoYesYes
Creating and updating classes and instancesYesYesYesNoYesYes
Reading time series dataYesYesYesYesYesYes
Writing time series dataYesYes 1)YesYes 2)YesYes
Reading current valuesYesYesYesYes 3)YesYes
Subscribing current valuesYesNoNoYes 3)YesYes
Writing current valuesYesYesYesYes 3)YesYes
  1. Writing time series data only available through UpdateHistory command class
  2. Writing time series data requires to change OPC HDA Server to connect using database disk directly not using wss-connection (from %APP_DATAPATH%\Config\OpcIniFles\RtdbOpcHdaServer.ini)
  3. Only from Tags/Variables, not from Equipment model
  4. Only classes with Name or Id property are visible