OPC or Database: How are People Connecting?

March 13, 2007
(Sidebar to "Connecting Sensor Data to the Boardroom" from the March 2007 issue of Automation World) 
In connecting plant data to the business side, companies are turning to recently developed standards that can make the arc from the shop floor to the business side. “You can do it a couple different ways,” explains James David, senior applications engineer at vendor Opto 22, in Temecula, Calif. “You can drive it through a database to a Microsoft SQL Server, or you can use a direct connection through OPC.”OPC (an open connectivity standard) has been getting a lot of attention in the field of connecting the plant to business systems, especially the most recent OPC UA (Unified Architecture), which was released to the OPC membership last fall. The strategy behind OPC UA, according to analyst firm ARC Advisory Group Inc., in Dedham, Mass., is to leverage collaboration with other industry standards, including ISA-S95, ISA-S99, OAGi, EDDL and MIMOSA. The OPC UA is intended to focus on how to move data from these other standards organizations and define the “semantics of content.”Craig Resnick, research director at ARC, notes that “the foundation of OPC UA includes all of the necessary services to provide secure, reliable interoperability across platforms, leveraging Web Services and the collaborative effort with other industry standards organizations.” He notes that newly developed parts of OPC UA specialize in services required for alarms and events, data exchange and historical data access. Opto 22’s David also notes that connectivity can be made between the plant and business systems without using OPC. “Without OPC, the controller data can go right to a database, and the database can be accessed through the ERP (enterprise resourse planning) system or MES (manufacturing execution system). However you do it, once you get the data into SQL, you’re golden.”A recent survey by AMR Research Inc., in Boston, shows that the majority of plants are using ISA-S95 as the primary standard for exchanging plant data with ERP systems. A hearty 59 percent use ISA-S95. Another 25 percent are using ISA-S88, while 22 percent are using OAGi (a communication standard from the Open Applications Group) and 15 percent are using any number of other standards.To see the main story this sidebar was taken from - "Connecting Sensor Data to the Boardroom" - please visit www.automationworld.com/view-2999 

Sponsored Recommendations

Forget complex programmingget smarter, faster automation with MOVI?C. With scalable performance, multibus flexibility, and safety built in, its control tech that adapts to ...
Looking for speed, accuracy, and zero maintenance? SL2 synchronous linear motors deliver high-performance motion without wear partsperfect for pick-and-place, handling, and precision...
Say goodbye to complex programming and hello to effortless automation. With SEW-EURODRIVEs MOVI-C control tech, you get powerful motion control, ready-to-use software modules...
Discover how one of the busiest airports in the U.S. upgraded its baggage handling system to meet strict energy goals and boost performance. See how SEW-EURODRIVE helped American...