SAP HANA

Connect Symposium 2014
SAP HANA Part 1 und 2
Joerg Schade
SAP Competence Center Walldorf
© Copyright 2012 Hewlett-Packard Development Company, L.P. The information contained herein is subject to change without notice.
Part 1
Einführung in SAP HANA
Connect Symposium 2014
© Copyright 2012 Hewlett-Packard Development Company, L.P. The information contained herein is subject to change without notice.
Agenda
• Etwas Historie zur SAP
• Die ‚Problemzonen‘ der SAP
• Lösungsansätze
• SAP HANA – Einführung
• Wie wird SAP HANA ‚geliefert‘ ?
• Wer kann SAP HANA nutzen ?
• Ein Blick in die Glaskugel …
3
© Copyright 2012 Hewlett-Packard Development Company, L.P. The information contained herein is subject to change without notice.
SAPS’s Application Evolution – Source SAP AG
4
© Copyright 2012 Hewlett-Packard Development Company, L.P. The information contained herein is subject to change without notice.
From R/3 to Business Suite
New processes can reuse existing functionality
Business
Web services
„SOA“
ECC
SCM
BI
EP
Enterprise Service
Architecture
„Netweaver“
R/3 4.7
„mySAP“
„mySAP.com“
„enjoy“
„new
dimension“
5
R/3 4.6
BI
SCM
SRM
MI
EP
SRM
CRM
GRC
MDM
PI
CRM
XI
EBP
BBP
Work
Online SFA
R/3 4.5
APO place
B2B Store
BW
R/3 4.0
ITS
© Copyright 2012 Hewlett-Packard Development Company, L.P. The information contained herein is subject to change without notice.
„integration“
R/3 3.1
BC
CCMS
Integration
Web Services
SSM
NWA
WP
Die Problemzonen der SAP
• Viele Datenbanken
• ‚ungezügeltes‘ (Daten)Wachstum
• Konsistenz und Synchronität der Daten
• Businessanforderungen – neue Prozesse, schnelle Implementierung
• Businessanforderungen – neue Endgeräte und Zugriffsweisen
• Gesättigte Märkte – zumindest in einigen Ländern …
6
© Copyright 2012 Hewlett-Packard Development Company, L.P. The information contained herein is subject to change without notice.
Mission Critical SAP Environment
Trend outlook from the EMEA HP-SAP Competence Center – Walldorf, Germany
7
© Copyright 2012 Hewlett-Packard Development Company, L.P. The information contained herein is subject to change without notice.
Lösungsansätze
• Rückführung auf ‚eine‘ Datenbank und einen Konsistenzlayer
• Komprimierung und neue Speicherformen
• ‚In Memory‘
• Datenbanknahe Abläufe näher an die Datenbank
• Direkter Webzugriff (Restful API) von verschiedensten Endgeräten
8
© Copyright 2012 Hewlett-Packard Development Company, L.P. The information contained herein is subject to change without notice.
Next generation SAP Real-time Data Platform
Business Networking
9
© Copyright 2012 Hewlett-Packard Development Company, L.P. The information contained herein is subject to change without notice.
Source: SAP AG
The Paradigm Shift: In-Memory Computing enables a new
architecture for business applications
New Architecture In-Memory Computing
Traditional Architecture
Analytical
Transactional
Application
Application
OLTP
Database
OLAP
Replication
Data
“Persistence”
Transactional /
Analytical
In-Memory Computing
OLTP / OLAP
Data
Persistence
10
Hard Disk
Backup/
Recovery
© Copyright 2012 Hewlett-Packard Development Company, L.P. The information contained herein is subject to change without notice.
Hard Disk
What is SAP HANA?
SAP HANA is…
… a new database platform from SAP
… an in-memory database
… CPU and cache optimized
… mostly an Appliance that …
• … runs on SLES4SAP, only!
• … has a defined processor architecture E7
(Intel Westmere EX, now IVY-Bridge EX)
• … has a defined core-memory ratio
(128 GB per Processor for BW and up to 512 GB per CPU for Suite - Westmere)
(256 GB per Processor for BW and up to 512/768 GB per CPU for Suite – for IVY-Bridge EX)
11
© Copyright 2012 Hewlett-Packard Development Company, L.P. The information contained herein is subject to change without notice.
Storing data in columns
12
© Copyright 2012 Hewlett-Packard Development Company, L.P. The information contained herein is subject to change without notice.
SAP HANA Database
Columnar Storage
Classic DB Row Store
Company
[CHAR50]
Region
[CHAR30]
Group
[CHAR5]
INTEL
USA
A
Siemens
Germany
B
Siemens
Germany
C
SAP
Germany
A
SAP
Germany
A
HP
USA
A
HANA Column Store
HP
13
© Copyright 2012 Hewlett-Packard Development Company, L.P. The information contained herein is subject to change without notice.
SAP HANA Database
Columnar Storage
Classic DB Row Store
14
Company
[CHAR50]
Region
[CHAR30]
Group
[CHAR5]
INTEL
USA
A
Siemens
Germany
B
Siemens
Germany
C
SAP
Germany
A
SAP
Germany
A
HP
USA
A
HANA Column Store:
HANA Column Store:
Dictionary compressed
Run length compressed
HP
© Copyright 2012 Hewlett-Packard Development Company, L.P. The information contained herein is subject to change without notice.
HP
SAP HANA - Appliance Delivery Model
Customer feedback & challenges
15
© Copyright 2012 Hewlett-Packard Development Company, L.P. The information contained herein is subject to change without notice.
Source: SAP AG
The HP AppSystems for SAP HANA portfolio
Scale-out
Single node
HP ProLiant DL580 (4 sockets)
HP AppSystem:
Memory:
X-Small
128GB RAM
Small
256GB RAM
Medium
512 GB RAM
HP ProLiant DL980 (8 sockets)
Medium+
512GB RAM
Large
1TB RAM
Virtualized
1TB RAM
Suite on HANA
2TB RAM
Blades (4s)
Suite on HANA
Scale-Out
4TB RAM
512GB/blade
up to 8TB+
Non-Prod
HP server
HP ProLiant
DL580 G7
HP ProLiant
DL580 G7
HP ProLiant
DL580 G7
HP ProLiant
DL980 G7
HP ProLiant
DL980 G7
HP ProLiant
DL980 G7
HP ProLiant
DL980 G7
HP ProLiant
DL980 G7
1 to 16 HP ProLiant
BL680c G7
Processor
2x Intel x86-E7
2x Intel x86-E7
4x Intel x86-E7
4x Intel x86-E7
8x Intel x86-E7
8x Intel x86-E7
8x Intel x86-E7
8x Intel x86-E7
4x Intel x86-E7 per
server
Persistent storage
2x 300GB SAS
Ext 25x 146GB
2x 300GB SAS
Ext 25x 146GB
2x 300GB SAS
Ext 25x 146GB
2x 300GB SAS
Ext 25x 300GB
2x 300GB SAS
Ext 25x 300GB
2x 300GB SAS
Ext 25x 300GB
2x 300GB SAS
Ext 24x 450GB
2x 300GB SAS
Ext 50x 450GB
HP3Par 7400 SAN
48x 900GB per
3Par
SAP Storage API
Low-latency
log storage
1x365GB HP IO
Accelerator
1x365GB HP IO
Accelerator
2x365GB HP IO
Accelerator
1x765GB HP IO
Accelerator
2x765GB HP IO
Accelerator
2x765GB HP IO
Accelerator
2x 2.4TB HP IO
Accelerator
RAID1
4x 2.4TB HP IO
Accelerator
RAID1
N/A
Software *
SLES for SAP
SAP HANA
SLES for SAP
SAP HANA
SLES for SAP
SAP HANA
SLES for SAP
SAP HANA
SLES for SAP
SAP HANA
SLES for SAP,
VMware, HANA
SLES for SAP
SAP HANA
SLES for SAP
SAP HANA
SLES for SAP
SAP HANA
HP Services for SAP
HANA
HP Factory Express HANA Integration Service , HP expert onsite rapid (< 1 week) HANA implementation Service, HP Technology Support
Estimated source DB
size assuming 2X
256 GB is sold by
512SAP,
GB not HP 1 TB
1 TB
2 TB
2 TB
*The SAP HANA license
effective
16 © Copyright 2012 Hewlett-Packard Development Company, L.P. The information contained herein is subject to change without notice.
compression
4 TB
8TB
Currently up to
16 TB
HP Converged System 500 for SAP HANA Portfolio
Choice of scale-up and scale out configurations
16 TB++
2 TB
1 TB
256 GB
512 GB
Scale Out
Scale Up
HP ProLiant DL580 Gen8
Intel Ivy Bridge E7-4880
(2CPU/15 Core per CPU)
HP ProLiant DL580 Gen8
Intel Ivy Bridge E7-4880
(4CPU/15 Core per CPU)
HP ProLiant DL580 Gen8
Intel Ivy Bridge E7-4880
(4CPU/15 Core per CPU)
End to End consulting and deployment services | Single point of contact for solution level support
| Factory Integrated | 3 year Warranty
18
© Copyright 2012 Hewlett-Packard Development Company, L.P. The information contained herein is subject to change without notice.
Built on the Next Generation
Intel Ivy Bridge platform
HP Converged System 500 for SAP HANA: At a glance
Component
Scale Up - X-Small
2s/256GB
Scale Up – Small
2s/512GB
Scale Up – Medium
4s/1TB
Scale Up – Large
4s/2TB
Scale Out-Expansion
4TB = 4Nodes(4s/1TB each)
Server
ProLiant DL580 Gen8
ProLiant DL580 Gen8
ProLiant DL580 Gen8
ProLiant DL580 Gen8
4x ProLiant DL580 Gen8
4x ProLiant DL580 Gen8
Processor
2x Intel x86- E7-4880
2.5Ghz
2x Intel x86- E7-4880
2.5Ghz
4x Intel x86- E7-4880
2.5Ghz
4x Intel x86- E7-4880
2.5Ghz
4x 4 Intel x86- E7-4880 2.5Ghz
4x 4 Intel x86- E7-4880 2.5Ghz
In-Memory
DB
(96 DIMMs)
256GB
16x 2Rx4 PC3 DD3
(16GB)
512GB
32x 2Rx4 PC3 DD3
(16GB)
1024GB
32x 4Rx4 PC3 DD3
(32GB)
2048GB
64x 4Rx4 PC3 DD3
(32GB)
4x 1024GB
Each server -32x 4Rx4 PC3 DD3
(32GB)
4x 1024GB
Each server -32x 4Rx4 PC3 DD3
(32GB)
25x600GB 6G SAS 10K
RAID50
xfs
25x600GB 6G SAS 10K
RAID50
xfs
2x 600GB 6G SAS 10K SFF
2x 600GB 6G SAS 10K SFF
2x SSD 800GB SAS 12G
ME SSD RAID10
(internal)
xfs
2x SSD 800GB SAS 12G
ME SSD RAID10
(internal)
xfs
3PAR StoreServ 7400 (1x4node
config) (96x 900GB 6G SAS
10Krpm SFF)
TOR SAN Switch HP SN6000B
16GB 48-port/24-port Active
Fibre Channel
3PAR StoreServ 7400 (1x4node
config) (96x 900GB 6G SAS
10Krpm SFF)
TOR SAN Switch HP SN6000B
16GB 48-port/24-port Active
Fibre Channel
Internal
storage
DATA (4x
Mem), LOG
(1xMem)
8x 600GB 6G SAS 10K
(internal) RAID5
Xfs
8x 600GB 6G SAS 10K
(internal) RAID5
Xfs
Software
SLES for SAP 11 SP3
SAP HANA SPS7
SLES for SAP 11 SP3
SAP HANA SPS7
SLES for SAP 11 SP3
SAP HANA SPS7
SLES for SAP 11 SP3
SAP HANA SPS7
SLES for SAP 11 SP3 , SAP HANA SPS7, HP Serviceguard NFS,
3PAR Management Server, HANA Studio
HP Services
& Support
for SAP
HANA
Factory Express (FE4)
Integration. Fast Start
& Accelerator Services.
TS Solution Level
Support
Factory Express (FE4)
Integration. Fast Start
& Accelerator
Services. TS Solution
Level Support
Factory Express (FE4)
Integration. Fast Start
& Accelerator Services.
TS Solution Level
Support
Factory Express (FE4)
Integration. Fast Start
& Accelerator Services.
TS Solution Level
Support
Factory Express (FE4)
Integration. Fast Start &
Accelerator Services. TS
Solution Level Support
Addn.
Components
19
Scale Out – Base Rack
4TB = 4Nodes(4s/1TB each)
© Copyright 2012 Hewlett-Packard Development Company, L.P. The information contained herein is subject to change without notice.
Factory Express (FE4) Integration.
Fast Start & Accelerator Services.
TS Solution Level Support
Command Center: 1x DL380 Mgmt Server, Network: TOR LAN Switch
2x 5900AF for 10GBE . File Server: 2x DL380 NFS HA server
SAP HANA - How HP delivers today
Accelerated time to value
HP and SAP
align on
customer
project
SAP sells SAP
HANA License
to
customer
HP sizes and
configures
platform, obtains
PO for HP HANA
appliance
(HP AppSystem
for SAP HANA)
HP builds an HP
AppSystem for
SAP HANA at HP
factory
Preconfigures
the appliance
Installs HANA
Software image
HP
AppSystem
for SAP HANA
appliance
delivered
to customer
Standard HW
install by CE
and
integrated in
customer DC
HP
implements
SAP HANA
according to
customer use
case via
FastStart
service
Improved delivery times, high level of customer satisfaction
20
© Copyright 2012 Hewlett-Packard Development Company, L.P. The information contained herein is subject to change without notice.
SAP HANA
working,
turned over to
customer
and supported
in production
SAP HANA - Tailored Data Center Integration
What was announced? For Enterprise Storage
• In June 2013, SAP announced a pilot for SAP
HANA Tailored Data Center (TDC) integration
• Goal is to leverage existing datacenter storage
solution for SAP HANA
• Phase 1 (pilot phase) began Q2’13 and last
through Q4’13. Phase 2 (GA) have begun Q4’13
and was limited to Max Attention Customers
only – already changed to minor support
options
• Certification will vary by customer “tailored” to
their data center resources
21
© Copyright 2012 Hewlett-Packard Development Company, L.P. The information contained herein is subject to change without notice.
Additional SAP HANA offerings
•
•
•
22
SAP extends
HANA offering to
HANA Enterprise
Cloud (HEC)
HEC is first
offered out of SAP
own IT-centers
but SAP is opening
this to partners
Technically it is
not really cloud,
more hosting
Low
volume/
business
© Copyright 2012 Hewlett-Packard Development Company, L.P. The information contained herein is subject to change without notice.
Freigaben für SAP HANA
Heutiger (eigentlich gestriger) Stand:
• Analytics (BW, BI, BO) – aber kein Doublestack s.U.
• Business Suite
•
•
•
ABAP Szenarien
NW 7.40+
Viele JAVA Szenarien
SAP note 1849151 - SAP NetWeaver 7.4 Java on HANA
Aber Achtung!!:
• Kein Doublestack
• Solution Manager ist neu installierbar aber nicht migrierbar
• Keine PI Central Services
• IMMER in der PAM (Product Availibility Matrix der SAP) nachschauen
23
© Copyright 2012 Hewlett-Packard Development Company, L.P. The information contained herein is subject to change without notice.
System Landscape Impact of Migration to SAP HANA
Source SAP AG
24
© Copyright 2012 Hewlett-Packard Development Company, L.P. The information contained herein is subject to change without notice.
HP- IT runs SAP HANA
HP Use Case
1
2
3
Business Innovation Description
Consumption
Real-Time Supply
Chain Analytics
HANA-powered Supply Chain Business Warehouses
Accelerated self service analytic modeling to drive real-time
visibility on demand, fulfillment and improved inventory
leveling.
HANA: 7-10 TB
 Reduced upgrade
