SAP HANA
Rob Lightfoot - SAP MENA, 2014
SAP HANA Update ‒
Overview of SAP HANA SPS 08
© 2014 SAP AG or an SAP affiliate company. All rights reserved. Roadmap: Subject to change without notice 2
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.
© 2014 SAP AG or an SAP affiliate company. All rights reserved. Roadmap: Subject to change without notice 3
SAP Data Management provides real time data for all applications and analytics
Innovation combined with proven reliability, and lower total cost of ownership• Innovation : In-memory & event driven architecture for end-to-end real-time data management driving all applications, analytics and user experience
• Lower Risk: System availability 24x7 even
through technical network and system disruptions.
• TCO: Lower total cost of ownership while driving innovation
Mobile First UX (Fiori)
Applications Analytics
Partners
SAP Data Management
SAP IQ
Data warehousing (OLAP)
SAP SQLA
Mobile & Embedded Database
SAP ESP
SAP ASE
SAP Data Services
All types of data integration
SAP Replication Server
SAP HANA platform
Processing Engine Application Function Lib.
Database Services (OLTP + OLAP)
Extended Application Services
Integration Services
SAP HANA PLATFORM
e Real-time Complex Event Processing High volume transactional data replications
Database for On-line Transaction Processing (OLTP)
© 2014 SAP AG or an SAP affiliate company. All rights reserved. Roadmap: Subject to change without notice 4
Rethinking information processing
Reducing the layers and complexity
OLAP
OLTP
Structured
Unstructured / Text Analysis
Replication / Streaming
Batch ETL/ELT
Planning
Predictive/Statistical
Application Services
UI Development Tools
Delivering across all dimensions of transactional and Analytical data
SAP HANA SPS7
In-memory Platform
© 2014 SAP AG or an SAP affiliate company. All rights reserved. Roadmap: Subject to change without notice 5
Supports any Device
Any Apps
AnyApp Server SAP Business Suite and BW ABAP App Server
JSON R Open Connectivity MDX SQL Other Apps Locations Real-time HADOOP Machine Unstructured Transaction
SAP HANA Platform
SQL, SQLScript, JavaScript, HTML5, SAP River
Replication, Streaming and ETL Integration Services Search
Application Function Library
Data Virtualization Text Analysis & Mining
Spatial Database Services
Stored Procedure & Data Models Predictive &
Planning Engine Business Rules Application & UI
Services
SAP HANA Platform – More than just a database
SAP HANA Platform Converges Database, Data Processing and Application Platform Capabilities & Provides Libraries for Predictive, Planning, Text, Spatial, and Business
© 2014 SAP AG or an SAP affiliate company. All rights reserved. Roadmap: Subject to change without notice 6
Big Data and
Internet of Things
Themes for ongoing SAP HANA Roadmap deliverables
Applications and Industry Platforms
Cloud Enablement
Openness
$£¥ ©™
© 2014 SAP AG or an SAP affiliate company. All rights reserved. 7
Recent Innovations
Future Direction
Past Innovations
Intelligent Data Tiering
Multi-Tenancy
New operations, management and Lifecycle management tools
New core engine capabilities to support Big Data and IoT applications
Enhanced Developer tooling,
interoperability, usability and migration tools
New native Data Provisioning, streaming, replication and data cleansing capabilities
New Security, audit and compliance features
New Hardware, Operating system and Tailored Data Center Integration options
Additional third-party Application, tool, services, algorithm and content support
SAP HANA
SAP HANA specific product road map overview – key themes and capabilities
This is the current state of planning and may be changed by SAP at any time. (up to SPS7 Release –Nov 2013)
Business Suite on SAP HANA
SAP BW on SAP HANA
Application Development Enablement
“R” integration
Unstructured text search & Text Analytics
Streaming and Complex Event Processing integration
Application development and runtime
Enhanced openness for 3rd parties tool integration and certification
Enhanced HA and DR capabilities
Smart Data Access – Data virtualization
Spatial support and Geo-Content
Virtualization support
Tailored Data Center Integration
Cloud delivery models – SAP HANA Enterprise Cloud, SAP HANA One
Ivy Bridge Server certifications Production Virtualization support
Monitoring & operations enhancements
SAP HANA Studio usability & productivity enhancements
Web IDE enhancements
SAP HANA Studio support for OSX
Web IDE and SAP River enhancements
Geo-spatial innovations & ESRI support
Security enhancements
Smart Data Access support for IBM data sources
SAS integration with SAP HANA
Application Function Library SDK
ADO .Net client connectivity
SAP Business Suite and SAP BW application specific enhancements
New DR Synchronous Mode - Full Sync
© 2014 SAP AG or an SAP affiliate company. All rights reserved. Roadmap: Subject to change without notice 8
Optimized application support and advanced off-the-shelf
algorithms and services
Next generation development environment and enhanced
HA/DR options Choice of Hardware and
Software infrastructure and access data from any location
SAP HANA SPS08
The Platform for All Applications
Accelerate
Innovate
• Take advantage of
technology innovation across the technology stack
• Put all your data at work for your business
• Leverage existing investment and vendor relationships
• Derive higher value from exiting applications automatically
• Achieve results faster leveraging SAP HANA’s prebuilt data
services
• Create new business value easily
Simplify
• Achieve higher development productivity
• Decouple business logic from data
• Experience the highest level of availability
© 2014 SAP AG or an SAP affiliate company. All rights reserved. Roadmap: Subject to change without notice 9
Applications and Industry Platforms
Core Platform Capabilities
- Geo-spatial innovations
- Extended ESRI developer tool support
- Spatial Join
- New In-database AFL and Predictive algorithms
- Security enhancements
- Improved License handling
- UTF-8 support for usernames
- Restricted user (new user type)
- SAP Business Suite on SAP HANA:
- Hierarchy Traversal (e.g. HCM, CRM)
- Enhanced SAP HANA Live support (CE, Modeler,
Performance)
- Extended Fiori support (XS + OData + Search)
ArcGIS REAL-TIME DATA SPATIAL DATA BUSINESS DATA ArcSDE Geodatabase Query Layers
© 2014 SAP AG or an SAP affiliate company. All rights reserved. Roadmap: Subject to change without notice 10
SAP HANA In-Memory Predictive Analytics
Predictive Analysis Library (PAL) - Algorithms Supported
Association Analysis Apriori Apriori Lite FP-Growth *
Classification Analysis CART * C4.5 Decision Tree Analysis
CHAID Decision Tree Analysis
K Nearest Neighbour
Multiple Linear Regression
Polynomial Regression
Exponential Regression
Bi-Variate Geometric Regression
Bi-Variate Logarithmic Regression
Logistic Regression
Naïve Bayes
Support Vector Machine
Outlier Detection Inter-Quartile Range Test (Tukey’s Test)
Variance Test
Anomaly Detection
Statistic Functions (Univariate) Mean, Median, Variance, Standard Deviation Kurtosis Skewness
Link Prediction Common Neighbors Jaccard’s Coefficient Adamic/Adar Katzβ * New in SPS08
Data Preparation Sampling Random Distribution Sampling *
Binning Scaling Partitioning
Statistic Functions (Multivariate) Covariance Matrix Pearson Correlations Matrix
Chi-squared Tests:
-Test of Quality of Fit
-Test of Independence
F-test (variance equal test)
Other Weighted Scores Table
Substitute Missing Values
Cluster Analysis ABC Classification
DBSCAN
K-Means
K-Medoid Clustering *
Kohonen Self Organized Maps
Agglomerate Hierarchical
Affinity Propagation
Time Series Analysis Single Exponential Smoothing
Double Exponential Smoothing
Triple Exponential Smoothing
Forecast Smoothing
ARIMA *
Probability Distribution Distribution Fit *
Probability Distribution Function *
© 2014 SAP AG or an SAP affiliate company. All rights reserved. Roadmap: Subject to change without notice 11
Applications and Industry Platforms
Core Platform Capabilities
- SAP BW on SAP HANA (for planned SAP BW 7.4 SP8 release)
- DSO activation improvements
- Dynamic range partitioning
- New SHINE content
- New Launch Pad
- Sales dashboard for a sales Analyst showcasing Rules on HANA, CRUD operations, Fuzzy Search.
- INA Toolkit Search Help
- New Spatial Scenario
- SAP HANA UI Integration Service (Fiori Launch pad service)
- Rules on SAP HANA (Tax Code Example)
- User Create using OData Batch Inserts
- Sales Order Mobile Dashboard
SAP HANA Stack
SAP BW on SAP HANA
Data Modeling Planning Data Management OLAP P roc e s s Orc hes tra tion Push Down
© 2014 SAP AG or an SAP affiliate company. All rights reserved. Roadmap: Subject to change without notice 12
Cloud Enablement
Data Center Admin and Operations
- Ivy Bridge Server certifications - “Large” 8 socket scale-up
configuration scale up (120 CPU cores and up to 12TB DRAM)
- New OS Choice: Red Hat Enterprise Linux for SAP HANA
- Production Virtualization support (VMware)
- SLES and RHEL configurations
- Monitoring and operations enhancements
- Emergency Support Mode
- Statement Memory Tracking
- New Database Monitor / Dashboard
- PlanViz / PlanCache usability enhancements
- Summary View / Operator List
- CSV export of monitoring views
- New DR System Replication mode
- Consistent Transactional replication via “Synchronous with Full Sync”
© 2014 SAP AG or an SAP affiliate company. All rights reserved. Roadmap: Subject to change without notice 15
Big Data and Internet of Things
Core Platform Capabilities
- Geo-spatial innovations
- Extended ESRI developer tool support
- Enhanced Spatial performance processing capabilities
Developer Enablement
- Smart Data Access enhancements
- Adapters for IBM DB2 and Netezza
- SAS integration / AFL delivery with SAP HANA
ArcGIS REAL-TIME DATA SPATIAL DATA BUSINESS DATA ArcSDE Geodatabase Query Layers
© 2014 SAP AG or an SAP affiliate company. All rights reserved. Roadmap: Subject to change without notice 16
Applications and Industry Platforms
Developer Enablement
- Enhanced SAP HANA Modeling capabilities
- Variable/Input Parameter mapping to external views for value help
- Data types specifications - allow decimal/float type without specifying length and scale
- Currency conversion - support to specify the target data type also for base measures / configurable currency columns
- Sorting support within of parent/child hierarchies
- Set default schema mapping at package level
- Mass-copy to allow sub-packages to be selected
- Show productive system alert for edit/update/delete activities
- Introducing performance analysis capabilities (partitioned tables, number of rows)
- Support for Unicode characters in view/column/… names
- UI and usability enhancements (new tree map control in union view, join icons, …)
© 2014 SAP AG or an SAP affiliate company. All rights reserved. Roadmap: Subject to change without notice 17
Applications and Industry Platforms
Developer Enablement
- SAP HANA Studio enhancements
- Workflow usability and productivity focus
- Studio enabled version management for repository objects
- SAP HANA Studio support for Apple OSX based on SPS8
- Web IDE enhancements
- SAP River enhancements
- SQL / SQLScript Enhancements
- Extended Scalar function support
- CASE expression support
- Extended SQL statement and procedure support
© 2014 SAP AG or an SAP affiliate company. All rights reserved. Roadmap: Subject to change without notice 18
Applications and Industry Platforms
SCN (HANA Communities) SAP Help SAPHANA.com SAP HANA Academy Web Browser
Running on and Powered by
HANA Cloud Platform
HANA Studio
ANSWERS PLUGIN
Content
SAP HANA Answers
Videos, Help Files, Discussions,
Notifications In-Memory Knowledgebase and Search
© 2014 SAP AG or an SAP affiliate company. All rights reserved. Roadmap: Subject to change without notice 19
SAP HANA Answers View
Your source of valuable content and your
connection to the HANA network of experts
Notification Indicator
Someone has answered your question or posted something of interest to you
Applications and Industry Platforms
Toolbar Menu
Click blue Answers icon to find content or ask a question. Alternatively, press the F10 key
Contextual Awareness
Highlighted text as well as your current context determine the
recommended content
© 2014 SAP AG or an SAP affiliate company. All rights reserved. Roadmap: Subject to change without notice 20
Openness
Data Center Admin and Operations
- Virtualization support for production (VMware)
- Single Production VM is GA and Multi-VM via pilot program
- 3rd party tool certifications for HANA
- Backup, BI SQL/ MDX clients, ETL certification
- Ivy Bridge Server “Large” 2, 4 & 8 socket scale-up configuration
scale up certifications (120 CPU cores and up to 12TB DRAM)
- OS options: SLES or RHEL configurations
Developer Enablement
- Smart Data Access enhancements
- Adapters for IBM DB2 and Netezza
- Natively read ESP CP windows
- SAS integration / AFL with SAP HANA
- ADO .Net client connectivity GA
Text Planning Spatial/GIS Transactions Streaming Prescriptive Predictive Sentiment Intelligence Machine Learning Operational Analytics SAP HANA (Main Memory)
© 2014 SAP AG or an SAP affiliate company. All rights reserved. Roadmap: Subject to change without notice 21
Big Data and
Internet of Things
Themes for ongoing SAP HANA Roadmap deliverables
Applications and Industry Platforms
Cloud Enablement
Openness
$£¥ ©™
© 2014 SAP AG or an SAP affiliate company. All rights reserved.