How to Analyze Data from Multiple Databases

Oct. 2, 2012
Given that most manufacturers have multiple databases in place throughout their operations, the ability to perform an analysis of the combined data can be problematic.

To address this issue, numerous automation suppliers have developed manufacturing intelligence software packages designed to aggregate and present data from multiple databases in a way that is easy to understand and, therefore, analyze.

One example of how manufacturing intelligence software can be applied for process analysis is seen in the way Georgsmarienhütte GmbH, a major German steel supplier, uses FactoryTalk VantagePoint enterprise manufacturing intelligence software from Rockwell Automation to leverage control system data and achieve company efficiency goals.

To keep up with production needs, Georgsmarienhütte had added a variety of new capabilities to its process over the years, such as a custom process analysis solution that automatically analyzes off-gases using mass spectrometry. As the company expanded its production systems with technology like the process analysis equipment, it also expanded the volume of data sources managing the information coming in and out of each system. As a result, the company soon found itself managing an overwhelming number of data sources including two historian servers, two Oracle databases, a Microsoft Access database, a Microsoft SQL server and an OPC-DA server for its PLCs.

With so many data sources, operators and plant managers had to use two desktop computers and manual data entry to create an accurate picture of production.

FactoryTalk VantagePoint was selected to address this issue because of its ability to leverage Microsoft SQL data to provide role-based access to production information. Using a unified production model to access each data source, the software maintains data quality and provides Georgsmarienhütte employees, from production workers to management staff, with access to all connected systems using one interface. The software also produces Web-based reports and analytics, providing users with role-based information most relevant to their job.

About the Author

David Greenfield, editor in chief | Editor in Chief

David Greenfield joined Automation World in June 2011. Bringing a wealth of industry knowledge and media experience to his position, David’s contributions can be found in AW’s print and online editions and custom projects. Earlier in his career, David was Editorial Director of Design News at UBM Electronics, and prior to joining UBM, he was Editorial Director of Control Engineering at Reed Business Information, where he also worked on Manufacturing Business Technology as Publisher. 

Companies in this Article

Sponsored Recommendations

Why should American-Made Products be a top priority?

Within this white paper, Shalabh “Shalli” Kumar, founder of AVG Advanced Technologies, stresses the importance of prioritizing American-made products to safeguard the country'...

How to Improve Production Accountability in Manufacturing

David Greenfield, Automation World's Editor-in-Chief, and Shalli Kumar, founder of EZAutomation, discuss the idea of production monitors: a preprogrammed PLC/LED display that ...

HALT/HASS: The Ultimate Test for Reliability

Discover how companies like EZAutomation push the limits of reliability with HALT/HASS testing, originally designed to mimic the extreme conditions of space shuttle launches. ...

Your Next Production Monitor Is Only a Few Clicks Away

Shop for your very own EZ Production Monitor. It's designed for non-technical staff, so there's no programming required! It combines pre-coded firmware, real-time data, and WiFi...