BI Suite Users: 1,500
time/cost
Predictive Users: 3
Financial Planning
HANA-powered SAP Business Planning
Drive accelerated and sophisticated scenario planning in
real-time and engage end users with near instant returns on
simulations and what-if scenarios.
HANA: 1-2 TB
BI Suite Users: 500
Quote-to-Cash
HANA-powered Quote-to-Cash
Acceleration of core ECC processes in key areas such as
order management administration, month/quarter/fiscal
year end processing and live operational reporting.
Delivering modern ‘experience-at-scale’ to users.
HANA: 28 TB
 HANA-based ECC
ECC Users: 2,000
processing
BI Suite Users: 1,000  Real-time analytics
From >2 hours to 88 seconds
improved runtime results
25
Previous query time of over
1.5 hours runs in 1.02
HANA
© Copyright 2012 Hewlett-Packard Development Company, L.P. The informationseconds
contained hereinon
is subject
to change without notice.
Impacts
 First HP HANA
implementation
Improved visibility of
real-time data for faster
decision making
Was kann die Zukunft bringen ?
• Weitere Konsolidierung Richtung ‚Eine Datenbank‘
• Weitere Beschleunigung durch Verlagerung von Logik zu den Daten
• Flexiblere Deploymentmöglichkeiten:
26
•
MCOS und MCOD
•
Virtualisierung
© Copyright 2012 Hewlett-Packard Development Company, L.P. The information contained herein is subject to change without notice.
27
© Copyright 2012 Hewlett-Packard Development Company, L.P. The information contained herein is subject to change without notice.
Fragen ?
© Copyright 2012 Hewlett-Packard Development Company, L.P. The information contained herein is subject to change without notice.

Download Report