SAP Data Warehouse Cloud L2 - Sapsa.se

Transcription

SAP Data Warehouse CloudKenneth Dalvik - SAP SvenskaPUBLIC

AGENDA Intro & principles SAP Data Warehouse Cloud Demo Prebuilt Content Summary 2020 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC2

Main themes & principlesAgility, flexibility, openness and innovation are key themesEmbedded analytics: Reporting & analysisat sourceOperational reporting done directly in transactionsystem where applicableSAP offers several flavours of datawarehousing solutions; On-premise, hybrid orTactical & strategic reporting &analysis in data warehouse platformA data platform is required when data fromseveral sources are needed and when historyof data is required.ML and AI is built in to the analyticalapplications and data platformsCloud 2020 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC3

SAP Data platform & AnalyticsComplete offering & statement of directionBOReportingvisualizationAd-hoc dataexplorationSAP HANA FOR SQL DATAWAREHOUSINGSACAd-hoc mentationBusinessplanningSAP BW/4HANASAP DATA WAREHOUSE CLOUDSAP HANAANYPREMISESHYBRIDCLOUDSAP BW/4HANA and SAP HANA for SQL dataSAP Data Warehouse Cloud extendsSAP Data Warehouse Cloud is thewarehousing are the strategic solutions for on-your existing data warehousingstrategic public cloud product offered aspremises and private cloud data warehousing.investment to support hybrid cloud.a software service managed by SAP. 2020 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC4

Forrester Wave: Data Management for Analytics, Q1 2020 2020 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC5

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

Data Warehouse Cloud Overcomes Traditional Problemsand Enables New SolutionsCOLLABORATIVELimited data accessLengthy time to valueLack of real-time dataHigh entry costsCombine information from enterprise data sources andexternal data sources in spaces dedicated to a specific line ofbusiness or use-caseEND-TO-ENDGain instant value with pre-built business content and selfservice data modeling. Get in controlFASTPower of SAP HANA and in-memory technology forthe fastest analytical and database experience and usefederation technology to combine sources virtuallyELASTICFlexible and simplified package pricing.Pay for what you use – no strings attached 2020 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC7

SAP Data Warehouse Cloud“SAP Data Warehouse Cloud is the strategic public cloud productfor all data warehouse scenarios in the cloud.”Self-Service DataModeling & Analytics 2020 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLICEnabling DataDemocratizationEnd-to-End DataWarehousing8

SAP Data Warehouse Cloud is .COLLABORATIVEEND-TO-ENDDesigned for both enterprise IT andIntegrate data from any source andline of business users to manageconsume with powerful nativeand gain valuable insights.analytics and business semantics.Self-service data modeling.FASTELASTICLeverage the power of SAP HANA toOnly pay for what you use and re-instantly access the data you need,allocate resources quickly and easilywhen you need it, without front-across different use-cases and linesloaded costs. Use federationof business. Separation of storage &technology to combine sourcescomputevirtually 2020 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC9SAP HANA Cloud Services

Use case examplesOperational cross system analysisEDWSelf-service Data modelingSACAgile Data MartlayerS/4ECCSAP BWSACSACEDWReal-time analysis layer(virtual)Lob appsS/4HyperscalerLob appsHyperscaler Extend SAP BW with SAP DWC Modern Cloud DW more Prebuilt content Self-service data modeling &Analytics ( Agile Data mart BItool) SAP DWC & HANA Cloud True Powerful analyticsReal-time analytics on multiplesystems incl Hyperscalers Data lake included 2020 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC10

Key Features

The Problem: Most Solutions only Manage DataMost solutions only focus on the data management. A change in one part, often means manuallychanging the other parts.IntegrationData ManagementGovernanceAnalyticsModel Data Sources andModel the Data StorageModel businessModel the story and semantics ofrules and sharingthe dataOrganize Input Flows of dataTraditional solutions solve each stage with a different tool and a different model. The end user is left toreconcile models as and when they change. 2020 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC12

SAP Data Warehouse CloudThe most complete end-to-end enterprise-grade data warehouse in the cloudBusiness IntegrationDatabaseData Warehouse ServicesAnalytics Semantics Data Tiering Advanced Modeling Augmented BI Content Elasticity Collaboration & Governance Planning Any data Ingestion, any source Performance Data Lifecycle Management Seamless Integration Standard integration HANA Data lake HANA Cloud modeling 2020 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC13

