Challenge: Defining the Data Problem
SAP’s Datacenter & Infrastructure Build unit generates vast amounts of operational and reporting data. To handle all of this, the unit relied on multiple databases for extraction and transformation. The ever-growing layers of the previous ETL solution lead to increasing complexity.
The complicated queries being run by the unit reached the limit of what the previous data warehousing solution could provide in terms of performance and optimization. To fix this complexity, the Datacenter & Infrastructure Build unit needed to streamline their entire landscape and bridge their different data sources together. SAP Data Warehouse Cloud was the perfect tool for this task.
Solution: Simplifying with SAP Data Warehouse Cloud
The Datacenter & Infrastructure Build unit seamlessly integrated SAP Data Warehouse Cloud into their existing landscape. Instead of doing the less efficient ETL (Extract, Transform, and Load) through multiple databases, SAP Data Warehouse Cloud enables them to perform ELT using one database. This benefit, plus having just one central data access layer, reduces complexity significantly.
Through this newly gained flexibility, the unit simplified their queries. They can now split complex queries that originally had 7,200 lines of code into multiple, manageable, and reusable smaller queries. The data lineage then provides a very good overview of these data transformations and all their dependencies. This flexibility extends even further, as it’s much easier to add new datasets whenever needed. Now, the unit further improves delivery times for new reports.
SAP Data Warehouse Cloud connects to different visualization tools. By consuming these sharable data models with the BI solution, the Global Cloud Services organization gain a clear overview of and valuable insights from their data.