A colleague was asking me to explain a system information flow, as they are having problems with the wrong information being presented. It seems that what they have created is a custom built website, with it's own database, which gets it's data from SAP via a JSON based dataset.
SAP is the live information, the custom built solution enables other information to be captured, thereby enriching the SAP data. This is stored locally in the custom site's local database, to produce monthly reports.
I'm trying to wrap my head round why a JSON dataset is being used, rather than a direct (SQL?) query type approach. If the goal is to get live information from SAP on a monthly basis, why not just query SAP, rather than construct a static JSON payload, and have to parse it. Now it seems the argument is whether the JSON wrongly created, or wrongly interpreted... it just seems so much more complicated.
Since the JSON file is done every night too, it's not obvious to me why this particular design has been chosen.