Berliner Stadtreinigung AöR
Digital sovereignty – data integration with FME
The Challenge
In the business world, the importance of data-based operational process support is constantly growing. This also applies to Berliner Stadtreinigung AöR (Berlin's municipal waste management company or BSR). The constant development of the system environment, changes in business processes, consideration of digital sovereignty issues, and changes in legal requirements mean that new challenges are constantly arising in the areas of data management and geoprocessing.
The challenge was to update the FME Desktop and FME Server environment within a maintenance window, including the migration and quality assurance of existing FME processes. This involved, among other things, expanding and adapting the platform architecture as well as the data integration processes and their automation. In addition to optimized data processing and provision, a key objective was to enable BSR to integrate future data-holding systems as efficiently as possible.
FME offers us numerous possibilities to flexibly integrate specialist data into business processes and to respond quickly and easily to changes without getting caught up in complex technical dependencies. With FME as our platform, we are well equipped for future requirements.
The Customer
With approximately 6,200 employees and a turnover of around €670 million, Berliner Stadtreinigung AöR (BSR) is one of Europe's largest municipal waste management companies. As a service provider for the state of Berlin, BSR is responsible for waste collection, waste treatment, street cleaning, and winter services.
BSR disposes of household, organic, and bulky waste from private households in Berlin and is responsible for emptying recycling bins in some urban areas. BSR operates a waste-to-energy plant, a biogas plant, a composting plant, and 14 recycling centers.
The Solution
In conjunction with the upgrade of the FME Desktop and FME Server environment, a robust and efficient production and testing environment for the FME platform was established, accompanied by the implementation of an advanced data processing architecture. Dozens of existing FME Desktop processes were updated in this context and tested using regression testing. Processes for ALKIS import, winter service route planning, and route visualization can now be operated more efficiently and with higher performance.
The process documentation developed by con terra also helps BSR to identify and visualize dependencies on other systems and data. To give BSR greater independence in implementing new data-holding systems, con terra designed and implemented new FME processes. In the course of this, the SAP GIS interface was also adapted to support the future conversion of the persistence layer of the ERP database to SAP HANA. Mutual dependencies with other BSR projects, such as order and route management, were also taken into account.
The Solution is Based On
FME Form and FME Flow
Oracle DB
SAP ERP Central Component
The Benefit
Centralization of data integration processes
Strengthening digital sovereignty
Data inventory: homogeneous, up-to-date, quality assured
Replacement of SQL scripts with efficient FME processes
Leveraging SAP ERP data by combining it with geodata
Increased efficiency and performance of data integration processes
Summary
con terra has provided BSR with a future-proof data processing architecture based on the FME platform, which enables efficient and high-performance support for operational processes. The implementation contributes to strengthening digital sovereignty by facilitating the integration of future data-holding systems.
