Home > Downloads > Accessing SQL Server, Oracle, and other Databases Using OPC

All Downloads

Archived Webcast

Device Drivers (OPC Servers)

Product Software

Specifications

OPC Tutorials

Whitepapers

Portal Login


Click below to begin your MatrikonOPC Driver Search.

Accessing SQL Server, Oracle, and other Databases Using OPC

OPC GDA (General Database Access) technology deals with the translation of data from databases to standardized OPC values and back again. GDA can connect an application to any database, regardless of the table structure — even a poorly configured database. GDA is built with an OPC front end, and can therefore be effectively used to provide a host of database connectivity solutions. For example, OPC applications such as Human/Machine Interfaces (HMI), expert systems, and archivers/historians can easily use their existing OPC interfaces to quickly integrate a database as a real-time data source. In addition, since OPC GDA technology also enables a database to be used to store new information, GDA can be used to collect data from an OPC source and archive it in the database, such as the case in a CMMS.

Get the full Whitepapers Now!

Details:
Whitepapers (113 kb , PDF)
Author: MatrikonOPC

Description:
In any industry, databases are the foundation of many automation applications. OPC has become the standard used by applications to poll devices for real-time data. OPC can take advantage of real-time values from what was once a relational database by using Generic Database Access (GDA) technology.