sap data warehouse cloud l2 - sapsa - det självklara

PUBLIC

Kenneth Dalvik - SAP Svenska

SAP Data Warehouse Cloud

2PUBLIC© 2020 SAP SE or an SAP affiliate company. All rights reserved. ǀ

AGENDA

• Intro & principles

• SAP Data Warehouse Cloud

• Demo

• Prebuilt Content

• Summary


Main themes & principles

Tactical & strategic reporting &

analysis in data warehouse platform

A data platform is required when data from

several sources are needed and when history

of data is required.

ML and AI is built in to the analytical

applications and data platformsSAP offers several flavours of data

warehousing solutions; On-premise, hybrid or

Cloud

Embedded analytics: Reporting & analysis

at source

Operational reporting done directly in transaction

system where applicable

Agility, flexibility, openness and innovation are key themes


SAP Data platform & AnalyticsComplete offering & statement of direction

ANYPREMISES

SAP BW/4HANA and SAP HANA for SQL data

warehousing are the strategic solutions for on-

premises and private cloud data warehousing.

HYBRID

SAP Data Warehouse Cloud extends

your existing data warehousing

investment to support hybrid cloud.

CLOUD

SAP Data Warehouse Cloud is the

strategic public cloud product offered as

a software service managed by SAP.

SAP HANA

SAP HANA FOR SQL DATA WAREHOUSING

SAP BW/4HANA

Powerful

visualization

Intelligent

augmentation

Business

planningAd-hoc data

exploration

SACAd-hoc data

explorationReporting

visualization

BO

SAP DATA WAREHOUSE CLOUD


Forrester Wave: Data Management for Analytics, Q1 2020

PUBLIC

Version 2020.21

SAP Data Warehouse CloudA scalable, open, and persona-driven warehouse as-a-service tailored for business and IT


Data Warehouse Cloud Overcomes Traditional Problems

and Enables New Solutions

Limited data access

Lengthy time to value

Lack of real-time data

High entry costs

COLLABORATIVECombine information from enterprise data sources and external data sources in spaces dedicated to a specific line of business or use-case

END-TO-ENDGain instant value with pre-built business content and self-service data modeling. Get in control

FASTPower of SAP HANA and in-memory technology for the fastest analytical and database experience and use federation technology to combine sources virtually

ELASTICFlexible and simplified package pricing. Pay for what you use – no strings attached


End-to-End Data

Warehousing

Enabling Data

Democratization

Self-Service Data

Modeling & Analytics

“SAP Data Warehouse Cloud is the strategic public cloud product for all data warehouse scenarios in the cloud.”



Leverage the power of SAP HANA to

instantly access the data you need,

when you need it, without front-

loaded costs. Use federation

technology to combine sources

virtually

FASTOnly pay for what you use and re-

allocate resources quickly and easily

across different use-cases and lines

of business. Separation of storage &

compute

ELASTIC

Designed for both enterprise IT and

line of business users to manage

and gain valuable insights.

Self-service data modeling.

COLLABORATIVE

Integrate data from any source and

consume with powerful native

analytics and business semantics.

END-TO-END

SAP Data Warehouse Cloud is ___________.

SAP HANA Cloud Services


Use case examples

SAC

Agile Data Mart

layer

SAP BW

Self-service Data modeling

• Extend SAP BW with SAP DWC

• Self-service data modeling &

Analytics ( Agile Data mart + BI

tool)

EDW

• Modern Cloud DW + more

• SAP DWC & HANA Cloud = True

• Powerful analytics

• Data lake included

SAC

EDW

S/4

ECC

Lob apps Hyperscaler

Real-time analysis layer

(virtual)

S/4 Lob apps

Operational cross system analysis

• Prebuilt content

• Real-time analytics on multiple

systems incl Hyperscalers

Hyperscaler

SAC

Key Features


The Problem: Most Solutions only Manage Data

Most solutions only focus on the data management. A change in one part, often means manually

changing the other parts.

Integration

Model Data Sources and

Organize Input Flows of data

Analytics

