Database connections provide ways and means

Northwest Analytical (Portland, Ore.)-which makes analytical software for understanding processes and improving quality-can create more useful ways to use information pulled from existing data in multiple areas. Jeffery L. Cawley, vp of Northwest Analytical, in a conversation with Control Engineering on May 16, 2002, explained that the software "dips into databases, pulls out information, and relates it in a way people understand."


This article is based on information from Opto 22 and Northwest Analytical and is provided as enhanced online coverage to the June 2002 issue of Control Engineering. For more on this topic, read

How to Get the Most from a Database

'' (Control Engineering, June 2002).

Northwest Analytical integrates data

Northwest Analytical

Quality Analyst v. 5.2 contains additional tools to prevent unauthorized data and parameter changes, which can help users meet U.S. FDA 21 CFR Part 11 requirements for electronic records. Source: Northwest Analytical

Jeffery L. Cawley, vp of Northwest Analytical, in a conversation with Control Engineering on May 16, 2002, explained that the software "dips into databases, pulls out information, and relates it in a way people understand." Software, such as Northwest Analytical's Quality Analyst 5.2, accommodates a range of skill levels. It provides a database connectivity wizard that allows point-and-click data connections or entry (or embedding) of complex SQL queries. Users can apply any number of filters based on the values of any field, by match, a range of values, or wildcard values, he says.

There's a greater need for process literacy in all areas of the enterprise, he says. Applications include comparing performance of plants, providing sales real-time knowledge about potential capacity to produce to prospective customer's specification, serving as an early warning system for a supply-chain system, and documenting a regulatory trail for possible audits.

Opto 22 application connects data flow in both directions

Using XML and SQL, Callaway Golf Ball Co. (Carlsbad, Calif.), is easily and directly accessing, reading and writing information captured from its plant floor to its corporate databases, according to Opto 22 (Temecula, Calif.).

Using an intelligent I/O system (Snap Ultimate I/O from Opto 22) Callaway has established a bi-directional connection between these databases and its golf ball manufacturing equipment and systems, thereby enhancing its ability to acquire real-time production data. More specifically, Callaway is moving crucial quality assurance data from inspection stations throughout its facility directly to SQL Server database tables.

The result has been dramatically lower implementation and capital costs due to the elimination of middleware software and hardware, and a near real-time view of production quality data from the generated SQL reports. The latter gives manufacturing managers the opportunity to detect (and correct) problems at their earliest stages. This has resulted in Callaway being able to increase its yield of golf balls from 33% to 99%, according to Opto 22.

-Comments? E-mail

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.
The Engineering Leaders Under 40 program identifies and gives recognition to young engineers who...
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.
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
Big Data and IIoT value; Monitoring Big Data; Robotics safety standards and programming; Learning about PID
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!

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
Big Data and bigger solutions; Tablet technologies; SCADA developments
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