OPC to ODBC
What is OPC to ODBC?
The OPC DataHub enables any OPC Server to write data to a relational database such as Access, MS SQL Server, Oracle or any other ODBC compliant database. You can also read data from an ODBC database and use it as input to any number of different OPC Servers or Clients.
Why use OPC to ODBC?
- 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.
- Data from ODBC databases can be used as one of the inputs to your control applications.
Features of the OPC to ODBC support
- The OPC DataHub uses a powerful scripting language to read and write data to an ODBC application.
- Data conditioning can be applied before the data is written to the database.
- Scripts can be attached to specific data points, so that whenever the point value changes, a record is added to the database application.
- Writing to the database can also be triggered by an interval timer, an alarm condition or directly from operator input.
- Archiving of data can be scheduled for the end of day, or at shift change to record production data.
- Easy to follow code examples shows you how to write simple scripts using standard SQL queries.
- Scripts can both read and write data to the database application.
- The OPC server and ODBC database can be on the same computer or connected over a network. (If you encounter DCOM configuration problems while trying to connect to the remote OPC server, then you can use the OPC Tunnelling feature of the DataHub to quickly and easily avoid these problems.)
- The OPC DataHub can combine data from other sources, such as Excel spreadsheets and include this in the data written to the database.
Supported Databases
- Microsoft Access
- Oracle Database
- Sybase
|
- Microsoft SQL Server
- MySQL Server
- Any other ODBC compliant database
|
More Information
|
