Friday, December 28, 2018

SAP SQL Data Warehousing

SAP SQL Data Warehousing is reflecting modern trends in data warehousing solutions. It leverages SAP HANA Data Management Suite (HDMS) as foundation the modern data warehousing. It basically brings SQL capabilities to traditional SAP's style of the data warehousing (e.g. BW based).
Moreover, there is a need to address also things like nonSAP data majority that many customers have in their landscape, integration of 3rd party 3rd party DWH solutions, development agility, leveraging existing SQL knowledge and database skills that customers have in their IT department acquired by using non SAP solutions. All this pushes SAP to deliver SQL-based DWH solutions.

What are possibilities of running SAP SQL Data Warehousing?

1. Using SAP BW/4HANA - means combining SAP SQL Data Warehousing with SAP BW. Here best is to leverage BW/4HANA. use cases here can be a consumption of SQL based datamarts and data warehouses by SAP BW. Best case here for SAP customers is running the SAP SQL Data Warehousing and BW/4HANA on same platform/system which contributes to simplify system landscape.

2. Using SAP HANA Data Management Suite (HDMS) – See my blog about the HDMS here. In particular, this use case mostly SAP HANA XS Advanced engine is leveraged plus other tools. In addition, in design phase the future SQL DWH is modeled in SAP Enterprise Architecture Designer (EAD) which is part of HDMS. A next phase is development of the DWH. Here it is possible to clone, edit and build the DWH artefacts using SAP Web IDE for SAP HANA (again part of HDMS). In this case the development artefacts are SAP HANA content and models. The HDMS toolset covers the tools for deploying (HANA Deployment Infrastructure (HDI); Application Lifecycle Management (ALM); External Repository Services) and running (SAP Data Warehousing Foundation tools like: Data Warehouse Scheduler (DWS); Data Lifecycle Manager (DLM); Data Warehouse Monitor (DWM); Data Distribution Optimizer (DDO); etc.) the SQL based DWH as well.

More information:
Getting Started with SAP SQL Data Warehousing

No comments: