It's no secret that time constraints and competing priorities force modern companies to learn and adopt new business practices and software. HealthCare Appraisers is no exception - a stable growing company dedicated to providing hospitals and health centers with valuation services, seeking to advance both internal and external data resource capabilities, optimize daily work and automate it wherever possible.
But the trick here is to pick the right tools for the job. And this is where their team faced a problem. The performance of the database tools they were using kept failing to catch up with the company's growth. For instance, it used to take too long to export datasets to CSV and then manually convert CSV files to the Excel format that the end users wanted.
After a while, the HealthCare Appraisers team finally found a suitable solution - dbForge Studio for MySQL. It was eventually chosen over its rivals for three main reasons: seamless work with MariaDB and its additional storage engines beyond traditional MySQL, reliable and easy-to-use backup features, and rich export and import features, which cover the most common data file types widely used by businesses.
The adoption of dbForge Studio for MySQL led to a number of considerable performance boosts. Sequences of stored procedure routines have become easy to initiate with a button click. The GUI is always available and ready for custom query research. Additionally, custom queries are faster to process with easy export to the Excel format required by the business analysts.
Parts of the workflow have been automated as well. For instance, the team processes over a dozen large datasets each month via an automated set of stored ETL routines (procedures). The standard transformed data is automatically processed and exported to file systems with only minor human oversight. Custom queries and research are performed at the query level using the GUI.