Control Engineering Online Update for August 13, 2004


Control Engineering Online Update - Technology


Sponsored by

Coupling OPC with generic database access technology enables the swapping of data between real-time and relational databases.

Don't miss Control Engineering and GE Fanuc's September 22 Webcast.
Register today!

Using generic database access technology to expand OPC

By Randy Kondor

At the foundation of most automation applications are databases. They are the windows to our innermost operations as well to our connections with the outside world when used as a gateway to a process optimization application, computer maintenance management system (CMMS), composition analyzer, or a custom, in-house application.

As our dependence on databases has increased, so too has our reliance on OLE for Process Control (OPC)—the open connectivity standard for industrial automation and enterprise systems. OPC standardizes the way that plant floor devices such as PLCs, DCSs, and analyzers share data with software applications such as HMIs, process historians, and trending applications. Regardless of the type of device, data is always shared in the same standardized format using OPC. As a result, it has become the standard used by applications to poll devices for real-time data.

The widespread industry acceptance of OPC has led many companies to pursue conversion of archived, relational data to real-time data—and vice versa—so that different databases can communicate more effectively, ultimately enabling better decision-making at all levels of the manufacturing organization.

A number of access methods are capable of handling data conversion, such as ODBC; however most of these methods are intended for use with relational data, not real-time transfers. Further complicating the data conversion issue is the fact that products from Sybase, Oracle, and Microsoft all have their own application programming interfaces (APIs) used to optimize operations.

OPC can handle the issues of data transfers between real-time and relational databases as well as multiple API use with the application of generic database access (GDA) technology. GDA helps OPC take advantage of real-time values from a relational database. For a frame of reference, consider that Microsoft ActiveX Data Objects are examples of GDA technology. ActiveX Data Objects are COM (component object model) objects used to gain access to a database through active server page (ASP) technology.

OPC generic database access

OPC GDA 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 historians can use existing OPC interfaces to 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, as is done in CMMS.

Because OPC for GDA standardizes the data access method, every point is guaranteed to have three attributes: a value, quality, and timestamp, just like data from any other OPC source. It is irrelevant to OPC whether the application connects to a DCS, PLC, database, or other device, because the interface is always the same.

Randy Kondor is OPC product manager for Matrikon, a provider of software solutions for the process industries; . For more information about OPC, visit .

No comments
The Engineers' Choice Awards highlight some of the best new control, instrumentation and automation products as chosen by...
The System Integrator Giants program lists the top 100 system integrators among companies listed in CFE Media's Global System Integrator Database.
Each year, a panel of Control Engineering and Plant Engineering editors and industry expert judges select the System Integrator of the Year Award winners in three categories.
This eGuide illustrates solutions, applications and benefits of machine vision systems.
Learn how to increase device reliability in harsh environments and decrease unplanned system downtime.
This eGuide contains a series of articles and videos that considers theoretical and practical; immediate needs and a look into the future.
Additive manufacturing benefits; HMI and sensor tips; System integrator advice; Innovations from the industry
Robotic safety, collaboration, standards; DCS migration tips; IT/OT convergence; 2017 Control Engineering Salary and Career Survey
Integrated mobility; Artificial intelligence; Predictive motion control; Sensors and control system inputs; Asset Management; Cybersecurity
Featured articles highlight technologies that enable the Industrial Internet of Things, IIoT-related products and strategies to get data more easily to the user.
This article collection contains several articles on how automation and controls are helping human-machine interface (HMI) hardware and software advance.
This digital report will explore several aspects of how IIoT will transform manufacturing in the coming years.

Find and connect with the most suitable service provider for your unique application. Start searching the Global System Integrator Database Now!

Infrastructure for natural gas expansion; Artificial lift methods; Disruptive technology and fugitive gas emissions
Mobility as the means to offshore innovation; Preventing another Deepwater Horizon; ROVs as subsea robots; SCADA and the radio spectrum
Future of oil and gas projects; Reservoir models; The importance of SCADA to oil and gas
Automation Engineer; Wood Group
System Integrator; Cross Integrated Systems Group
Jose S. Vasquez, Jr.
Fire & Life Safety Engineer; Technip USA Inc.
This course focuses on climate analysis, appropriateness of cooling system selection, and combining cooling systems.
This course will help identify and reveal electrical hazards and identify the solutions to implementing and maintaining a safe work environment.
This course explains how maintaining power and communication systems through emergency power-generation systems is critical.
click me