Short Presentation Title

SAP HANA als Entwicklungsplattform
Matthias Kupczak
HANA Center of Excellence (CoE) Switzerland
SAP Forum - 12. Juni 2013
1 2
SAP HANA
A Database for
application logic?
SAP HANA
development tools
3
SAP HANA
Extended Services
(XS)
Embedded
application server
4
SAP NetWeaver
Application Server
on SAP HANA
5
Demo
In-Memory Computing Implications
Delegation of data intense operations to the in-memory computing
Today‘s applications
execute many data
intense operations in
the application layer
Application Layer
Data Layer
In-Memory Computing Imperative:
© 2013 SAP AG or an SAP affiliate company. All rights reserved.
High performance apps
delegate data intense
operations to the
in-memory computing layer
Avoid movement of detailed data
Calculate first, then move results
4
Custom development on SAP HANA
Options for customers and partners
1) Accelerators for
Add-Ons
2) Add-Ons for Suite /
BW on HANA
SAP
Business
Suite
CD /
PD
SAP
Suite / BW
Any DB
SAP
HANA
SAP HANA
CD /
PD
3) New applications
on HANA XS
4) New applications
Any Client
New Applications /
any app. server
SAP XS-Engine
 develop new applications
running
side-by-side
with
Business Suite (similar HPAs)
 accelerate existing Z-coding,
develop application-specific
accelerators
 customer-specific
developments
 enable existing Add-Ons to
run on SoH / BW
 optimize them for SAP HANA
technology
 possible since AS ABAP 7.0x
 develop
completely
Add-Ons
SAP HANA
SAP HANA
 develop new applications
running with SAP HANA
Extended Services (XS)
 specifically designed and
implemented for SAP HANA
technology
 develop new applications
running with SAP HANA
 Any application server with
common DB interfaces, e.g.
SQL, JDBC, ODBC, etc.
new
CD / PD = customer development / partner development, SoH = SAP Business Suite powered by SAP HANA
© 2013 SAP AG or an SAP affiliate company. All rights reserved.
5
SAP HANA PlatformSAP HANA is an open platform!
The Agony of Choice
Not
SAP applications
benefitsBI,ofthird
HANA
capabilities!
NW only
AS, HTML5-based,
SAP BusinessObjects
party tools,
any application Server
https, ODBC, JDBC, oData, SQL, MDX, …
Web
Resource
oData Service
SAPdelivered
XS Engine
Application Services
Customer Views
Customer
Queries
Customer SQL
Script
Modeled / Scripted views
Stored Procedures
SAP HANA PLATFORM
Database Layer
Integration Layer
logic as close as
possible to the data
© 2013 SAP AG or an SAP affiliate company. All rights reserved.
HANA Development
Physical Tables
Libraries, R-integration, Hadoop, data sources
Data available
instantaneously
Pre-defined or own
developed models
within the database
6
Integrated development scenarios
Application Function Library (AFL) / Business function library (BFL) &
Predictive Analytic Library (PAL)
UI integration / SAPUI5
External Libraries / e.g. Statistical language R
External Data integration / e.g. Hadoop cluster
© 2013 SAP AG or an SAP affiliate company. All rights reserved.
7
Scripting
Modeling
SAP HANA Modeling / Development
Views





SQL
Script
 Main procedural language of the SAP HANA database
 Push data intensive operations into the database
 Utilized in script-based Calculation views and procedures
Intregr.
Libraries
Attribute Views (Dimensions, Time, Hierarchy, Derived)
Analytic Views (Star schemas, facts, calculations)
Calculation Views (Composite views, Modeled or Script)
Transportable design time artifacts stored in the repository
Runtime objects (Column store views) are generated from the modeled views
 Leverage the power of external libraries
 Open-Source, statistical functions through R Integration leveraging predefined functions
SAP HANA Development
© 2013 SAP AG or an SAP affiliate company. All rights reserved.
8
SAP HANA embedded application server
SAP Extended Services (XS)
Scope & features
•
Lightweight small web-based
applications
•
leveraging the built-in strengths of SAP
HANA capabilities
•
Client
Presentation logic
Presentation artifacts
HANA
Control flow logic
minimize “layers”
•
with an http-based UI (browser,
mobile apps)
•
run directly on SAP HANA, without
an additional external application
server
© 2013 SAP AG or an SAP affiliate company. All rights reserved.
Control flow artifacts
Calculation logic
Data
Data artifacts
9
SAP ABAP Netweaver Application Server
NW Releasses
•
NetWeaver 7.3x first release ready for HANA
•
NetWeaver 7.40 massive HANA optimizations
ABAP Application Server
Data transfer via network
DDIC, DB Interface, DBSL
SAP ABAP Optimizations
•
In-Memory HANA DB
Development
Artifacts
HANA optimized tools
•
•
•
•
•
SQL Trace (ST05)
Runtime Analysis (SAT)
Code Inspector (SCI)
DBACOCKPIT (ST04)
Statistical records (STAD)
© 2013 SAP AG or an SAP affiliate company. All rights reserved.
Application logic
Customer Schema
SAP Schema
To guarantee the persistency
Disk
10
NW ABAP Optimizations
*Decision Tables
© 2013 SAP AG or an SAP affiliate company. All rights reserved.
11
DEMO
Plunge into the real world…
HANA Models
Consume HANA artifacts with SAP NW Application Server
Zusammenfassung – 5 Punkte zum Mitnehmen
1. SAP HANA is an open & integrated development Platform
2. Application logic is moving into the database layer
3. Accelerated and extended use cases
4. New SAP NW applications significantly benefit of HANA
capabilities…
5. … BUT is further on database independent
© 2013 SAP AG or an SAP affiliate company. All rights reserved.
13
Thank you!
And enjoy SAP HANA @ SAP FORUM 2013 - Baden
Matthias Kupczak
HANA CoE Switzerland
SAP Switzerland AG
Althardstrasse 80
8105 Regensdorf
[email protected]
www.sap.com