HANA SQL DWH
& Applications

Take a significant step towards
MODERN DATA WAREHOUSING

With HANA SQL Data Warehouse, SAP offers an approach aligned with today's requirements for a modern data warehouse. Agility, model-driven development, Data Vault, Data Warehouse Automation, cloud orientation, and open software standards are key aspects here.

Our Experience
IN CURRENT DWH PRACTICE

Previously, SAP offered Business Warehouse as an integrated development and runtime environment for data warehousing. However, practical experience showed that SAP Business Warehouse did not cover all business areas, leading many companies to develop additional data warehouse systems alongside Business Warehouse, often based on SQL database systems from other vendors. Furthermore, some companies opted against using Business Warehouse.

With the introduction of HANA as a platform, SAP also provided the fundamental capability to develop analytical systems based on native HANA techniques. What began as loosely coupled tools for building a SQL-based Data Warehouse (DWH) evolved into an integrated toolset that aligns with the general market standard for developing SQL-based DWHs.

Concurrently, a methodology was developed that, considering development standards and drawing upon modern software development methods, optimally utilizes SAP-specific tools

Modern Data Warehousing
YOUR BENEFITS AND OUR APPROACH

With over five years of experience, we are market leaders in developing SAP HANA SQL Data Warehousing solutions and HANA-based applications. Our experience and close partnership with SAP are further demonstrated by the fact that we developed the SAP training course HDW410 – SAP HANA SQL Data Warehouse and regularly conduct it in the DACH region.

1) Model-Driven

“Model-Driven” defines an approach where modeling is the core activity in an integrated development process. All other activities are derived from the defined models.

Your Benefits

Communication Basis with Business Stakeholders
Business Modeling
Transparency
Standardized Notations
High Quality
Consistent Metadata

Our Approach

Business Model Linked with IT Data Model
Generability of Development Objects
Lineage, Impact, and Usage Analyses
Modeling Conventions
Business Glossary
Centralized Documentation

2) Agile

Agility reduces the time from requirement to delivery.

Your Benefits

Faster Delivery
Shorter Time to Value
Reduced Complexity
Enhanced Development Performance
Sustained High Quality Over Time

Our Approach

Agile Project Methodology Scrum
Agile Development Process DevOps
Iterative and Incremental Approach
Small Delivery Units
Continuous Integration, Continuous Testing, and Continuous Delivery

3) Cloud Ready

“Cloud Ready” emphasizes independence from technical infrastructure and the reusability of development artifacts.

Your Benefits

Flexible Implementation Options
(On-Premises / Cloud)
Future-Proof Architecture
Independence from Technical Infrastructure

Our Approach

CF & XSA as a Development Platform
Delivery of Development Artifacts in Containers
Decoupled Development and Runtime Environment
Transformation of a Data Warehouse Architecture into a Flexible XSA and CF Architecture

4) Openness

Your Benefits

Extensive Customization Options
Independent of Third-Party Vendors
Individual Components are Interchangeable at Any Time
Facilitates a Sustainable Best-of-Breed Setup
Potential Synergies from Utilizing Existing Tools

Our Approach

Establishment of the DWH as a Technology Platform with Freely Selectable Components
Extension of SAP-Proprietary Technology through Open Standards and Open Source Software
Alignment of Architecture and Modeling for Maximum Openness

Whitepaper
Hybrid SAP HANA Data Warehouse Architectures

SAP offers three distinct data warehouse solutions: SAP BW/4HANA, SAP HANA SQL Data Warehousing, and SAP Data Warehouse Cloud. In this whitepaper, we aim to elaborate on the advantages and challenges of hybrid architectures encompassing these three approaches.