OPC Data Logging

What is OPC Data Logging?

Using the OPC DataHub you can write data from any OPC Server to any ODBC compliant database such as Access, SQL Server, Oracle or MySQL. You can also read data from an ODBC database and write it out to any number of different OPC Servers or Clients.

Why use OPC Data Logging?

• Write data from any OPC Server to any ODBC database for audit trail, archiving or analysis.
• Stored OPC data can be accessed by any ODBC client application for trending, reporting and relational analysis.
• Read data from ODBC databases and send it out as input to your process control or management systems.
• Log process data to a CSV or text file to create production reports or as a way to transfer data to other systems.

Features of the OPC to ODBC support

• A step-by-step interface guides you through the process of:
• Choosing which database to connect to.
• Choosing an existing database table, or creating a new table.
• Specifying which data items get written to which columns in the table.
• Defining a trigger event and conditons to control when the data is written to the database.
• The OPC server and ODBC database can be on the same computer or connected over a network. The OPC DataHub makes it easy for you to tunnel your data to a networked database server, without having to deal with DCOM problems and different permissions on the two machines.
• You can combine data from other sources, such as Excel spreadsheets and include this in the data you write to the database.
• The DataHub will automatically reconnect if the link to the database is interrupted for any reason.

Supported Databases

• Microsoft Access
• Microsoft SQL Server
• Oracle Database
• MySQL Server
• Sybase
• TimesTen
• FileMaker
• Any other ODBC compliant database