Data to drive our product can be sourced from anywhere. Where API’s are available for sourcing data from an ERP system we can employ them. Alternatively, source data can be “dumped” into a number of different file formats which is then updated into our staging tables.
Over many years and implementations, we have learnt that there are always issues with Master and Missing Data out of various source systems. Our software includes a technical process to manage incoming data (stored into our staging tables) We “audit” for incorrect or missing data.
Users are afforded an opportunity to manage incoming data before they update the relevant modules. This eliminates, to a large extent, wasted effort and time and the integrity of planning outputs is maintained.