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.”

The global supply chain management expert Arvato SCM Solutions relies on its global network and powerful business intelligence systems. Read our case study.

Arvato SCM

Arvato SCM | Exasol

https://www.exasol.com/app/uploads/2020/06/Arvato_header-scaled.jpg

Home

Case Studies

Exasol

Data is stored and processed directly in the main memory with Exasol’s in-memory technology and parallel processing. Thousands of Otto users can access the data at the same time without sacrificing speed or performance

Quicker analysis and reporting: 

Intelligent algorithms monitor and auto-tune database performance. Otto’s teams can integrate a variety of programming languages via user defined functions (UDF) 

50% savings:

with Hadoop, Tableau, and other frameworks for data preparation

Integration

Otto can scale with Exasol’s architecture flexibility  

Cloud-ready:

 for Otto teams to access data and coordinate campaigns

GUIs

More brands and partners

With its new Exasol architecture, Otto teams report:

Benefits for Otto

Otto planned to use Exasol as an access layer, taking data from a data lake and warehouse to process reports. But the feeder system data structures retained twice as much data, requiring an overly complex loading path. They needed a solution behind the data warehouse to get data to Tableau quickly.

Midway through the PoC, Otto replaced its data warehouse with Exasol, retaining Hadoop as a raw data store. We quickly learned Otto’s security requirements meant going beyond a new database. Together with their team, we implemented a spark connector as part of a joint hackathon with Otto, Exasol, and partners.

Data warehouse replacement at half the cost  

Otto GmbH is Germany’s largest e-commerce site for home and living, and one of the first retailers to take its mail-order business online more than 25 years ago. Today, customers of the Hamburg-based company search 3 million products from 6,800 brands, and make 55 percent of purchases on smartphones and tablets. Otto’s data scientists use object-centric processing to analyze customer interactions across channels for a personalized shopping experience. Its team turned to Exasol as they began to process increasing volumes of data.

Andreas B.

“Exasol’s analytics database proved impressive. Primarily due to an excellent price-performance ratio: low costs coupled with exceptional performance and integration with Hadoop.”

Otto was able to achieve quicker analysis and reporting. Here's how Exasol gave Otto the ability to scale and save 50% in costs with turn-key compatibility.

Otto Saves 50% With Our Price-Performance Ratio

Otto Saves 50% With Our Price-Performance Ratio | Exasol

https://www.exasol.com/app/uploads/2020/06/OTTO-header-scaled.jpg

Exasol’s integrated distributed data storage eliminates the need for a storage area network (SAN). Cluster compression algorithms enable efficient main memory, keeping system costs low.

XING pays for what it needs.

 Indices are automatically laid out, data is compressed, and SQL instructions from the query optimiser are tuned. XING can process millions of queries per month of the parallelised and complex loading and transformation processes, as well as interactive user queries.

Self-learning adjusts to user preferences.

and compression algorithms allow XING to process and analyze large volumes of data in seconds. Query processing takes place in the RAM, eliminating slow access to hard drives, pre-calculation, and aggregation. 

In-memory cluster technology

Multiple nodes contain two processors each with the individual servers connected in a cluster, where data is automatically divided. 

Columnar storage. 

Within two years of migrating to Exasol’s data warehouse, XING’s data volume increased 5x. With improved performance, what were previously impossible evaluations of data sets are now commonplace.

Benefits for Xing

Members

 processed per year

Datasets

to integrate Exasol into XING infrastructure

Time

Employees

As XING grew, its legacy database reached a limit, with data processing often exceeding 24 hours. They needed a scalable solution for complex analysis of 10 billion data sets a year, clustering for better speed, and lower administrative costs.

In just four weeks following a benchmarking test, XING integrated Exasol into its existing infrastructure. ETL (Extract Transform Load) processes were converted consecutively into the new solution.

In-memory clusters and eliminating SAN for cost savings on 10B data sets a year 

XING is a social networking platform for business professionals, with 16 million members worldwide. Based in Hamburg, Germany, XING members organize and attend events, find job opportunities, and connect with other experts in 80,000 specialist groups and 16 languages. XING uses intelligent data analysis to target networking and recruiting information for its member companies that advertise directly on the platform.

Dr Ulrich Fricke

“Queries that were previously unthinkable are now possible.”

Xing is used by people from over 200 countries. Migrating to a data warehouse solution from Exasol helped them take a big step forward. Read the case study.

Xing

Xing | Exasol

https://www.exasol.com/app/uploads/2020/06/XING-header-scaled.jpg

Products

Deployment Options

Learn more

Customer Support

TPC-H Benchmark

Tableau, MicroStrategy, Looker, Yellowfin, PowerBI, Qlik Sense, and more

BI Tools

DataRobot, H2O, TensorFlow, SageMaker, SAS

Data science

Infrastructure

Security

Informatica, Talend, Alteryx, Pentaho, Kafka, Amazon Kinesis, Keboola, and more

Data integration

Learn More

Partners

Works with

Featured Customers

Industries

Bumble: 100M+ user AB test intersections in seconds

Companies around the world, small or large

Trusted By

Get Started On Prem

Cloud Options

Featured Topics

Learn

Optimize BI performance with Exasol analytics database

Documentation

About

Newsroom

Careers

Explore news, views, announcements and more

Blog

Investor relations

Contact Us

Company

Democratization of data and self-tuning technology frees up hours of time previously spent on administration

Faster access to data and reporting for better insights and business decisions

All data analytics and reporting tools now powered by a single database

The benefits for Medion

Medion was using Excel to manage data across SAP, ERP, and multiple CRMs, limiting the speed and quality of predictive analysis. As its portfolio of digital products grew, they began looking for a high-powered solution that could support BI, data warehousing, and data science.

Within six months, Medion implemented Exasol into its IT systems and infrastructure.