Production Process: MES Enhanced with SQL to Link Manufacturing and ERP

Aug. 23, 2013
The ProductionACE manufacturing execution system (MES) has been enhanced with an SQL database to provide a universal near real-time integration between ERP and production operations.

The system uses Machine Data Transducers (MDT) to provide data collection from all types of manufacturing equipment; MDTs accept simple electrical machine operating signals instead of a more complicated serial data connection. Coupling MDT's capability with a SQL database provides manufacturers with a practical and universal means to integrate ERP with all types of discrete manufacturing. Integrating manufacturing and ERP is useful for a number of reasons. It develops accurate delivery promises: download of master production schedule to each production machine generates ship dates calculated using current conditions and machine constraints. It eliminates manual data collection labor and improves work-in-process and inventory accuracy with error-free, electronic record keeping. It enables ERP systems to easily collect manufacturing data as mandated by regulatory bodies. And it simplifies ERP implementation by exchanging production data through SQL tables, thus eliminating the need for ERP suppliers to be involved in the complexities of equipment interfaces.

>>For more information on this product, click here

Production Process
http://productionprocess.com
603.434.2300

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...