SAP HANA data warehousing Vision & Roadmap March 2016
Product Management SAP HANA DW
© 2016 SAP SE or an SAP affiliate company. All rights reserved.
Disclaimer
This presentation outlines our general product direction and should not be relied on in making a purchase decision. 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.
© 2016 SAP SE or an SAP affiliate company. All rights reserved.
Agenda Introduction SAP DW Strategy Components & Roadmap
© 2016 SAP SE or an SAP affiliate company. All rights reserved.
3
Game Changing Trends Transform the Steadily Growing Data Warehouse Market
Data
People
Location – cloud, data lakes
Performance – real-time results
Types – behavioral data, IoT
Scope – predictive, agile analytics
Volumes – PB, > 40% growth YoY
Value – new & unused data (> 85%)
© 2016 SAP SE or an SAP affiliate company. All rights reserved.
4
Why is still data warehousing necessary? Characteristics Cloud for Analytics
Analytics
Consolidates data across the enterprise
(BI, Predictive, Planning)
Standardized data model Supports decision making
SAP
Hadoop HANA „data lake“ Vora
feeding external systems
Data Warehouse “Single Point of Truth”
Planning & Forecast
Main Tasks Define common semantics
Streaming
Virtual Access
ETL
ELT
Harmonize data values Establish a ‘single version of truth’ Provide a single, comprehensive source of current and historical information © 2016 SAP SE or an SAP affiliate company. All rights reserved.
Emb. Analytics
Non-SAP
C4C
S/4HANA
SAP ERP
SFSF
5
Market Expectations Gartner 1 “Emerging data sources, trends and technologies challenge the effectiveness of data warehouses in supporting analysis and decision making.” IDC 2: “ The data warehousing market based on relational databases will continue to be disrupted by several non-relational and/or non-schematic information management software categories. Data warehouses will not disappear as they have a key place in an organization'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 © 2016 SAP SE or an SAP affiliate company. All rights reserved.
6
Agenda Introduction SAP DW Strategy Components & Roadmap
© 2016 SAP SE or an SAP affiliate company. All rights reserved.
7
Progress from an Advanced Basis SAP Technology SAP HANA, BW … leading In-Memory platform, comprehensive DW solution
SAP’s cloud strategy … steadily growing technology and solution portfolio Hadoop integration … superior analytics for Hadoop with SAP HANA Vora
Data Warehouse and SAP HANA Customers SAP HANA customers … 14500+ SAP BW on HANA … 3000+ SAP Power Designer … 50000+ © 2016 SAP SE or an SAP affiliate company. All rights reserved.
8
Current Portfolio – Tool Use Cases SAP Agile Data Preparation / Information Steward
•
Data Lineage: monitor flow of data across models (until avail. via Information Steward)
•
Empowers to discover, assess, define, monitor and improve data quality
•
Conceptual & Logical Modeling, Reverse-Engineering, Impact Analysis, Model Comparison, New Model Versioning
SAP Power Designer
SAP HANA Modeler
SAP BW
•
Technically implement and model HANA Artifacts
•
Administrate SAP HANA models
•
Data Warehouse application with complete stack for modelling, ETL and life cycling
© 2016 SAP SE or an SAP affiliate company. All rights reserved.
SAP HANA extended application Server
•
Full embed a featured application server, web server, and development environment
•
Provides ETL services & data replication, advanced data transformation and data quality functionality
•
Design & Implement Data Flows
•
Organize HANA Artifacts to Delivery Units for transports across systems (Versioning, Revisions)
•
Data Distribution Optimizer for efficient administration of large environments
•
Data Life Cycle Manager for data temperature /aging management
SAP HANA EIM Services
SAP HANA Application LM
SAP HANA Data Warehousing Foundation
10
Current Portfolio – Assessment SAP Agile Data Preparation / Information Steward
SAP HANA extended application Server
SAP Power Designer
SAP HANA EIM Services
SAP HANA Modeler
SAP Application Lifecycle Management
SAP BW
SAP HANA Data Warehousing Foundation
© 2016 SAP SE or an SAP affiliate company. All rights reserved.
All tools of portfolio are available and used today, further components will be developed. Custom Data Warehouses / Data Marts with these tools exists. Tools are independent from each other with a lack of integration for end-to-end DW deployment and operations. Addressable market potential not used with offering. 11
Direction of Development Establish SAP HANA data warehousing as the leading data warehousing platform for … the Cloud … shape & provide advanced DW services for the cloud transition all Data … offer a broad data management platform for analytics across all data types and volumes one Truth … provide semantic harmonization for physical & virtual data access strategies and distributed processing for any source © 2016 SAP SE or an SAP affiliate company. All rights reserved.
12
SAP HANA DW – Strategy Planning and definition 2016
Execution and delivery 2016 - 2018
Analytics (SAP BI Suite, Predictive, Planning)
Analytics (SAP BI Suite, Predictive, Planning)
Analytics (SAP BI Suite, Predictive, Planning)
SAP HANA DW
SAP HANA DW
SAP HANA DW SAP Power Designer
SAP DW Foundation SAP Power Designer
SAP BW
DW Modeling
DW ETL & DM
SAP HANA Plattform SAP HANA Vora
SAP HANA EIM SAP HANA Plattform
SAP BW
Vision
SAP HANA Vora
Market presence in data warehousing with a clear roadmap
SAP DW Foundation
SAP HANA EIM
Strong and simplified offering with tight integration
SAP HANA Plattform
SAP HANA Vora
Convergence into one technology stack addressing BW and SQL-based DW needs
This presentation outlines our general product direction and should not be relied on in making a purchase decision. This pres entation 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 S AP intentionally or grossly negligent.
© 2016 SAP SE or an SAP affiliate company. All rights reserved.
13
SAP HANA DW – Future-Proof Data Management Platform for Analytics Serve standard SQL-based and BW-style data warehousing in order to … meet future demands LDW for dynamically changing system landscapes Cloud and hybrid deployment Integration of any data types and Big Data technologies Scale out to high volumes and data lakes
go beyond other DW offerings Top out-of-the-box integration to SAP solutions – on-premise and in cloud environments Real-time processing power of HANA Hadoop integration with SAP HANA Vora HANA-based analytic business services HANA-optimized re-usable business content This presentation outlines our general product direction and should not be relied on in making a purchase decision. This pres entation 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 S AP intentionally or grossly negligent.
© 2016 SAP SE or an SAP affiliate company. All rights reserved.
14
Agenda Introduction SAP DW Strategy Components & Roadmap
© 2016 SAP SE or an SAP affiliate company. All rights reserved.
15
Components of SAP HANA data warehouse SAP HANA data warehouse
SAP Agile Data Preparation
SAP HANA extended application Server
SAP Power Designer
SAP HANA Modeler
SAP BW
SAP HANA EIM Services
SAP HANA Application Lifecycle Management
SAP HANA Data Warehousing Foundation
SAP HANA Platform © 2016 SAP SE or an SAP affiliate company. All rights reserved.
16
Development Focus - Principles All tools continue to exists & evolve within their respective domain COLLABORATE
INTEGRATE
EMBRACE
Enable tools to collaborate
Gradually work on tool's overlaps
Modern DW environments
e.g. shared repositories across tools
e.g. SAP BW and SAP HANA EIM
e.g. Big Data, Hadoop, SAP HANA Vora
© 2016 SAP SE or an SAP affiliate company. All rights reserved.
17
Development Focus 2016 Modeling & Metadata Integrated top-down modeling of DW artefacts with SAP Power Designer Consistent release management and impact analysis across DW models Consolidation of BW modeling objects optimized for SAP HANA
Data Access Services SAP HANA EIM becomes the central data integration component of the SAP HANA DW Flexible adapters for logical data warehousing covering SAP, third party and Big Data sources
© 2016 SAP SE or an SAP affiliate company. All rights reserved.
Data Management & Processing Unified data processing across databases and data lakes High performance business services, e.g. for inventory handling, planning and resource allocation
End-to-End Operations Uniform scheduling and monitoring services for SAP HANA DW data flows Advanced data distribution services for scale out and dynamic tiering
Comprehensive life cycle services for HANA DW components 18
Outlook SAP HANA data warehouse SAP Agile Data Preparation
XS advanced GIT HUB
HDI Runtimes
Web Modeling
SAP Power Designer
SAP Web IDE
SAP BW
SAP HANA EIM Services
SAP HANA Application Lifecycle Management
SAP HANA Data Warehousing Foundation
SAP HANA Platform This presentation outlines our general product direction and should not be relied on in making a purchase decision. This pres entation 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 S AP intentionally or grossly negligent.
© 2016 SAP SE or an SAP affiliate company. All rights reserved.
19
Modeling & Metadata Integrated web modelling with SAP Power Designer and SAP Web IDE - Generation of SAP HANA artefacts (HANA CalcViews) - Business and process modeling for SAP BW and HANA artefacts - Design time creation of CDS entities definition files Consistent management of DW models in SAP HANA - GIT & HDI as common content management for HANA DW components - Consistent release and versions management for packages via GIT - Design and runtime impact analysis on dependencies across HANA models Consolidation of BW models for HANA-optimized data warehousing - Two central InfoProviders only: ADSO and CompositeProvider (e.g. seman. Gr.) - New and simplified Business Content for BW on HANA - SAP BW edition for HANA - only using HANA-optimized modeling objects
Data Access Services
Planned for 2016 Integrated top-down modeling of DW artefacts with SAP Power Designer Consistent release management and impact analysis across DW models Consolidation of BW modeling objects optimized for SAP HANA
Data Management & Processing
End-to-End Operations
This presentation outlines our general product direction and should not be relied on in making a purchase decision. This pres entation 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 S AP intentionally or grossly negligent.
© 2016 SAP SE or an SAP affiliate company. All rights reserved.
20
Modeling & Metadata
Data Access Services SAP HANA EIM becomes the central component for data integration - Logical DW with adapters for physical and virtual data integration - Flexible switching between data access methods - Support of extractors and S/4HANA via RFC adapter - Access to Big Data sources (e.g. Hadoop and NoSQL DB) - Integration of real-time data streams (e.g. integration in BW) - Data lineage and impact analysis for data sources - Extended data quality and transformation possibilities with integration in BW (e.g. geocoding, best record) - Seamless connectivity to cloud sources via adapter (e.g. SFSF) - EIM flowgraphs supporting HANA CDS definitions
Data Management & Processing
End-to-End Operations
Planned for 2016 SAP HANA EIM becomes the central data integration component of the SAP HANA DW Flexible adapters for logical data warehousing covering SAP, third party and Big Data sources
This presentation outlines our general product direction and should not be relied on in making a purchase decision. 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.
© 2016 SAP SE or an SAP affiliate company. All rights reserved.
21
Planned for 2016 Unified data processing across databases and data lakes High performance business services, e.g. for inventory handling, planning and resource allocation Modeling & Metadata
Data Access Services
Data Management & Processing Unified data processing across data tiers and sources - Multi-tiering between HANA, DynamicTiering and Hadoop via DLM - Hadoop as NLS for SAP BW, possibility to access via SAP HANA Vora - Integration with SAP HANA Vora to enable analyses for Hadoop data - Data provenance across DW data tiers Continuous extension of high performance HANA business services - Further push-down of BW business functionality (e.g. formula excep. aggr.) - Advanced services for inventory handling and planning processes - Additional algorithms for PAL, e.g. for sequential pattern mining
End-to-End Operations
This presentation outlines our general product direction and should not be relied on in making a purchase decision. This pres entation 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 S AP intentionally or grossly negligent.
© 2016 SAP SE or an SAP affiliate company. All rights reserved.
22
Modeling & Metadata
Data Access Services
Planned for 2016
Data Management & Processing
End-to-End Operations Uniform scheduling and monitoring services for data flows - Common HANA scheduling framework for EIM, BW Process Chains and third party data integration tools - Monitoring services for EIM-based data access processes
Uniform scheduling and monitoring services for SAP HANA DW data flows
Advanced data distribution services for scale out and dynamic tiering - Optimization of data distribution for HANA scale-out landscapes (e.g. join-path analysis) - Set-up of automated data placement for dynamic tiering
Advanced data distribution services for scale out and dynamic tiering
Life cycle management and administration - Life cycle services for HANA DW components, e.g. for branching, packaging and transport (e.g. GIT integration) - Web-based administration and monitoring tools for BW
Comprehensive life cycle services for HANA DW components
This presentation outlines our general product direction and should not be relied on in making a purchase decision. This pres entation 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 S AP intentionally or grossly negligent.
© 2016 SAP SE or an SAP affiliate company. All rights reserved.
23
SAP HANA DW – Summary SAP BI, Predictive, Planning
SAP HANA DW as flexible and modern data warehouse framework
HANA DW BW centric
SQL centric
1.
SQL centric approach is a valid and positioned scenario for data warehousing with tooling for implementation
2.
SAP BW will further be developed and integrated with HANA DW components
3.
Independent from starting point HANA DW components can be added and used in a mixed architecture at a later point in time
Mixed Scenario
SLT, DataServices, EIM, SRS, Extractor © 2016 SAP SE or an SAP affiliate company. All rights reserved.
24
© 2016 SAP SE or an SAP affiliate company. All rights reserved. No part of this publication may be reproduced or transmitted in any form or for any purpose without the express permission of SAP SE or an SAP affiliate company. SAP and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP SE (or an SAP affiliate company) in Germany and other countries. Please see http://global12.sap.com/corporate-en/legal/copyright/index.epx for additional trademark information and notices. Some software products marketed by SAP SE and its distributors contain proprietary software components of other software vendors. National product specifications may vary. These materials are provided by SAP SE or an SAP affiliate company for informational purposes only, without representation or warranty of any kind, and SAP SE or its affiliated companies shall not be liable for errors or omissions with respect to the materials. The only warranties for SAP SE or SAP affiliate company products and services are those that are set forth in the express warranty statements accompanying such products and services, if any. Nothing herein should be construed as constituting an additional warranty. In particular, SAP SE or its affiliated companies have no obligation to pursue any course of business outlined in this document or any related presentation, or to develop or release any functionality mentioned therein. This document, or any related presentation, and SAP SE’s or its affiliated companies’ strategy and possible future developments, products, and/or platform directions and functionality are all subject to change and may be changed by SAP SE or its affiliated companies at any time for any reason without notice. The information in this document is not a commitment, promise, or legal obligation to deliver any material, code, or functionality. All forwardlooking statements are subject to various risks and uncertainties that could cause actual results to differ materially 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.
.SAP SE or an SAP affiliate company. All rights reserved 2016 ©
Public