Home > Products > Archiving > OPC Client for ODBC

Overview

Event Management

Archiving

Desktop Tools

Data Management

Device Drivers (OPC Servers)

Ordering Information

Downloads


Click below to begin your MatrikonOPC Driver Search.

OPC Client for ODBC

The Matrikon OPC Client for ODBC enables any ODBC-compliant database to exchange process data with an OPC Server. This application uses standard SQL queries. There are two main uses for the OPC Client for ODBC:

Archive process values from an OPC server to an ODBC database. An ODBC
    database can become a miniature process historian, and this application can place
    the data in permanent storage. Any trending or analysis tool can then be used to
    retrieve the data from the ODBC database.

Populate an OPC Server with data from an ODBC database. For example, gas
chromatograph data, stored in a database, can be written into an OPC server by
way of this application.


Get the Product Download: OPC Client for ODBC Manual

Other features include:

Support for ODBC compliant databases such as Microsoft Access, Microsoft SQL,
Oracle, Sybase, etc.

Communication between multiple ODBC databases with multiple
OPC servers, including concurrent sessions with the same server

SQL-based query engine that allows both reading and writing

Real-time editor that allows query changes even while the application is running

Point-and-click interface supporting drag and drop operation

Support for transaction-based updates

Runs as a Windows NT Service

Supports stored procedures

XML configuration file

Supported OPC Specifications:

OPC DA (OPC Data Access) 1.0a

OPC DA (OPC Data Access) 2.0a

OPC DA (OPC Data Access) 2.05a

OPC DA (OPC Data Access) 3.0a