Successes

FormPiper: Database Modernization

Jason Kim / May 31, 2022

The Challenge

FormPiper, a B2B Software-as-a-Service company, provides tools to make the completion of consumer finance applications quick and easy.  End users enjoy a streamlined experience, able to apply to several financial institutions using one set of form inputs, while corporate customers are able to apply to automate what was previously a very labor-intensive process.  At launch, FormPiper chose to build its product initially using MySQL as its backend data platform for ease of use and a minimum of configuration for their development staff. Once they partnered with Blue Sentry and started working with our Transformational Engineering teams, we identified many areas for further improvement of the platform.

The Solution

Blue Sentry Cloud utilized several managed AWS services to provide a resilient, cheaper, faster and scalable automated solutions.  Moving from MySQL to native AWS services made the most logical sense. By utilizing NoSQL for their storage needs, FormPiper experienced increased performance and simplification of the relational schema. Blue Sentry Cloud also migrated the data utilizing PostgreSQL due to FormPiper’s need for the relational database framework. 

The Benefit

FormPiper experienced increased performance by lessening the load on the relational database platform. In addition, data that lends itself to storage in a NoSQL system is now stored in DocumentDB, lessening the load on the relational database platform. The scalability of the data structure is exactly what FormPiper needed to help maximize cost savings, improve performance and effectively support their clients. 

 

Case Study Author: Lee Hylton – Chief Technology Officer & Chief Cloud Architect Blue Sentry Cloud