Harmonized database & consolidated apps

Use case: Harmonized database & consolidated apps


A department of the federal government responsible for ensuring that high-quality health services are accessible to Canadians needed to consolidate several departmental databases and modernize two essential applications in order to leverage the database.


  • Two siloed applications for nutrition and recipes were not communicating causing data duplication, manual data entry errors, and delayed operations
  • Inability to import essential data in different formats required time-consuming manual intervention
  • Generating reports and exporting data was difficult, slow, and expensive


  • A single, harmonized application and database integrates with both department applications
  • Automated and normalized the data import process
  • Developed standardized on-demand reports and a simple and flexible data export process


  • Reduced infrastructure, administrative requirements, and training overhead by ~50%
  • Eliminated the need for and risk of manual intervention
  • Streamlined workflows and improved operational efficiency


About BIG

Bits In Glass is an award-winning software consulting firm. We combine our deep industry expertise and experience with the best names in technology to provide innovative solutions to your unique business challenges. Our expert consultants excel at solving complex technical problems across industries and verticals, specializing in healthcare, financial services, insurance, and the public sector. Let us help you improve operations, drive better customer experiences, and return more to your bottom line.

Subscribe to Bits In Glass

Get the latest news and updates directly in your inbox.

Check out our video library!

Learn how Appian helped top brands gain success.