MatrikonOPC ODBC Server for OPC

Transparently access your OPC enabled Historian with any ODBC reporting Tool.



The MatrikonOPC ODBC Server for OPC enables users to leverage the power of ODBC analysis and reporting tools for use with their OPC Historical data. The ODBC Server for OPC turns any process historian into an ODBC compliant database with no OPC Client required. Users can use the web based reporting tools that they are comfortable with, and simply install the MatrikonOPC ODBC Server for OPC for instant access to their data.

MatrikonOPC ODBC Server for OPC is for anyone using Crystal Reports or other popular ODBC-based applications. The true power of the MatrikonOPC ODBC Server for OPC lies in the fact that it is designed to provide users instant access to their OPC data in their historian rather than having to duplicate the data in a relational database.

The MatrikonOPC ODBC Server for OPC enables ODBC access to any OPC HDA (Historical Data Access) Server and is fully compliant to Microsoft’s ODBC 3.5 specification. Each Server is configured to act as a database in the Matrikon ODBC Server for OPC, with a unique database name. This unique database name is used in "ODBC Data Source Administrator" to specify the desired data source for the configured DSN.

Users can gain instant access to their IP21, Pi, PHD, or other OPC process historian using their OPC Server and the Matrikon ODBC Server for OPC.

Key features of the MatrikonOPC ODBC Server for OPC are:

  • Built-in ability to read large amounts of raw data
  • User friendly ability to specify data and time parameters for record search.
  • Users can read conduct queries for large chunks of data, or target a
        specific entry.
  • Read aggregates such as averages, maximum’s, minimum’s, etc.
  • Easily write new data into your historian
  • Enables users to replace or update existing data within their historian
  • MatrikonOPC ODBC Server for OPC - Architecture Diagram