SAP Data Warehousing

SAP Data WarehousingOverview & RoadmapJune 2017Product Management SAP Data Warehousing

DisclaimerThe information in this presentation is confidential and proprietary to SAP and may not be disclosed without the permissionof SAP. Except for your obligation to protect confidential information, this presentation is not subject to your licenseagreement or any other service or subscription agreement with SAP. SAP has no obligation to pursue any course ofbusiness outlined in this presentation or any related document, or to develop or release any functionality mentionedtherein.This presentation, or any related document and SAP's strategy and possible future developments, products and orplatforms directions and functionality are all subject to change and may be changed by SAP at any time for any reasonwithout notice. The information in this presentation is not a commitment, promise or legal obligation to deliver any material,code or functionality. This presentation is provided without a warranty of any kind, either express or implied, including butnot limited to, the implied warranties of merchantability, fitness for a particular purpose, or non-infringement. Thispresentation is for informational purposes and may not be incorporated into a contract. SAP assumes no responsibility forerrors or omissions in this presentation, except if such damages were caused by SAP’s intentional or gross negligence.All forward-looking statements are subject to various risks and uncertainties that could cause actual results to differmaterially from expectations. Readers are cautioned not to place undue reliance on these forward-looking statements,which speak only as of their dates, and they should not be relied upon in making purchasing decisions. 2017 SAP SE or an SAP affiliate company. All rights reserved.Customer2

AgendaIntroductionSAP DW StrategyCustomer Examples 2017 SAP SE or an SAP affiliate company. All rights reserved.Customer3

Why we need to talk about the data warehousing marketHigher Customer ExpectationsPerformanceScopeValueValuable real-time resultshistorical data AND Predictive, agile analyticsImproved use of previously unused dataNew TypesLarger VolumesNew LocationsBehavioral data and the Internet of ThingsPetabytes with a two digit annual growth rateCloud and data lakesData 2017 SAP SE or an SAP affiliate company. All rights reserved.Customer4

Are data warehouses still the appropriate solution?Higher Customer ExpectationsPerformanceScopeValueValuable real-time resultshistorical data AND Predictive, agile analyticsImproved use of previously unused data?Data WarehouseNew TypesLarger VolumesNew LocationsBehavioral data and the Internet of ThingsPetabytes with a two digit annual growth rateCloud and data lakesData 2017 SAP SE or an SAP affiliate company. All rights reserved.Customer5

Why is data warehousing still necessary?CharacteristicsAnalytics Consolidates data across theenterpriseBusiness Intelligence, Predictive, Planning Standardized data model Supports decision makingMain TasksFeedingexternalsystemsData WarehouseBig Data“Single Point of Truth”HadoopPlanning &Forecast Define common semantics Harmonize data valuesStreamingVirtual AccessETLELT Establish a ‘single version of truth’ Provide a single, comprehensivesource of current and historicalinformation 2017 SAP SE or an SAP affiliate company. All rights reserved.Data SourcesSAP, non-SAP, On premise, CloudCustomer6

Market ExpectationsGartner 1 “Emerging data sources, trends and technologies challengethe effectiveness of data warehouses in supporting analysis anddecision making.”IDC 2: “ The data warehousing market based on relational databaseswill continue to be disrupted by several non-relational and/or nonschematic information management software categories. Datawarehouses will not disappear as they have a key place in anorganization's data architecture.”*1 ”2016 Strategic Roadmap for Modernizing Your Data Warehouse Initiatives” Mark Beyer and Lakshmi Randall, Gartner, October 2016*2 Worldwide Business Analytics Software Forecast, 2016–2019 by Dan Vesset et al, IDC, July 2016. Doc # 257402 2017 SAP SE or an SAP affiliate company. All rights reserved.Customer7

SAP HANA’s Recognized Leadership in Data WarehousingGartner Data Warehouseand Data ManagementSystems, Q1’16 2017 SAP SE or an SAP affiliate company. All rights reserved.Forrester DataWarehouse,Q4’15Forrester In-MemoryDatabase Platforms,Q3’15Customer8

AgendaIntroductionSAP DW StrategyCustomer Examples 2017 SAP SE or an SAP affiliate company. All rights reserved.Customer9

How does it work in practice?A closer look on SAP HANA Data WarehousingSAP HANA Data WarehouseSAP HANA Platform 2017 SAP SE or an SAP affiliate company. All rights reserved.Customer10

SAP Offering: Next Generation Data Warehousing LandscapeBW/4HANA and Native SQL ScenariosSAP HANA Data WarehouseSAP Business WarehouseSAP BW/4HANASAP HANAApplicationServicesSAP HANAIntegrationServicesSAP HANA native SQLData WarehouseSAP HANAProcessingServicesSAP HANADatabaseServicesSAP HANA Platform 2017 SAP SE or an SAP affiliate company. All rights reserved.Customer11

SAP Data Warehousing approachesApplication driven approach, SAP BW/4HANA aspremium DW application with integrated services SAP BW/4HANA is an application offering all required datawarehousing services via one integrated repositorySAP BW/4HANASCHEDULING ETL No additional tools for modelling, monitoring and managingthe data warehouse required, but can be integratedSAP HANA PlatformSQL driven approach, SAP HANA with looselycoupled tools and platform services, logicallycombined Database approaches require several loosely coupled toolsto fulfill the necessary tasks with separate repositories A combination of tools (such as best of breed) used to buildthe data warehouse 2017 SAP SE or an SAP affiliate company. All rights reserved.SQL driven approachSCHEDULING ETLSAP HANA PlatformCustomer12