The Solution: Spaces empowers LOB users while IT enforces security and governanceSpaces empower usersSpaces are virtual Metadata objectisolation HRMKTGSpaceSpace Compute and storageelasticityHRMKTGDATADATACENTRAL COMPANY DATA Space permissionsR&DFINDATADATAR&DFINSpace ConnectionmanagementWork collaborative Connect enterprise data and owndataSpace Transparentmonitoring & statistics Analyze, plan, predict Create Stories Share insightsSpaceSpaces empower IT SAP HANA Data LakeIntegration Control provisioning andscaleSECUREGOVERNEDREAL-TIME Enforce quality of serviceTRUSTEDELASTICREPEATABLE Govern enterprise dataSINGLE TRUTH 2020 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC14

Business Layer helps you instantly understand data in business Users Work in BusinessTermsDATAHANA handles the dataLAYERmodel Represent business entitiesand relationships with businesslanguage Promote model standardizationand reuse for greater efficiency Use your models to powervisualizations once they are“What were the key margin drivers formy product? What if I reduce the priceby 10%?”“How can I assure queries will performwith data coming from heterogenoussystems?” Allow business users to workindependently from ITactiveAllow business experts to understand data and accelerate end-to-end decision making 2020 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC15

Multiple storage options to meet your volume and performance needs Smooth data tiering - Hot, Warm, Cold storageSmallSAP HANAVolumeNative Storage ExtensionSAP HANAData LakeObject StorageLargeVolumePRICE Inbuilt Data lake - SAP HANA Data lake isoptional , but built in. Easy to get started with.MediumSAP HANAVolumeVOLUME Scalability - Separation of Compute & storagemakes scalability easyPERFORMANCEIn MemoryHUGEVolumeMeet your cost/performance goals with efficient and scalable storage options 2020 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC16

Modeling & Architecture

GovernanceServicesData Sources &IngestionRepositoryServicesData ModelingServicesBusiness ModelingServiceSecurityServicesConsumption &Business ContentData Sources & Ingestion: SAP BW Integration Overview Two different ways available for integrating SAP BW& SAP BW/4HANA systems:– Scenario 1: Federated/replicated data consumptionscenarios viaSAP Data Warehouse CloudBusiness Viewconnection)Remote TablecloudSAP ABAP Connection BW query as Business layer only available for SAPBW/4HANA via SAP BW/4HANA Model Transferconnection*InfoProviderInfoObjectQuery asInfoProviderInfoProviderInfoObjectBWBusiness LayerData LayerAny DBSAP ABAP ConnectionSAP ABAP ConnectionBWHANAExternal HANA ViewsSAP HANA Connectionon-premisesQuery asInfoProvider 2020 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLICRemote TableRemote TableSAP HANA Connection– Scenario 2: Federated/replicated business semanticsintegration scenarios via SAP BW/4HANA Model Transferconnection*Query asInfoProviderBWQueryInfoProviderHTTP External SAP HANA Views (SAP HANA connection)SAP BW/4HANA Model Transfer Connection Operational Data Provisioning framework (SAP ABAPInfoObjectBW/4HANAHANAExternal HANA ViewsThis 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 releaseany 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 reason18without 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, ornon-infringement. SAP assumes no responsibility for errors or omissions in this document, except if such damages were caused by SAP intentionally or grossly negligent. * According to SAP Data Warehouse Cloud Road Map

SAP Data Warehouse Cloud & SAP BW/4HANAScenario 1 – Data layerAd-hoc dataexplorationData LayerBusiness LayerPowerfulvisualizationSAP P Data Warehouse CloudData layer - Reporting viewBW dataExternaldataSAP BW/4HANA or SAP BWBW DSO 2020 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC19

SAP Data Warehouse Cloud & SAP BW/4HANAScenario 2 – Business & Data layerAd-hoc dataexplorationData LayerBusiness LayerPowerfulvisualizationSAP P Data Warehouse CloudReuse the logic and defintions you have defined in your Bex queryBusiness layer viewData layer viewBex QuerySAP BW/4HANABW DSO 2020 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC20

GovernanceServicesData Sources &IngestionRepositoryServicesData ModelingServicesBusiness ModelingServiceSecurityServicesConsumption &Business ContentData Modeling Services: View Graphical or script-based (SQL & SQL Script) editor Define views on top of remote, replicated datasources, or tables Create Analytical Datasets, Dimensions orRelational Datasets Create Parent-Child or Level-based hierarchiesin Dimension views 2020 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC21

GovernanceServicesData Sources &IngestionRepositoryServicesData ModelingServicesBusiness ModelingServiceSecurityServicesConsumption &Business ContentData Modeling Services: Data Flow – OverviewData integration from variousunstructured and structured datasources Easy to use data flow based modeling experience forETL requirements Load and combine structured and unstructured datafrom different data sources (SAP and non-SAP) likefile storages, DBMS or SAP S/4HANA Standard transformation capabilities and scripting foradvanced requirements 2020 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC22

GovernanceServicesData Sources &IngestionRepositoryServicesData ModelingServicesBusiness ModelingServiceSecurityServicesConsumption &Business ContentData Modeling Services: Data Flow – End to End processCreate Connections Create a connection either in acentral connection management orinside the context of a space show available Semantic objects 2020 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLICBuild Data FlowExecute / ScheduleDataflow Browse data sources and selectsource data objects Trigger execution of data flow andsee execution status Browse table targets (from repository) Define transformations and mapsource data to target objectsOptionally: Schedule* a data flowand find scheduled job in a jobmonitorStory Designer /Data Modeling Create story based onloaded data on top of datawarehouse analyticalartifacts Build new data models onintegrate different datasourcesThis 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 releaseany 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 reason23without 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, ornon-infringement. SAP assumes no responsibility for errors or omissions in this document, except if such damages were caused by SAP intentionally or grossly negligent. * According to SAP Data Warehouse Cloud Road Map

GovernanceServicesData Sources &IngestionRepositoryServicesData ModelingServicesBusiness ModelingServiceSecurityServicesConsumption &Business ContentSecurity Services – Introducing Data Access Controls 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 seedata for region ‘EMEA‘)Region: EMEARegion: US 2020 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLICThis 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 releaseany 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 reasonwithout 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, ornon-infringement. SAP assumes no responsibility for errors or omissions in this document, except if such damages were caused by SAP intentionally or grossly negligent.24

