sap data warehouse cloud l2 - sapsa - det självklara
Post on 29-May-2022
12 Views
Preview:
TRANSCRIPT
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
3PUBLIC© 2020 SAP SE or an SAP affiliate company. All rights reserved. ǀ
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
4PUBLIC© 2020 SAP SE or an SAP affiliate company. All rights reserved. ǀ
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
5PUBLIC© 2020 SAP SE or an SAP affiliate company. All rights reserved. ǀ
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
7PUBLIC© 2020 SAP SE or an SAP affiliate company. All rights reserved. ǀ
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
8PUBLIC© 2020 SAP SE or an SAP affiliate company. All rights reserved. ǀ
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.”
SAP Data Warehouse Cloud
9PUBLIC© 2020 SAP SE or an SAP affiliate company. All rights reserved. ǀ
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
10PUBLIC© 2020 SAP SE or an SAP affiliate company. All rights reserved. ǀ
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
12PUBLIC© 2020 SAP SE or an SAP affiliate company. All rights reserved. ǀ
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.
13PUBLIC© 2020 SAP SE or an SAP affiliate company. All rights reserved. ǀ
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
SAP Data Warehouse Cloud
The most complete end-to-end enterprise-grade data warehouse in the cloud
14PUBLIC© 2020 SAP SE or an SAP affiliate company. All rights reserved. ǀ
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
15PUBLIC© 2020 SAP SE or an SAP affiliate company. All rights reserved. ǀ
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?”
16PUBLIC© 2020 SAP SE or an SAP affiliate company. All rights reserved. ǀ
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
18PUBLIC© 2020 SAP SE or an SAP affiliate company. All rights reserved. ǀ
* 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
SAP Data Warehouse Cloud
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
19PUBLIC© 2020 SAP SE or an SAP affiliate company. All rights reserved. ǀ
SAP Data Warehouse Cloud & SAP BW/4HANAScenario 1 – Data layer
SAP Data Warehouse Cloud
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
20PUBLIC© 2020 SAP SE or an SAP affiliate company. All rights reserved. ǀ
SAP Data Warehouse Cloud & SAP BW/4HANAScenario 2 – Business & Data layer
SAP Data Warehouse Cloud
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
21PUBLIC© 2020 SAP SE or an SAP affiliate company. All rights reserved. ǀ
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
22PUBLIC© 2020 SAP SE or an SAP affiliate company. All rights reserved. ǀ
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
23PUBLIC© 2020 SAP SE or an SAP affiliate company. All rights reserved. ǀ
* 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.
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
24PUBLIC© 2020 SAP SE or an SAP affiliate company. All rights reserved. ǀ
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.
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
25PUBLIC© 2020 SAP SE or an SAP affiliate company. All rights reserved. ǀ
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
27PUBLIC© 2020 SAP SE or an SAP affiliate company. All rights reserved. ǀ
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
28PUBLIC© 2020 SAP SE or an SAP affiliate company. All rights reserved. ǀ
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.
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
29PUBLIC© 2020 SAP SE or an SAP affiliate company. All rights reserved. ǀ
Example of Pre-built solutions for SAP Data Warehouse Cloud
Financial analytics – real-time analytics of S/4 HANA and Successfactors
30PUBLIC© 2020 SAP SE or an SAP affiliate company. All rights reserved. ǀ
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
31PUBLIC© 2020 SAP SE or an SAP affiliate company. All rights reserved. ǀ
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.
32PUBLIC© 2020 SAP SE or an SAP affiliate company. All rights reserved. ǀ
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
33PUBLIC© 2020 SAP SE or an SAP affiliate company. All rights reserved. ǀ
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 kenneth.dalvik@sap.com or your partnerPlanned to be hosted by SAPSA
34PUBLIC© 2020 SAP SE or an SAP affiliate company. All rights reserved. ǀ
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:
Thank you.
Kenneth Dalvik
Presales Enterprise Architect
SAP Svenska
+46707895131
kenneth.dalvik@sap.com
SAP Data warehouse cloud as EDW
37PUBLIC© 2020 SAP SE or an SAP affiliate company. All rights reserved. ǀ
* 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.
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
SAP Data Warehouse Cloud
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
38PUBLIC© 2020 SAP SE or an SAP affiliate company. All rights reserved. ǀ
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
39PUBLIC© 2020 SAP SE or an SAP affiliate company. All rights reserved. ǀ
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,
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
40PUBLIC© 2020 SAP SE or an SAP affiliate company. All rights reserved. ǀ
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.
Governance
Services
Data Sources &
Ingestion
Repository
Services
Data Modeling
Services
Business Modeling
Service
Security
Services
Consumption &
Business Content
Space
Platform
SAP Data Warehouse Cloud
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
41PUBLIC© 2020 SAP SE or an SAP affiliate company. All rights reserved. ǀ
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
42PUBLIC© 2020 SAP SE or an SAP affiliate company. All rights reserved. ǀ
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
43PUBLIC© 2020 SAP SE or an SAP affiliate company. All rights reserved. ǀ
* 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.
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
top related