A Borg company

George Weston Foods SAP Integration

George Weston Foods SAP Integration
George Western Foods were looking to improve the transfer of historical data from their mixers into their SAP ERP system.

The Challenge

Historically, data was entered manually; with the predicted amounts for each ingredient (flour, water, yeast, etc.) being first transcribed onto a paper based system by the operator. These target figures would then be entered into the SAP system by approved personnel. The challenge was getting the data from the mixers straight into SAP without any manual interaction.

The Solution

The mixers were already fitted with monitors to measure the actual amounts of each ingredient.  Working with the IS department, we agreed on an interface exchanging CSV files over FTP.  We utilized the customer's existing Wonderware Historian to monitor the ingredient additions, and used a SQL Database to collate all of the ingredients used, synchronize those individual ingredient weights to the associated batches, and synchronize those batches to production orders.  The database used Microsoft SQL's Integration Services to map the data into a CSV file for transfer to the SAP System.

The system's capability was later extended by integrating a Production Order feature which allowed an operator to select batches of bread to be created from a range of Production Orders provided by the SAP system.

Featured Technology

  • Wonderware Historian
  • Wonderware InTouch
  • Microsoft SQL Services
  • Microsoft SQL Data Transformation Service
  • Allen-Bradley ControlLogix PLC

Benefits

The old manual system was based on the target amount for each ingredient, but often the actual amount measured differs slightly.  We were able to take advantage of the much more accurate measurements already being monitored by the mixers allowing for more accurate predictions for ingredient quantities.

The mixer usage data collection is now fast, accurate and automated.

The selection of batches for the day’s production was made user friendly with the integration of the Production Order System.

You might also like these articles

Rockwell PLC5 & PlantPAX Wet End Upgrade
Rockwell PLC5 & PlantPAX Wet End Upgrade
4 minute read
One of Australia’s leading plaster board manufacturers has once again contracted Crossmuller to complete the next stage of their ongoing plant technology upgrades.
Crossmuller - Certified Experts
Crossmuller - Certified Experts
2 minute read
Crossmuller have always prided themselves on their commitment to achieving recognised benchmarks of expertise across the range of practices they offer. With expertise across both technical and busine...
Fully featured change management solution for Wonderware System Platfom with MDT AutoSave
Fully featured change management solution for Wonderware System Platfom with MDT AutoSave
2 minute read
MDT AutoSave is the most advanced automation-layer change management solution with installations around the world in dozens of industries.