Treasure Health Uses Astera to Enjoy Faster Report Generation.
Treasure Health, a non-profit serving Martin and St. Lucie counties, offers grief support, pediatric care, community education, and hospice services. Founded in 1982 as a hospice, it now serves over 3,000 patients annually, with dedicated volunteers and medical professionals providing high-quality care.
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.
Treasure Health wanted to automate and simplify the process by creating standard templates for different types of reports to quickly generate day-to-day reports for decision making. After evaluating several options, including Talend's Data Management Platform, they chose Astera for its ease of use and robust automation capabilities.
By utilizing Astera's workflow creation capabilities, Treasure Health streamlined their entire process. A simple query now triggers predefined workflows, reducing a multi-step procedure to a single step. Astera manages everything, from sourcing data from mumms' database to parsing and transforming it for use in Crystal Reports.
What once took over an hour to download data now takes just 15 minutes. With Astera's data parsing and transformation capabilities, the entire data preparation process is completed in only 25 minutes, bringing the total time down to just 40 minutes.