As CashWizard's customer base grew, the need for a more robust and flexible data store became apparent

American Security is one of the largest providers of connected safes to both consumers and small businesses. Their CashWizard online portal enables their customers to modify safe configurations and view a wide variety of reports to track and audit user activity with a safe.

Improving the scalability and reliability of CashWizard to enable American Security to grow their customer base.

As American Security’s customer base grew, the volume of data CashWizard was required to process became too large for a traditional relational datastore. Complex aggregation and archival jobs needed to be run on a consistent basis to keep the data at a manageable size for reporting performance. Quickly approaching the limits of their relational database cluster, American Security recognized they needed to pivot. They partnered with Protagona to rethink their data strategy.

Protagona began by analyzing the current volume of data and the payloads for each request. They then explored what the end state of the data should look like to end users as they generate audit reports and other analytics. Taking into consideration the expected customer growth, Protagona designed a multi-stage data lake to accommodate both current and future pain points related to data ingestion and report processing. As the structure of the data lake was deployed, AWS Database Migration Service was used to migrate data from SQL Server into the data lake. This was a huge foundational step to add more external system integrations, and ingest data feeds from their IoT implementation.