OPC Client for ODBC

It's now easier than ever to log OPC data into SQL and other ODBC-compatible databases
Manual Datasheet

OPC Client for ODBC

Logging OPC data to SQL and other ODBC-compliant databases has never been this easy

The OPC Client for ODBC from MatrikonOPC enables any ODBC-compliant database to exchange process data with an OPC Server. Users can log data from OPC to their database without any prior SQL experience

The OPC Client for ODBC has two main functions:

1 - Record process data from an OPC server into an ODBC database.
2 - Send data from an ODBC database to an OPC Server. For instance, you can transfer gas chromatograph data from a database into an OPC server using this tool.

The Matrikon OPC Client for ODBC interacts directly with databases on one end and your devices on the other. Using the standard OPC connectivity, this tool offers an easy way to transfer plant floor data into your relational database.

The Matrikon OPC Client for ODBC connects directly with databases on one end and your devices on the other. Using the standard OPC protocol, this tool offers an easy and straightforward way to transfer plant floor data into your relational database.

Easily link your ODBC database to your OPC Server with Matrikon OPC's Client for ODBC.

Effortlessly log process data and update your OPC Server with values from your database, no SQL knowledge required. Begin system integration now!
Contact Us

Storing historical data in a database is a common practice, and many database providers offer access through the Open Database Connectivity (ODBC) standard.

Features

  • Compatible with ODBC databases like Microsoft Access, SQL Server, Oracle, and Sybase.
  • Configure the software dynamically while it’s running.
  • Execute SQL commands directly from the user interface for easier testing and setup.
  • Advanced users can utilize custom ODBC queries.
  • Operates quietly in the background as a Windows NT Service.
  • Includes a user-friendly XML configuration file.
  • Combine SQL knowledge with OPC variable syntax to set up detailed OPC-database interactions.

Benefits

Ideal for recording data to or retrieving data from a relational database.
One software solution to set up.
Works with any OPC Server.
User-friendly with easy-to-use drop-down lists.

Supported OPC

OPC DA (OPC Data Access) 1.0
OPC DA (OPC Data Access) 2.0
OPC DA (OPC Data Access) 2.05a
OPC DA (OPC Data Access) 3.0

Common Uses

  • Store alarm data in a database for review.
  • Transfer data from any OPC Server into the database.
  • Import gas chromatograph data from a database into an OPC server using this application.

ODBC Client for OPC Data

The ODBC Client is suitable for any application that needs DA OPC data stored in an ODBC database. Industries that can benefit from this include Manufacturing, Oil and Gas, and Pulp and Paper.