Model the story and semantics of

the data

Governance

Model business

rules and sharing

Data Management

Model the Data Storage

Traditional solutions solve each stage with a different tool and a different model. The end user is left to

reconcile models as and when they change.


Database

• Data Tiering

• Elasticity

• Performance

• HANA Data lake

Business Integration

• Semantics

• Content

• Any data Ingestion, any source

• Standard integration

Analytics

• Augmented BI

• Planning

• Seamless Integration

Data Warehouse Services

• Advanced Modeling

• Collaboration & Governance

• Data Lifecycle Management

• HANA Cloud modeling


The most complete end-to-end enterprise-grade data warehouse in the cloud


The Solution: Spaces empowers LOB users while IT enforces security and governance

TRUSTED

SECURE GOVERNED

SINGLE TRUTH

ELASTIC REPEATABLE

REAL-TIME

HRDATA

CENTRAL COMPANY DATASpace

SpaceHR

R&DDATA

MKTGDATA

FINDATA

SpaceR&D

SpaceFIN

SpaceMKTG • Work collaborative

• Connect enterprise data and own

data

• Analyze, plan, predict

• Create Stories

• Share insights

Spaces empower users

• Control provisioning and

scale

• Enforce quality of service

• Govern enterprise data

Spaces empower IT

Spaces are virtual

• Metadata object

isolation

• Compute and storage

elasticity

• Transparent

monitoring & statistics

• Space permissions

• Connection

management

• SAP HANA Data Lake

Integration


BUSINESS

LAYER

Allow business experts to understand data and accelerate end-to-end decision making

▪ Represent business entities

and relationships with business

language

▪ Promote model standardization

and reuse for greater efficiency

▪ Use your models to power

visualizations once they are

active

▪ Allow business users to work

independently from IT

Business Layer helps you instantly understand data in business terms

Users Work in Business

Terms

CUSTOMER

PRODUCT

SALES PRICE

REVENUE

“What were the key margin drivers for

my product? What if I reduce the price

by 10%?”

DATA

LAYER

HANA handles the data

model

“How can I assure queries will perform

with data coming from heterogenous

systems?”


Meet your cost/performance goals with efficient and scalable storage options

Multiple storage options to meet your volume and performance needs

Smooth data tiering - Hot, Warm, Cold storage

Scalability - Separation of Compute & storage

makes scalability easy

Inbuilt Data lake - SAP HANA Data lake is

optional , but built in. Easy to get started with.

Small

Volume

Medium

Volume

Large

Volume

HUGE

VolumeObject Storage

SAP HANA Data Lake

SAP HANANative Storage Extension

SAP HANAIn Memory

VO

LU

ME

PE

RF

OR

MA

NC

E

PR

ICE

Modeling & Architecture


* According to SAP Data Warehouse Cloud Road Map

This presentation is not subject to your license agreement or any other agreement with SAP. SAP has no obligation to pursue any course of business outlined in this presentation or to develop or release

any functionality mentioned in this presentation. This presentation and SAP's strategy and possible future developments are subject to change and may be changed by SAP at any time for any reason

without notice. This document is provided without a warranty of any kind, either express or implied, including but not limited to, the implied warranties of merchantability, fitness for a particular purpose, or

non-infringement. SAP assumes no responsibility for errors or omissions in this document, except if such damages were caused by SAP intentionally or grossly negligent.

▪ Two different ways available for integrating SAP BW

& SAP BW/4HANA systems:

– Scenario 1: Federated/replicated data consumption

scenarios via

▫ Operational Data Provisioning framework (SAP ABAP

connection)

▫ External SAP HANA Views (SAP HANA connection)

– Scenario 2: Federated/replicated business semantics

integration scenarios via SAP BW/4HANA Model Transfer

connection*

▪ BW query as Business layer only available for SAP

BW/4HANA via SAP BW/4HANA Model Transfer

connection*

Data Sources & Ingestion: SAP BW Integration Overview

Governance

Services

Data Sources &

Ingestion

Repository

Services

Data Modeling

Services

Business Modeling

