Showing posts with label DWH. Show all posts
Showing posts with label DWH. Show all posts

Friday, December 28, 2018

SAP Enterprise Architecture Designer (EA Designer or EAD)

Within the SAP HANA Data Management Suite (HDMS) there is a central tool which serves as single point of design, documentation and reference from enterprise architecture (EA) point of view.
It can be used for capturing, analyzing, present of many artefacts important in architecting of IT objects. These objects can be landscapes, systems, strategies, data, biz processes, requirements, application modeling and other used in the IT environments. Depicting the mentioned objects by industry standards, using metadata and diagrams enables proper understanding of the EAD’s outcomes in different stages of the IT projects.

Short example of different diagram types that are supported by the tool:

- Business Process diagrams (e.g. BPMN 2.0: descriptive and executable)
- Conceptual Data, Physical data modeling & data architecture: Tables & Views, Virtual table definitions, Data Movement Models (Flowgraphs), Native DataStore Objects, HANA CDS associations
- Data Movement Diagram
- Enterprise Architecture Diagram
- NoSQL Document Schema (JSON)
- Process Map
- Requirements List

Here are few examples of capabilities that are supported by the tool:

Integrated design - Translate business strategy to technical implementation requirements
Development automation - Generate architecture and technical artifacts automatically
Corporate knowledge - Drive collaboration from a single point of truth for all stakeholders
Flexible deployment - Deploy artifacts to SAP HANA or SAP Cloud Platform

The tool is web based so user is using web browser all the time while using the tool. It aims to support comprehensive end-to-end modeling experience. It has reverse engineering capabilities too. It supports model comparison, lineage and impact analysis. It saves generated SAP HANA HDI compatible files to either local ZIP files (for later import to SAP Web IDE) or to Git Repository (for Git integration to SAP Web IDE).

The tool has its place in data warehousing are as it is used in SAP SQL Data Warehousing solution. Here it servers during design phase where the new SQL based DWH is being modeled in the tool. The models that are needed for such a DWH includes: Conceptual Data Model (CDM), Physical Data Model (PDM), LifeCycle Metamodel, CalcView, Data Movement Model.

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