The three approach-strategy for SAP HANA Data WarehousingSAP HANA Data WarehouseSAP BW approachSAP Business WarehouseSAP BW/4HANASAP HANAApplicationServicesSAP HANAIntegrationServicesSAP HANA native SQLData WarehouseSAP HANAProcessingServicesSQL approach(extendable by third-party-tools)SAP HANADatabaseServicesSAP HANA PlatformMixed approach 2017 SAP SE or an SAP affiliate company. All rights reserved.Customer13

The SAP BW/4HANA approachSAPBusiness WarehouseTools & FunctionsPackaged data warehousingapplication with built-in bestpractice:SAP HANA PlatformCustomer needs and descriptions Preference for a packaged and guidedapproach History of operating SAP BW (ABAP) Existing BW customer with option togrow into HANA DW Mostly DW requirements concernedwith SAP software systems 2017 SAP SE or an SAP affiliate company. All rights reserved.Characteristics Architected end-to-end approach with centralmeta data repositoryQuery designer Openness: Interoperability with SQL based DWapproach and easy integration of non-SAP dataModeling tools Modern UI for data modeling,administration/monitoring and business usersTransformations/HAPODP (Operational data provisioning)Transport managementAnalysis authorizationsData Tiering Optimization Simplified data structures and flexibledeployment options High Performance - SAP HANA In MemoryDatabase and Advanced Analytics Continuous innovations based on SAPBW/4HANA Roadmap To consider: less freedom and flexibility incomparison to SQL based approachCustomer14

The SQL approachSAPPowerDesigner,SAP HANA WebIDEEADSAP HANA smartdata integrationand SAP HANAsmart data qualityTools & FunctionsCoverage of a full data warehousing cycleSAP PowerDesigner, EADSAP HANA PlatformSAP HANA Web IDESAP HANA EIM ServicesCustomer needs and descriptions Customers looking for SQL based DWSAP HANA application lifecycle managementSAP Agile data preparationCharacteristics Degree of Freedom: custom datamodels, data managementprocesses and transformationswith SQL Flexibility: Exchange andIntegration of best of breed tools(SAP or third-party) Customizable level of simplicity,complexity and scale Technical DW approach preferred 3rd party DW replacement Mainly non-SAP source systemlandscape SQL / SQL-Tool trained workforceSupportive ElementsSAP HANA extended application services To consider: Integration betweendifferent tools , Governance andDevelopment effortsSAP HANA data warehousing foundationSAP HANA VORA (Hadoop integration) 2017 SAP SE or an SAP affiliate company. All rights reserved.Customer15

The Mixed approachSAP HANA Data WarehouseSAPBusinessWarehouse,SAP ignerSAP HANASAP HANAextendedapplication servicesSAP HANAinformationmanagementoptionSAP HANAapplication lifecyclemanagementWeb IDESAP HANA smartdata integration andSAP HANA smartdata qualitySAP HANA datawarehousingfoundationTools & FunctionsIntegrated tools for managing mixed scenarios end-to-end:modeling, transport mechanisms, consumption interfacesCharacteristics Profit from the benefits of bothapproaches Highly flexible implementationapproachSAP HANA Platform Tight integration between bothapproachesCustomer needs and descriptions To Consider: Integration betweendifferent tools (e.g. multiplerepositories, authorizations) Customers having BW and/or non SAPDWs in place already Existing SAP customers looking for anew DW implementation based on SAPHANA SQL and guided approach required tofulfill requirements 2017 SAP SE or an SAP affiliate company. All rights reserved.SQLSAP BW/4HANAFlexible Modelling OptionsData models, metadataOpen for any SQL ToolData Tiering Optimization OperationsCustomer16

Current Portfolio – Assessment All tools of portfolio areavailable and used today,further components willbe developed. Custom DataWarehouses / DataMarts with these toolsexists - Tool usagedepending on customerscenario. 2017 SAP SE or an SAP affiliate company. All rights reserved. Tools are independentfrom each other with alack of integration for endto-end DW deploymentand operation but sharecommon interface formeta-data exchange. SAP BW/4HANA as thepremium DW offering(fully integrated toolset).Customer17

SAP HANA Data Warehouse – Strategy & VisionPlanning and definition2016Execution and delivery2016 - 2018VisionAnalyticsAnalyticsAnalytics(Business Intelligence, Predictive, Planning)(Business Intelligence, Predictive, Planning)(Business Intelligence, Predictive, Planning)SAP DWFoundationSAP PowerDesignerSAPBW/4HANASAP HANAEIMDW ModelingSAP PowerDesignerSAP DWHFoundationSAPBW/4HANASAP HANAEIMSAP HANA PlatformSAP HANA PlatformMarket presence in data warehousingwith a clear roadmapStrong and simplifiedoffering with tight integration 2017 SAP SE or an SAP affiliate company. All rights reserved.DW ETL & DMSAP HANA PlatformConvergence into one technology stackaddressing BW and SQL-based DWneedsCustomer18

SAP HANA DW – Future-Proof Data Management PlatformServe standard SQL-based and BW-style data warehousing in order to meet future demands LDW for dynamicallychanging systemlandscapes Cloud and hybriddeployment Integration of any datatypes and Big Datatechnologies Scale out to highvolumes and data lakes 2017 SAP SE or an SAP affiliate company. All rights reserved.go beyond other DW offerings Top out-of-the-boxintegration to SAPsolutions on-premise and in cloudenvironments Real-time processingpower of HANA Hadoop integration withSAP HANA Vora HANA-optimized reusable business contentCustomer19