Service

Security

Services

Consumption &

Business Content


Remote Table

BW BW

InfoProvider

InfoObject

on-premises

Query as

InfoProvider

cloud

Any DBHANA

Remote Table

External HANA Views

HANA

External HANA Views

BW/4HANA

InfoProvider

InfoObject

Query as

InfoProvider

InfoProvider

InfoObject

Query as

InfoProvider

BW

Query

Remote Table

Business View

HT

TP

Business Layer

Data Layer

SA

P H

AN

A C

onnectio

n

SA

P H

AN

A C

onnectio

n

SAP ABAP Connection SAP ABAP Connection SAP ABAP Connection

SA

P B

W/4

HA

NA

Mo

del T

ransfe

r C

onnectio

n


SAP Data Warehouse Cloud & SAP BW/4HANAScenario 1 – Data layer


SAP Analytics

SAP BW/4HANA or SAP BW

Data Layer Business Layer

Powerful

visualization

Intelligent

augmentation

Business

planning

Ad-hoc data

exploration

External

data

BW data

Data layer - Reporting view

BW DSO


SAP Data Warehouse Cloud & SAP BW/4HANAScenario 2 – Business & Data layer


SAP Analytics

SAP BW/4HANA

Data Layer Business Layer

Powerful

visualization

Intelligent

augmentation

Business

planning

Ad-hoc data

exploration

Data layer view

BW DSO

Bex Query

Business layer viewReuse the logic and defintions you have defined in your Bex query


Data Modeling Services: View

Governance

Services

Data Sources &

Ingestion

Repository

Services

Data Modeling

Services

Business Modeling

Service

Security

Services

Consumption &

Business Content

▪ Graphical or script-based (SQL & SQL Script) editor

▪ Define views on top of remote, replicated data

sources, or tables

▪ Create Analytical Datasets, Dimensions or

Relational Datasets

▪ Create Parent-Child or Level-based hierarchies

in Dimension views


Data integration from various

unstructured and structured data

sources

▪ Easy to use data flow based modeling experience for

ETL requirements

▪ Load and combine structured and unstructured data

from different data sources (SAP and non-SAP) like

file storages, DBMS or SAP S/4HANA

▪ Standard transformation capabilities and scripting for

advanced requirements

Data Modeling Services: Data Flow – Overview

Governance

Services

Data Sources &

Ingestion

Repository

Services

Data Modeling

Services

Business Modeling

Service

Security

Services

Consumption &

Business Content







Data Modeling Services: Data Flow – End to End process

Governance

Services

Data Sources &

Ingestion

Repository

Services

Data Modeling

Services

Business Modeling

Service

Security

Services

Consumption &

Business Content

Create Connections Build Data Flow Execute / Schedule

Dataflow

Story Designer /

Data Modeling

▪ Create a connection either in a

central connection management or

inside the context of a space

▪ show available Semantic objects

▪ Browse data sources and select

source data objects

▪ Browse table targets (from repository)

▪ Define transformations and map

source data to target objects

▪ Trigger execution of data flow and

see execution status

▪ Optionally: Schedule* a data flow

and find scheduled job in a job

monitor

▪ Create story based on

loaded data on top of data

warehouse analytical

artifacts

▪ Build new data models on

integrate different data

sources






Security Services – Introducing Data Access Controls

Governance

Services

Data Sources &

Ingestion

Repository

Services

Data Modeling

Services

Business Modeling

Service

Security

Services

Consumption &

Business Content

▪ Fine granular access to certain slices of the data of a given view

▪ Based on authorizations (e.g. In a Sales View, User ‘A‘ can only see

data for region ‘EMEA‘)

Region: EMEA

Region: US


Data Warehouse Cloud – Key benefits

Data ingestion

• Open to any source

• Any Data ingestion method; Batch, real-time replication, streaming and federation

Analytics

• Augmented BI

• Planning

• Seamless Integration to SAP Analytics cloud

• Open to external BI tools

Self-service data modeling

• Business users and IT collaborate around self-service models and self-service data pipelining

