Customer success

How innogy is preparing for the future with a digital platform

At a glance

  • Data Analytics system in the Azure cloud enables flexible growth
  • All user groups can work with data and generate new values
  • Data from SAP BW can be seamlessly integrated into analyses

The business situation of our client

In many companies, long-standing analytics systems are increasingly reaching their limits. They can no longer cope with the constantly growing number of users and data – and with them the ever increasing demands on data analysis. As a result, a great deal of potential for business remains unused.

The energy supplier innogy also found itself in this situation and turned to us for help. The company needed a future-proof platform that met the following requirements:

  • New data sources can be connected quickly and easily
  • Data can be made available to the largest possible group of users
  • Grow flexibly as new requirements arise
  • Data-driven innovations can be implemented easily
  • The efficiency of company-wide data analysis is increased

A particular challenge was to integrate an existing SAP BW on Hana into the solution. Above all, this data should later be seamlessly available across the entire system.

innogy Projektbericht ORAYLIS

The solution for our client

Due to the high demands on flexibility and future-proofing, we built innogy’s new data analytics platform in the Microsoft Azure Cloud. Our platform consists of a data warehouse with classic layer architecture as well as a Data Lake to which new data sources can be quickly connected and used by defined user groups. This means that data from SAP BW can also be accepted, processed and made available very easily.

The Microsoft services Power BI and Excel are primarily available as analysis tools. However, third-party tools can also be used if required. In this way, the needs of all user groups can be covered. It is possible to automatically provide business users with interactive standard reports as well as to give data scientists and business analysts the necessary freedom for ad-hoc analyses. Comprehensive authorisation concepts regulate access to the data.

How data turns into new value

With the new cloud platform, innogy is now optimally positioned for the future in the value-oriented use of its data:

  • The platform can grow flexibly with new requirements at any time
  • Data scientists, business analysts and specialist users can all create new value from data in equal measure
  • Data is quickly and easily available to business departments for analytical purposes
  • Staff can concentrate on the core tasks of value-oriented data analysis
  • Efficiency has increased while costs have decreased
  • The protection of sensitive data is fully ensured


turn your data into value.

At a glance

  • Data Analytics system in the Azure cloud enables flexible growth
  • All user groups can work with data and generate new values
  • Data from SAP BW can be seamlessly integrated into analyses
Jens Kröhnert
turn your data into value

Let’s get started!

Do you also want to optimally use the potential of your data and open up new business opportunities?

Join #teamoraylispeople

Shape the world
of data with us

Customer success

From SAP to Microsoft BI: Krones AG modernises its data analysis

Jonas Heindl
Teamleader Business Intelligence, KRONES AG

With ORAYLIS, we have gained a long-standing partner with a lot of competence and reliability. Originally, we used various solutions for the evaluation of our data. These included an SAP BW and an Oracle DWH. This meant that we did not have a uniform database that would have given our employees worldwide a comprehensive view of all data and the corresponding analysis scenarios. Practically every department benefits from our new solution – and first and foremost the customer.

At a glance

  • Client: Krones AG
  • Sector: Industry/Filling and packaging technology
  • Project objective: Integration of SAP and Oracle data on a uniform Microsoft platform
  • Technologies: Microsoft SQL Server, Excel, SAP modules, Theobald connector

“Progress” has always been a top priority at Krones AG: The company was founded in 1951 as a classic machine manufacturer. Since then, Krones has developed to the world’s leading supplier of system technology with various subsidiaries, whereby the portfolio includes modern systems from the areas of process, filling and packaging technology. In order to be able to continue to live up to this claim to leadership in the face of global competition, those responsible had to seize the opportunities offered by digitisation and convert their constantly growing data stocks as comprehensively as possible into new values for the business, the employees and, above all, the customers. The starting point for this was the company’s disparate system landscape.

Zentrale Krones AG

Analysis functions were limited

“Originally, we used various solutions to evaluate our data,” explains Jonas Heindl, Team Leader Business Intelligence at Krones AG. “These included an SAP BW and an Oracle DWH with Business Objects. So we didn’t have a consistent, uniform database available that would have given our employees worldwide a comprehensive view of all data and corresponding application scenarios.” In the same way, the individual systems did not meet the demands in terms of performance and analysis possibilities. “The specialist departments could only carry out independent evaluations to a very limited extent and with great effort. Therefore, we decided to replace the existing technologies with a modern, integrated Enterprise Data Warehouse (DWH) with a self-service approach. Whereby the work on the new solution was, of course, not allowed to influence the ongoing business.”

All data on one platform

