Case Study: DB Regio AG, Sparte Bus - Impression #1

Case Study: Master Data Consolidation on a single Data Platform

DB Regio Bus Mitte is a subsidiary of DB Regio AG and, as a bus transport service provider, places particular emphasis on regional ties and local presence.

As part of the Master Data Hub for DB Regio Bus, master data was to be optimized and consolidated on a central platform. This involved integrating around 1 million network points from 14,000 routes into one platform and connecting them to 10 systems.

Logo: DB Regio AG, Sparte Bus
Logo: Basilicom
Pimcore Platinum Partner
Customer
  • DB Regio AG, Sparte Bus
Solution Partner
Industry
Products Used

Customer Key Facts

9 500
Employees
450M
Customers
Challenge

Heterogeneous data storage in a wide variety of data formats

The impetus for the project was the goal of introducing a data lake in order to achieve data consolidation. The challenge for DB Regio Bus was the complexity and variety of data in local public transport. This includes various data types such as network points, network point quantities (e.g. stops, masts and depots), corporate bodies, tariffs, tariff systems, concessions (including award procedures, contract data and tender data) and lines. The difficulty lay in the heterogeneity and the lack of standardized processes for data entry, modification and provision. The data was recorded in different systems, with various identification systems being used. This led to challenges in consolidating and integrating the data. The aim of the project was to be able to maintain and provide the different data classes centrally.
Read more Read less
Solution

A central master data platform

The optimal master data consolidation on a single data platform for many DB Regio Bus data as a central data supplier required careful planning and implementation. First, a needs analysis was carried out to identify all critical master data and all data sources inside and outside DB Regio Bus. Standards were developed for the structure and formatting of the data to ensure uniform presentation and thus seamless integration and use of the data. Regular measures were implemented for quality control and data cleansing. Pimcore was established as a central platform to consolidate the data and serves as a single data source for other systems via standardized APIs. To protect the data, a separate user management system was introduced to restrict access to the data for individuals and systems. Comprehensive documentation was created and training was provided for up to 1,200 users.
Read more Read less
Results

Manage and provide master data efficiently

The result is a central platform based on Pimcore, which serves as a single source of truth for all relevant DB Regio Bus master data. In 80 import processes, one million network points were adapted to uniform standards and integrated into the new system. Consolidation has not only increased efficiency, but also contributed to higher data quality and seamless integration of the bus systems. The implementation meets the requirements for effective, secure and scalable master data management.
Read more Read less

Key Results

1M
Data Objects
1 200
Users

Read more Pimcore success stories

NextJet

NextJet is the largest regional airline in Sweden with a route network including 16 domestic destinations, and five international (Denmark, Finland and Norway).
DXP/CMS, Transport & Logistics

More Than Just a Pimcore Shop

The Kreckler GmbH from Hirschberg (Weinstraße) is the initiator and client for this e-commerce project. The company is a long-standing specialist trade partner of Schulte Lagertechnik, represented in the Rhine-Neckar metropolitan region.
DXP/CMS, Digital Commerce, PIM/MDM, DAM, CDP, Transport & Logistics

Nature's Pride

Nature's Pride is one of the largest importers of fruit and vegetables in Europe. They source more than 230 different fruits and vegetables from nearly 58 countries, from Ready-to-Eat and exotics to berries and off-season products.
DXP/CMS, Transport & Logistics

Quehenberger

Quehenberger Logistics is a full-service logistics provider and specialist for comprehensive industry solutions with a focus on Central and Eastern Europe. The owner-managed, medium-sized company based in Straßwalchen near Salzburg employs 4,783 people at 95 locations in 18 countries.
DXP/CMS, Transport & Logistics

110 000+ businesses trust Pimcore. Discover our 550+ favorite success stories.

View all stories