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.
Germany
52000+
Retail & Ecommerce
Exasol Data Warehouse
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. It quickly became apparent that 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.
Exasol’s in-memory technology and parallel processing enable quick analysis for thousands of users simultaneously, maintaining high performance.
Otto achieves 50% savings through intelligent performance optimization, with the ability to integrate various tools like Hadoop, Tableau, and multiple programming languages.
Exasol’s cloud-ready architecture and user-friendly interfaces allow Otto to scale efficiently, coordinate campaigns, and onboard more brands and partners.
