Home » Customer Stories » OTTO & Exasol Semantic Layer (ESL)

OTTO & Exasol Semantic Layer (ESL)

90% reduction in code complexity, simplifying maintenance and updates.

Case Study

Transforming Data Access and Insights with a Business Semantic Layer

OTTO, one of Germany’s largest e-commerce companies, developed Exasol Semantic Layer, a semantic business layer built on Exasol’s Virtual Schema technology. By transforming their data landscape, OTTO significantly improved operational efficiency and customer satisfaction.

Read the full story

Location

Germany

Employees

38000+

Industry

Retail & e-commerce

Product

Exasol Semantic Layer

The Challenge

OTTO faced operational inefficiencies due to fragmented business logic across multiple BI tools and a heavy dependence on IT specialists for data access and reporting. This setup made it difficult to maintain consistent data definitions and business logic across platforms.

The Solution

OTTO developed the Exasol Semantic Layer to centralize and streamline data access. They built a Python-based query engine and a dynamic virtual table layer using Exasol’s Virtual Schema technology, which provided a consistent, single source of truth for data across the organization.

Benefits

Benefits for OTTO

Self-Service Analytics

Business users can interact with data directly without needing technical expertise.

Centralized Business Logic and Governance

Consistent data definitions and reporting across all platforms.

Cross-Platform Flexibility

Integration with multiple BI tools without redundant model configuration.

Exasol’s platform has revolutionized our data approach, enabling unmatched efficiency and independent data access for business users.

Users of ESL, OTTO