The foundation’s extended network of patients, volunteers, and medical professionals generates different types of reports through SAP Crystal Reports for recordkeeping and extracting intelligible insights. However, creating these reports requires manually mapping data coming from its Electronic Medical Records (EMR) solution, mumms Software, taking up a lot of their time. With operations across multiple facilities, mumms Software stores patient and staff data in a PostgreSQL database in JSON format, exporting it as Excel files for reporting.  

Moreover, SAP Crystal Reports couldn't save report templates for future use. While mumms Software managed the foundation’s records, Treasure Health wanted to maintain their own in-house database for quicker access and future flexibility, especially if they chose to move away from mumms Software. 

Another issue was mumms Software’s hourly database updates. The process involved deleting and reloading data, causing 2-4 minutes of downtime each time, adding up to 50-100 minutes daily. This downtime, along with communication delays and slow query responses, raised concerns about mumms Software's reliability. 

They sought a solution that could optimize the report generation process, as well as maintain a history of all records in an internally managed database.