Database

• Data Tiering (Hot, Warm, Cold

• Performance in every operation

• HANA engine: OLTP/OLAP , graph, spatial, text

Pre-delivered content SAP Semantics

• Pre delivered SAP content

Cloud Data warehouse

• View modeling or Data flows in one integrated tool

• Elastic price model & separation of storage & compute

• Quarterly releases of new functionality


Demo of Data warehouse cloud

Demo steps:

• Show DWC Welcome page

• Navigate in DWC (Space, Connection, Help)

• Build analytic dataset (View)

• Build Data Flow

• Build & Show SAC dashboardView

Data Flow






Governance

Services

Data Sources &

Ingestion

Repository

Services

Data Modeling

Services

Business Modeling

Service

Security

Services

Consumption &

Business Content

Business Content Packages

SAP Content

▪ Retail – Sales Analysis based on SAP Consumer

Intelligence (Q2/2020) - on SAP CAR & Sales

Intelligence

▪ CFO Dashboard: financial information, personnel costs and

related Human Resource information will be integrated to

provide a comprehensive view on the cost structure.

(H2/2020)

Partner Content (Q2/2020) also listed AppCenter

▪ Adverity GmbH – Marketing Analytics for SAP Data Warehouse Cloud

▪ CubeServ: Procurement Cockpit for SAP Data Warehouse Cloud

▪ datazeit: E-Commerce Insights in SAP Data Warehouse Cloud

▪ Inspired Intellect: Optimizing Order Fulfillment with Machine Learning

▪ KPC: HR Cockpit - Automatic Attendance Tracker

▪ PwC: Sales Insights – One place, all your sales data

▪ Rizing: Lyra Integrated Capacity Planning

▪ s-peers AG: Financial Reporting for SAP Business One

▪ Westernacher: EWM Insights on Data Warehouse Cloud

https://www.sapappcenter.com/


Example of Pre-built solutions for SAP Data Warehouse Cloud

Financial analytics – real-time analytics of S/4 HANA and Successfactors


Example pre-built solutions from Partners

Partner built content for EWM insights

Real time layer ontop of several SAP EWM systems to get a holisitc warehouse management view

https://www.youtube.com/watch?v=H_gijXrPOEY&feature=youtu.be


Flexible and simplified package pricing or pay for what you use

Keeping you in control

One product, all features with total cost transparency

▪ Avoid surprises with clear terms and all-

inclusive packaging

▪ Avoid lock-in with flexibility on usage,

terms, and spending

▪ Gain control into usage and

consumption

BENEFITS

PREDICTABLE

Choose what you

need and spend

what you plan.

FLEXIBLE

Start small and grow at your pace.

Add remove, and reallocate

resources as needed.

TRANSPARENT

What you see

is what you get,

no hidden costs.

SIMPLE

Get all the features

you need in

one package.


Summary

SAC

Agile Data Mart

layer

SAP BW

Self-service Data modeling

• Extend SAP BW with SAP DWC

• Self-service data modeling &

Analytics ( Agile Data mart + BI

tool)

EDW

• Modern Cloud DW + more

• SAP DWC & HANA Cloud = True

• Powerful analytics

• Data lake included

SAC

EDW

S/4

ECC

Lob apps Hyperscaler

Real-time analysis layer

(virtual)

S/4 Lob apps

Operational cross system analysis

• Prebuilt content

• Real-time analytics on multiple

systems incl Hyperscalers

Hyperscaler

SAC


Do you want to try SAP Data Warehouse Cloud?

The purpose of the hands-on exercises are to get you familiar with the Data

Warehouse Cloud solution. There are four runbooks available.

1. The "Simple Start" workshop provides a quick overview of the Data Warehouse

Cloud. It walks participants thru the process of loading data from flat files, creating

a model, and creating analytical stories in the SAP Analytics Cloud.

2. The second runbook provides a deep dive thru Data Warehouse Cloud. It

demonstrates how to create Entity-Relationship views, data views, and creates a

simple analytical story in the SAP analytics cloud.

3. The third runbook (1 of 2) explores the Data Builder in Data Warehouse Cloud. It

demonstrates how to create Joins, Calculated Columns, Aggregation and Hierarchies

using Graphical views, SQL views and Entity-Relationship views. Data are also

loaded from flat files and tables federated from HANA Cloud.

4. In the forth runbook (2 of 2) we will leverage the model created in the 'Data

Modeling in Data Builder' exercise to consume and visualize the data by means of a

dashboard.

90 day POC environment

Get a trial environment where you can work with your data

The system will be available for 90 days with full functionality where you can

build E2E scenarios, incl your own connections.

Presales resources from SAP Sweden will be supporting and involved in the

POC.

The POC should have clear evaluation use cases and success criteria's.

Any solutions built in the POC cannot be migrated to a productive

environment.

Partner resources can be involved in POC work

No cost for you as a customer

Contact [email protected] or your partnerPlanned to be hosted by SAPSA

mailto:[email protected]


More Information about SAP Data Warehouse Cloud

Find out more at www.sapdatawarehouse.cloud

• Onboarding Guide

• Learning Academy

• Blogs

SAP Help Documentation

Calculator

SAP Road Map Explorer

SAP Community

Sample Content on GitHub

Provide your feedback:

http://www.sapdatawarehouse.cloud/

https://help.sap.com/viewer/product/SAP_DATA_WAREHOUSE_CLOUD

http://www.sap.com/datawarehousecloudcalculator

https://roadmaps.sap.com/board?PRODUCT=73555000100800002141

https://community.sap.com/topics/data-warehouse-cloud

https://github.com/SAP-samples/data-warehouse-cloud-content

https://sapinsights.eu.qualtrics.com/jfe/form/SV_4MTPIPCyPhApK8R

Thank you.

Kenneth Dalvik

Presales Enterprise Architect

SAP Svenska

+46707895131

[email protected]

SAP Data warehouse cloud as EDW







Data Sources Overview

Governance

Services

Data Sources &

Ingestion

Repository

Services

Data Modeling

Services

Business Modeling

Service

Security

Services

Consumption &

Business Content

Q4 2020*

Amazon Redshift

Azure ADLS Amazon S3

Google GCS

H1 2021*Current

Delivered Planned* Partner

Partners

Datazeit

APOS150+ Sources

Snaplogic500+ Sources

Informatica140+ Sources

Adverity400+ Sources

Precog

SAP HANA Data Lake SAP IBPSAP Sybase IQ

New Connection Tiles

SAP BW

SAP BW/4HANA Model Transfer

SAP BPC

SAP Open Connectors

Teradata IBM DB2

MySQL

SFTP

Google BigQuery

Azure Synapse

RESTful Webservices

Amazon Athena

SAP Source System Connectivity

ABAP DDIC TablesABAP Extractors ABAP CDS

SAP BW/4HANABW InfoProvider

ABAP ODP BW Query-as-a-Provider

SAP S/4HANA Cloud

SAP Business One

SAP HANA 1.0 SAP HANA 2.0 HDI SAP HANA Cloud

SAP SuccessFactors


Connection Tiles

SAP ABAP Generic ODataSAP HANA

Microsoft SQL Server Oracle Local CSV File

Generic Cloud Data Integration Adverity SAP ECC

SAP S/4HANA

HDFS

Azure SQL Database

New Connection Tiles

SAP HANA Cloud

SAP S/4HANA CloudSAP Fieldglass

SAP Marketing Cloud

CamelJDBC Qualtrics

Dremio Azure Analysis Services

Dynamo DB PostgreSQL

Source System Connectivity Apache Cassandra

https://www.apos.com/content/apos-live-data-gateway

https://www.snaplogic.com/snaps

https://www.informatica.com/products/cloud-integration/connectivity/connectors.html

https://www.adverity.com/data-connectors/


API 3rd-Party consumption

Applications

Architecture

A comprehensive approach to data warehousing for instant data-to-value

On-Premise SourcesExternal Cloud SourcesSAP Cloud Sources

PredictiveAnalytics

SAP HANA Cloud

API 3rd-Party

Data Load

3rd-Party

Data Lake

In-Memory Disk, Data LakeStorage

Connectivity ReplicationVirtual Access

SAP Analytics Cloud Integration

Repository

Services

Data Modeling

Services

Governance

Services

Business Modeling

Services

Security

Services

Data

Ingestion

Data

Sources

Consumption

SAP Data

Warehouse

Cloud

Bu

sin

ess C

on

ten

t


API 3rd-Party consumption

Applications

EDW Architecture

On-Premise Sources

SAP BW, SAP S/4, SAP CAR, SAP

EWM

External Cloud Sources

Hyper-scalers; AWS, Azure,

Google

SAP Cloud Sources

SF, Concur, Ariba, Hybris

PredictiveAnalytics

SAP HANA Cloud (Core EDW layer) IT

API 3rd-Party

Data Load

3rd-Party

Data Lake

In-Memory Disk, Data LakeStorage

Connectivity ReplicationVirtual Access

SAP Analytics Cloud Integration

Data

Ingestion

Data

Sources

Consumption

SAP Data

Warehouse

Cloud

Bu

sin

ess C

on

ten

t

Data Mart/Consumption layer IT & Business

Virtual or persisted






Governance

Services

Data Sources &

Ingestion

Repository

Services

Data Modeling

Services

Business Modeling

Service

Security

Services

Consumption &

Business Content

Space

Platform


Business Builder

Data Builder

Data Flow Builder

Monitoring

Scheduling

Database Explorer

Space Management

SAP HANA Cloud – DB-Tenant

SAP Cloud

Platform & ext.

Tooling

SAP IDE

SQL Editor

Data Integration

Others…

SAP Analytics Cloud 3rd party Visualization

Data Modeling

Connections

ABAP HANA

SQL Server

OData

Oracle …

Data Layer

Business Layer

CUSTOMER

PRODUCT

SALES PRICE

REVENUE

Editors

▪ SAP Data Warehouse Cloud

▪ Editors empower Business & IT Users to

create End-to-End Scenarios

▪ Data is accessed, processed, federated and

persisted using SAP HANA Cloud

▪ SAP Cloud Platform & external Tooling are enabled to connect, access and process

data, governed by SAP Data Warehouse Cloud

▪ HANA Artefacts, like: Calculation View

Open SQL

Schema 1

Open SQL

Schema n

…

…

HDI

Container 1

HDI

Container n

SAP SQL data warehousing Integration: Integrated SQL DW


Business and IT collaborate throughout the data-to-insight lifecycle

with the best tools to get the job done

Command-

line and graphic

modelling in SAP IDE

Intuitive views and

graphic modelling in

SAP Data Warehouse

Cloud Data Builder

IT driven development

Self-Service data modeling


EDW Architecture

Application Datastore

Cloud Environment

On-Premise Environment

SAP Analytics Cloud

Stories Analytic & Planning ModelsSmart Predict

SAP DWC

HANA Cloud Data lake

External tools

3:rd party API

Data mart/Consumption layer

Cold storage

IT & Business

Virtual or Persisted

Disk or In-memory

Analysis for Office

HANA Tables

Warm & Hot storage

Views

Core layer

Staging & history







Data Modeling Services: Data Flow – Transformation Capabilities

Governance

Services

Data Sources &

Ingestion

Repository

Services

Data Modeling

Services

Business Modeling

Service

Security

Services

Consumption &

Business Content

▪ Combine structured, semi-structured and unstructured data

▪ Operators for Projection, Aggregation, Join, Filter, Union, Add Table

▪ Data source can be tables, CDS views, remote files, OData

▪ Outlook*: Case, Lookup, Cleanse, Rules and JSON, Excel, XML

Standard Transformations Scripting

▪ Advanced transformation requirements like extraction of text

▪ Embedded scripting editor in Data Flow Modeler

▪ Support of standard Phyton 3 scripting language

sap data warehouse cloud l2 - sapsa - det självklara

Documents