OPC Client for ODBC

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

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

There are two main uses for the OPC Client for ODBC:

Log process values from an OPC server to an 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

The MatrikonOPC Client for ODBC communicates natively with databases on one side while simultaneously communicating with all your devices on the other side. By using the de-facto open connectivity standard OPC, this connector provides a simple, easy to deploy method of moving plant floor data into your relational database

The MatrikonOPC Client for ODBC communicates natively with databases on one side while simultaneously communicating with all your devices on the other side. By using the de-facto open connectivity standard OPC, this connector provides a simple, easy to deploy method of moving plant floor data into your relational database

Typical Use Cases:

  • It can store alarm data in a database for analysis.
  • Data from any OPC Server can be written into the database through transactions
  • Gas chromatograph data, stored in a database, can be written into an OPC server by way of this application

 

Seamlessly connect your ODBC database with your OPC Server using MatrikonOPC's Client for ODBC

Log process data effortlessly and populate your OPC Server with database values—all without needing SQL expertise. Start integrating your systems today!
Contact Us

It is common practice to store historical data in a database management system. Many database vendors provide access to their databases using the Open Database Connectivity (ODBC) standard

Features

Support for ODBC compliant databases such as Microsoft Access, Microsoft SQL,
Oracle, Sybase, etc.
Software may be dynamically configured while online
SQL statements may be executed directly from the graphical user interface to aid in testing and configuration.
Advanced users will appreciate the powerful custom ODBC queries.
Can run silently in the background as a Windows NT Service
User-readable XML configuration file.
Leverage SQL knowledge along with the unique OPC variable syntax to
Create complex OPC-database communication

Benefits

Great for logging data to, or taking data from a relational database
Single piece of software to configure
Connects to any OPC Server
Completely user friendly, easy to use with 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

ODBC Client for OPC Data

The ODBC Client can be used for any application that requires DA OPC data to be stored in an ODBC database. Examples of industries which may benefit from ODBC Client include but are not limited to, Manufacturing, Oil and Gas, and Pulp and Paper