Table joins are executed in real time, even on large data volumes

Transformation processes are run in a virtual analytics layer instead of an ETL process

With self-tuning, Arvato developers can focus on programming instead of maintenance

Benefits for Arvato

employees

countries

faster queries

To ensure quality for its customers, Aravato’s business units needed access to a custom BI-reporting tool tailored to each industry. But Arvato lacked a universal BI standard — and decentralized teams were unable to take advantage of data. The goal became to migrate all legacy BI solutions into one platform, while ensuring that the BI solution could scale to accommodate the different business units’ requirements.

The challenge

Arvato deploys a cluster system consisting of 2+1 test servers and 8+1 development servers averaging 10TB of data volume. Datasets are extracted with Microsoft SSIS with ADO. NET. SAP Business Objects is the BI front-end. It was critical to Arvato that Exasol migrate all existing data models from Oracle and MS SQL over to the new platform.

The solution

1 BI strategy - 20x faster

Arvato SCM is a global supply chain provider that guarantees quick and safe delivery of millions of tangible goods and services every day on behalf of its customers. Arvato relies on business intelligence systems across six business units, each focused on a specific industry, that makes data accessible and transparent for detailed workflow control.

Dr. Jan Bolz

“The database allows us to manage the heterogeneous aspects of our business units much more efficiently.”

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

Benefits for Grant Street Group

processed annually

e-payments

at peak times

uploaded into Exasol warehouse

reporting speeds

faster

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.

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.

12x faster on 5,000 daily reports 

Grant Street Group offers cloud-based government solutions for tax billing, payment processing, and online auctions, and at $12 trillion is the world’s largest internet auctioneer of financial and legal instruments. Its e-payments service processes over $10 billion in secure transactions annually, and nearly two-thirds of all property taxes in Florida and a third of online vehicle registration and renewals run through Grant Street software.

Peter Kioko

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

Less than 1 minute run times on analytic workloads — 100 times faster than before.

Cohort analyses group users for in-depth look at customer behavior based on individual user interactions — not just “what products are viewed” but “which users viewed which products.”

By condensing data into specific behavioral patterns, Econda can form segments to better research customers and analyze marketing campaigns.

Benefits for Econda

analytics workloads run time 

of complex analytics

jobs completed

processed each month

raw data

customers

e-commerce

Econda’s speed relies on its supporting database, but its 2007 system couldn’t handle real-time analysis on 13 terabytes of raw data a month for more than 1,000 e-commerce companies.

Exasol’s in-memory database with central data store and analytical tools replaced Econda’s legacy system. 