Data Warehouse Cloud – Key benefitsData ingestion Open to any source Any Data ingestion method; Batch, real-time replication,streaming and federationCloud Data warehouseSelf-service data modeling Business users and IT collaborate around self-servicemodels and self-service data pipeliningDatabase View modeling or Data flows in one integrated tool Data Tiering (Hot, Warm, Cold Elastic price model & separation of storage & compute Performance in every operation Quarterly releases of new functionality HANA engine: OLTP/OLAP , graph, spatial, textAnalytics Augmented BI Planning Seamless Integration to SAP Analytics cloud Open to external BI tools 2020 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLICPre-delivered content SAP Semantics Pre delivered SAP content25

DEMO

Demo of Data warehouse cloudDemo steps: Show DWC Welcome page Navigate in DWC (Space, Connection, Help) Build analytic dataset (View) Build Data Flow ViewBuild & Show SAC dashboardData Flow 2020 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC27

GovernanceServicesData Sources &IngestionRepositoryServicesData ModelingServicesBusiness ModelingServiceSecurityServicesConsumption &Business ContentBusiness Content PackagesSAP ContentPartner Content (Q2/2020) also listed AppCenter Retail – Sales Analysis based on SAP ConsumerIntelligence (Q2/2020) - on SAP CAR & SalesIntelligence Adverity GmbH – Marketing Analytics for SAP DataWarehouse Cloud CFO Dashboard: financial information, personnel costs andrelated Human Resource information will be integrated toprovide a comprehensive view on the cost structure.(H2/2020) CubeServ: Procurement Cockpit for SAP DataWarehouse Cloud datazeit: E-Commerce Insights in SAP Data WarehouseCloud Inspired Intellect: Optimizing Order Fulfillment withMachine 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 2020 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLICThis 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 releaseany 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 reasonwithout 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, ornon-infringement. SAP assumes no responsibility for errors or omissions in this document, except if such damages were caused by SAP intentionally or grossly negligent.28

Example of Pre-built solutions for SAP Data Warehouse CloudFinancial analytics – real-time analytics of S/4 HANA and Successfactors 2020 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC29

Example pre-built solutions from PartnersReal time layer ontop of several SAP EWM systems to get a holisitc warehouse management viewPartner built content for EWM insights 2020 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC30

Flexible and simplified package pricing or pay for what you useKeeping you in controlPREDICTABLEFLEXIBLETRANSPARENTSIMPLEChoose what youStart small and grow at your pace.What you seeGet all the featuresneed and spendAdd remove, and reallocateis what you get,you need inwhat you plan.resources as needed.no hidden costs.one package.BENEFITS Avoid surprises with clear terms and all- Gain control into usage andconsumptioninclusive packaging Avoid lock-in with flexibility on usage,terms, and spendingOne product, all features with total cost transparency 2020 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC31

SummaryOperational cross system analysisEDWSelf-service Data modelingSACAgile Data MartlayerS/4ECCSAP BWSACSACEDWReal-time analysis layer(virtual)Lob appsS/4HyperscalerLob appsHyperscaler Extend SAP BW with SAP DWC Modern Cloud DW more Prebuilt content Self-service data modeling &Analytics ( Agile Data mart BItool) SAP DWC & HANA Cloud True Powerful analyticsReal-time analytics on multiplesystems incl Hyperscalers Data lake included 2020 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC32

Do you want to try SAP Data Warehouse Cloud?90 day POC environmentThe purpose of the hands-on exercises are to get you familiar with the DataWarehouse Cloud solution. There are four runbooks available.1. The "Simple Start" workshop provides a quick overview of the Data WarehouseCloud. It walks participants thru the process of loading data from flat files, creatinga model, and creating analytical stories in the SAP Analytics Cloud.2. The second runbook provides a deep dive thru Data Warehouse Cloud. Itdemonstrates how to create Entity-Relationship views, data views, and creates asimple analytical story in the SAP analytics cloud.3. The third runbook (1 of 2) explores the Data Builder in Data Warehouse Cloud. Itdemonstrates how to create Joins, Calculated Columns, Aggregation and Hierarchiesusing Graphical views, SQL views and Entity-Relationship views. Data are alsoloaded from flat files and tables federated from HANA Cloud.Get a trial environment where you can work with your dataThe system will be available for 90 days with full functionality where you canbuild E2E scenarios, incl your own connections.Presales resources from SAP Sweden will be supporting and involved in thePOC.The POC should have clear evaluation use cases and success criteria's.Any solutions built in the POC cannot be migrated to a productiveenvironment.Partner resources can be involved in POC workNo cost for you as a customer4. In the forth runbook (2 of 2) we will leverage the model created in the 'DataModeling in Data Builder' exercise to consume and visualize the data by means of adashboard.Planned to be hosted by SAPSA 2020 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLICContact kenneth.dalvik@sap.com or your partner33

More Information about SAP Data Warehouse CloudFind out more atwww.sapdatawarehouse.cloud Onboarding Guide Learning Academy BlogsSAP Help DocumentationCalculatorSAP Road Map ExplorerSAP CommunitySample Content on GitHubProvide your feedback: 2020 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC34

Thank you.Kenneth DalvikPresales Enterprise ArchitectSAP Svenska 46707895131kenneth.dalvik@sap.com

SAP Data warehouse cloud as EDW

GovernanceServicesRepositoryServicesData Sources &IngestionData ModelingServicesBusiness ModelingServiceSecurityServicesConsumption &Business ContentData Sources OverviewCurrentQ4 2020*Connection TilesSAP ABAPNew Connection TilesSAP HANAMicrosoft SQL ServerHDFSOracleLocal CSV FileAdveritySAP SuccessFactorsSAP BWSAP Marketing CloudGeneric ODataGeneric Cloud Data IntegrationSAP S/4HANAAzure ADLSSAP FieldglassSAP ECCGoogle GCSGoogle BigQueryAmazon S3CamelJDBCABAP ExtractorsABAP ODPABAP CDSRESTful WebservicesAmazon RedshiftSFTPSAP Open ConnectorsSAP HANA Data LakeSAP S/4HANA CloudDremioQualtricsAzure SynapseAzure SQL DatabaseSource System ConnectivitySAP Sybase IQSAP IBPSAP BPCAzure Analysis ServicesApache CassandraTeradataDynamo DBPostgreSQLIBM DB2SAP HANA CloudABAP DDIC TablesBW Query-as-a-ProviderBW InfoProviderSAP HANA CloudAmazon AthenaSAP Source System ConnectivitySAP HANA 2.0 HDINew Connection TilesSAP BW/4HANA Model TransferMySQLSAP HANA 1.0H1 2021*SAP Business OneSAP BW/4HANASAP S/4HANA CloudSAP Data Warehouse CloudPartnersAPOSSnaplogicInformaticaAdverity150 Sources500 Sources140 Sources400 SourcesDatazeitPrecogDelivered 2020 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLICPlanned*PartnerThis 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 releaseany 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 reason37without 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, ornon-infringement. SAP assumes no responsibility for errors or omissions in this document, except if such damages were caused by SAP intentionally or grossly negligent. * According to SAP Data Warehouse Cloud Road Map

ArchitectureSAP Analytics Cloud rnanceServicesPredictiveData ModelingServicesApplicationsBusiness ModelingServicesRepositoryServicesAPI 3rd-PartyconsumptionSecurityServicesSAP HANA Cloud3rd-PartyData LakeSAP Cloud SourcesIn-MemoryStorageDisk, Data LakeVirtual AccessConnectivityReplicationExternal Cloud SourcesBusiness ContentSAP DataWarehouseCloudAnalyticsAPI 3rd-PartyData LoadOn-Premise SourcesA comprehensive approach to data warehousing for instant data-to-value 2020 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC38

EDW ArchitectureSAP Analytics Cloud IntegrationConsumptionAnalyticsData Mart/Consumption layerVirtual or persistedDataIngestionDataSources3rd-PartyData LakeSAP Cloud SourcesSF, Concur, Ariba, Hybris 2020 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLICAPI 3rd-PartyconsumptionApplicationsIT & BusinessBusiness ContentSAP DataWarehouseCloudPredictiveSAP HANA Cloud (Core EDW layer) ITIn-MemoryStorageDisk, Data LakeVirtual AccessConnectivityReplicationExternal Cloud SourcesHyper-scalers; AWS, Azure,GoogleAPI 3rd-PartyData LoadOn-Premise SourcesSAP BW, SAP S/4, SAP CAR, SAPEWM39

GovernanceServicesRepositoryServicesData Sources &IngestionData ModelingServicesBusiness ModelingServiceSecurityServicesConsumption &Business ContentSAP SQL data warehousing Integration: Integrated SQL DW SAP Data Warehouse Cloud3rdSAP Analytics CloudSAP Data Warehouse Cloud Editors empower Business & IT Users tocreate End-to-End Scenarios Data is accessed, processed, federated andpersisted using SAP HANA Cloudparty VisualizationBusinessSpaceLayerBusiness BuilderCUSTOMERSAP IDESQL EditorOpen SQLSchemaSALES1PRICEData BuilderPRODUCTREVENUE Open SQLSchemanPlatformData Flow BuilderData LayerData IntegrationSAP Cloud Platform & external Toolingare enabled to connect, access and processdata, governed by SAP Data Warehouse CloudMonitoring Data ModelingHDIContainer1Scheduling Others SAP CloudPlatform & ext.ToolingHANA Artefacts, like: Calculation ViewConnectionsHDIContainernABAPHANASQL ServerOracleSAP HANA Cloud – DB-Tenant 2020 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLICOData Database ExplorerSpace ManagementEditorsThis 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 releaseany 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 reasonwithout 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, ornon-infringement. SAP assumes no responsibility for errors or omissions in this document, except if such damages were caused by SAP intentionally or grossly negligent.40

Business and IT collaborate throughout the data-to-insight lifecyclewith the best tools to get the job doneIT driven developmentCommandline and graphicmodelling in SAP IDESelf-Service data modeling 2020 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLICIntuitive views andgraphic modelling inSAP Data WarehouseCloud Data Builder41

EDW ArchitectureOn-Premise EnvironmentCloud EnvironmentApplication DatastoreSAP Analytics CloudAnalysis for OfficeStoriesExternal toolsSmart PredictAnalytic & Planning Models3:rd party APISAP DWCIT & BusinessViewsData mart/Consumption layerWarm & Hot storageVirtual or PersistedHANA TablesCore layerDisk or In-memoryCold storageStaging & historyHANA Cloud Data lake 2020 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC42

GovernanceServicesData Sources &IngestionRepositoryServicesData ModelingServicesBusiness ModelingServiceSecurityServicesConsumption &Business ContentData Modeling Services: Data Flow – Transformation CapabilitiesStandard TransformationsScripting Combine structured, semi-structured and unstructured data Advanced transformation requirements like extraction of text Operators for Projection, Aggregation, Join, Filter, Union, Add Table Embedded scripting editor in Data Flow Modeler Data source can be tables, CDS views, remote files, OData Support of standard Phyton 3 scripting language Outlook*: Case, Lookup, Cleanse, Rules and JSON, Excel, XML 2020 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLICThis 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 releaseany 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 reason43without 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, ornon-infringement. SAP assumes no responsibility for errors or omissions in this document, except if such damages were caused by SAP intentionally or grossly negligent. * According to SAP Data Warehouse Cloud Road Map

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 planning Ad-hoc .