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 with no manual interaction.
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 utilised the customer's existing Wonderware Historian to monitor the ingredient additions, and used a SQL Database to collate all 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.