Data integration is key for overall equipment effectiveness ratings

One interface is better than multiple query tools to see data from all configured data sources to improve OEE ratings.


Controls and IT Integration, Control EngineeringOften various industries need to pull together disparate information for reporting purposes. Integration with heterogeneous data sources is often complicated, confusing, or a multi-step process. Many cases involve combining business data with process data or gathering more details into a process summary report for certain conditions. In any case, one simple way is to provide a common link or most common denominator. This is often as easy as using a database such as Oracle or SQL Server to link multiple data sources together.

Engineered solutions can use SQL Server Reporting Services to report on data from SQL databases and Oracle databases, while providing drill-down capabilities into process data from a historian archive. Such solutions can be extremely valuable and time saving, increasing the integrity of the reports and providing an increased return on investment (ROI) in many cases.

For many users, having collective information readily available can be instrumental in making production changes, resolving issues, or providing details for change initiatives. Business intelligence is known to be a driving force in maximizing the overall equipment effectiveness (OEE) rating in any process. Having the data integrity and consistency in the reports is paramount when using a solution that does not involve manually pairing up data from multiple sources or multiple users.

Lee is associate department manager, Industrial Systems Division, Matrix Technologies Inc.Database reporting solutions can communicate with other systems and provide a common communication tool to other systems. Instead of having to use a query tool for this database, an external open database connectivity (ODBC) query for that database, and yet another trend report for process data, users can use one interface to see data from all configured data sources. A well-trained analyst can query the historian archives and then query the business system or some other database, all from the same interface. This speeds design and resolution time for the users.

- John Lee is associate department manager, Industrial Systems Division, Matrix Technologies Inc., providing engineered solutions using SQL Server Reporting Services. Lee is among the Control Engineering Leaders Under 40, Class of 2012. Edited by Mark T. Hoske, content manager, CFE Media, Control Engineering,

No comments
The Top Plant program honors outstanding manufacturing facilities in North America. View the 2013 Top Plant.
The Product of the Year program recognizes products newly released in the manufacturing industries.
The Engineering Leaders Under 40 program identifies and gives recognition to young engineers who...
A cool solution: Collaboration, chemistry leads to foundry coat product development; See the 2015 Product of the Year Finalists
Raising the standard: What's new with NFPA 70E; A global view of manufacturing; Maintenance data; Fit bearings properly
Sister act: Building on their father's legacy, a new generation moves Bales Metal Surface Solutions forward; Meet the 2015 Engineering Leaders Under 40
Cyber security cost-efficient for industrial control systems; Extracting full value from operational data; Managing cyber security risks
Drilling for Big Data: Managing the flow of information; Big data drilldown series: Challenge and opportunity; OT to IT: Creating a circle of improvement; Industry loses best workers, again
Pipeline vulnerabilities? Securing hydrocarbon transit; Predictive analytics hit the mainstream; Dirty pipelines decrease flow, production—pig your line; Ensuring pipeline physical and cyber security
Upgrading secondary control systems; Keeping enclosures conditioned; Diagnostics increase equipment uptime; Mechatronics simplifies machine design
Designing positive-energy buildings; Ensuring power quality; Complying with NFPA 110; Minimizing arc flash hazards
Building high availability into industrial computers; Of key metrics and myth busting; The truth about five common VFD myths

Annual Salary Survey

After almost a decade of uncertainty, the confidence of plant floor managers is soaring. Even with a number of challenges and while implementing new technologies, there is a renewed sense of optimism among plant managers about their business and their future.

The respondents to the 2014 Plant Engineering Salary Survey come from throughout the U.S. and serve a variety of industries, but they are uniform in their optimism about manufacturing. This year’s survey found 79% consider manufacturing a secure career. That’s up from 75% in 2013 and significantly higher than the 63% figure when Plant Engineering first started asking that question a decade ago.

Read more: 2014 Salary Survey: Confidence rises amid the challenges

Maintenance and reliability tips and best practices from the maintenance and reliability coaches at Allied Reliability Group.
The One Voice for Manufacturing blog reports on federal public policy issues impacting the manufacturing sector. One Voice is a joint effort by the National Tooling and Machining...
The Society for Maintenance and Reliability Professionals an organization devoted...
Join this ongoing discussion of machine guarding topics, including solutions assessments, regulatory compliance, gap analysis...
IMS Research, recently acquired by IHS Inc., is a leading independent supplier of market research and consultancy to the global electronics industry.
Maintenance is not optional in manufacturing. It’s a profit center, driving productivity and uptime while reducing overall repair costs.
The Lachance on CMMS blog is about current maintenance topics. Blogger Paul Lachance is president and chief technology officer for Smartware Group.