Thus, with ORAYLIS as implementation partner, a group-wide enterprise data warehouse based on Microsoft technologies was set up in parallel with current SAP developments, and the changeover went absolutely smoothly. “This platform provides Krones with a so-called single point of truth for the first time,” explains Matthias Petig, Senior Consultant at ORAYLIS. “All relevant source systems are consolidated here, such as the SAP ERP and CRM or even the telephone system and planning applications. Data is then updated automatically from the source systems to the analysis cubes of the specialist departments.”

As part of the self-service approach, departmental and power users now create and manage all analyses independently. In addition to tools for ad-hoc analysis, templates are also provided for all necessary standard reports. For the first time, the management receives a uniform board report folder on all key figures. The higher-level functionalities include, in part, multilingual evaluations and the consideration of multi-level authorisations.

Benefits for the client and Krones AG

“Thanks to the easy handling of the analysis tools, the new solution has been very well received by our users,” says Jonas Heindl. “Practically every department benefits from it – and first and foremost the client.” For example, availability analyses and targeted staff scheduling have a positive effect on customer service. The same applies to the analysis of order and complaint processes. With a 360° view of customers and their assets, the sales department can track details of all orders and respond to quotation requests more quickly. Likewise, customer and market potentials can be determined in a well-founded manner.

Meanwhile, Marketing can evaluate its campaign successes in detail and manage them with foresight, so that advertising funds are invested much more efficiently. Purchasing has the opportunity to take a closer look at price developments and suppliers. In production, the evaluation of production data optimises throughput times and the use of personnel and materials. At the same time, the evaluation of material stocks ensures better warehouse utilisation and capital commitment. Finally, the finance and controlling department has a much better basis for decision-making thanks to an automated solution for internal and external reporting. In addition, a valid control of costs and revenues, including profit and loss accounting, is made possible.

Last but not least, Krones has created a basis for the further digitisation of its business: “From a long-term perspective, our aim is to implement data-driven scenarios from the field of Industry 4.0. The new solution provides an excellent basis for this,” says Jonas Heindl.


turn your data into value.

At a glance

  • Client: Krones AG
  • Sector: Industry/Filling and packaging technology
  • Project objective: Integration of SAP and Oracle data on a uniform Microsoft platform
  • Technologies: Microsoft SQL Server, Excel, SAP modules, Theobald connector
Dirk Ohligschläger
turn your data into value

Let’s get started!

Do you also want to merge your data stocks from outdated systems such as SAP and Oracle on a modern analysis platform and thus create a stable basis for the digitalisation of your business?

Join #teamoraylispeople

Shape the world
of data with us

Customer success

How to make your production more efficient with real-time data

At a glance

  • Manufacturer of special pumps monitors its entire production in real time
  • Companies, customers and employees benefit from more transparency and improved processes
  • Solution connects local SAP ERP with services in the Azure Cloud

The business situation of our client

Production processes must be as efficient as possible in order for companies to survive in global competition. This was also recognised by one of our industrial customers, a global leader in the manufacture of special pumps. Together, we implemented a monitoring system based on real-time data for its entire production line and achieved a large number of improvements as a result. Because: Up until this point, neither the production status nor the progress of an order could be tracked. The finished goods usually reached the shipping department without notice.

The solution for our client

Our customer’s production process involves pushing the picked individual parts of a pump from one production cell to the next on a transport trolley. In our solution, each trolley receives its own RFID tag, which is linked to the relevant order. The individual manufacturing cells are equipped with corresponding RFID gates. We process the resulting data stream via a real-time route based on services from the Microsoft Azure cloud: An Azure Event Hub receives the data and distributes it further. The data is then analysed in real time via Azure Stream Analytics. We have also connected a local SAP ERP with quality-assured reference data. Only by linking it to the SAP data do the findings from the real-time information gain concrete significance. Finally, the data is visualised via a real-time monitoring dashboard in Power BI.

How data turns into new values

The data-driven real-time monitoring generates new values for our customer on very different levels. The status quo of each individual pump can now be precisely tracked. Likewise, those responsible can obtain an overview of all current orders in real time. As a result, the various production steps can be coordinated much more precisely. For example, the efficiency of the employees in the production cells has increased significantly, as they are now informed about upcoming orders at an early stage. And of course, the company’s customers are also much more satisfied: they receive much more precise information about the status and delivery date of their goods.


turn your data into value.

At a glance

  • Manufacturer of special pumps monitors its entire production in real time
  • Companies, customers and employees benefit from more transparency and improved processes
  • Solution connects local SAP ERP with services in the Azure Cloud
Jens Kröhnert
turn your data into value

Let’s get started!

Would you like to analyse your data in real-time to make business and production processes more effective and customer-friendly?

Join #teamoraylispeople

Shape the world
of data with us