12x faster on 5,000 daily reports

The Gist

The challenge

Given the enormous volume of data and reports Grant Street analyzes and generates, its engineers recognized they were approaching a performance ceiling and needed a scalable database. With its own in-house front-end reporting tool in place, Grant Street needed a back-end solution that could integrate into its existing framework, and deliver accurate and faster reporting across all products for its clients.

The solution

Exasol connects to two of Grant Street’s core products, while serving as the back-end database for its data analytics and visualization tools – supporting both client-facing and internal analytics. Two dozen data streams feed into the Exasol warehouse in real time from data stores within the business, making it possible for Grant Street to correlate all of the data in one place for visualizations and BI.

“Exasol has allowed us to exponentially decrease our reporting times. Our clients are happy and so are we."

Peter Kioko, Software Developer

Benefits

Benefits for Grant Street Group

12x faster back-end reporting on roughly 5,000 daily reports

4TB of data in its production cluster with 8GB added daily

Up to 100MB a second uploaded into the Exasol warehouse at peak times

Ease of integration with Grant Street’s existing in-house tool, which uses SQL