Centralizing the Data Warehouse for a Leading Technology Com

INTRODUCTION The IT-Department of a leading manufacturing company wanted to become more structured and performant. With increasing data usage, the customer asked for an optimized and more structured approach for handling data. CASE DESCRIPTION The IT-Department of the technology and manufacturing company focuses on data-driven decisions and therefore tries to work with a huge amount of data from different data sources. The goal is to turn the data into knowledge which means that the data, (simple set of characters and symbols), has to be collected and put in a certain context to gain a certain value for the customer/user. The current solution has its limitations because of the architecture. Currently, the data is stored on sev- eral Data Warehouses which all run separately on different databases. With this situation, a certain silo-landscape developed where every data source is protected. This leads to a limitation regarding performance, scalability and agility for the current model. The customer, moreover, aims to have one solution where all the data is stored centrally without any harder borders.

The IT-Department approached Scalefree for deep technical expertise to solve the problem.

The main aspects of the POC were to collect all data from different data warehouses and put them in one central database only. Additionally, the Data Vault 2.0 model should be implemented as well. To satisfy the customer’s requirements, Scalefree migrated the data from SAP HANA to Snowflake. This led to increased efficiency because of the centralized data collection. Furthermore, analysis could be executed faster since the operations can be done in one database which significantly reduced the costs. On top of that, the already mentioned Data Vault 2.0 structure was used to develop informa- tion marts.

With this POC, the development team was able to have a more structured and flexible way to handle existing and incoming data because of the new architecture as well as the Data Vault 2.0 structure. Besides this, the Data Vault approach is able to reuse old business rules which secures data consis- tency. Lastly, the overall performance boost allowed a reduction in costs.

Centralizing the Data Warehouse for a Leading Technology Company © Scalefree International GmbH 2023

2/3

Powered by