SAP HANA als Entwicklungsplattform
Matthias Kupczak
HANA Center of Excellence (CoE) Switzerland
SAP Forum - 12. Juni 2013
3
SAP HANA
Extended Services
(XS)
Embedded
application server
SAP HANA
A Database for
application logic?
1
SAP HANA
development tools
2
4
SAP NetWeaver
Application Server
on SAP HANA
5
Demo
In-Memory Computing Implications
Delegation of data intense operations to the in-memory computing
Application Layer
Data Layer
Today‘s applications
execute many data
intense operations in
the application layer
High performance apps
delegate data intense
operations to the
in-memory computing layer
In-Memory Computing Imperative:
Avoid movement of detailed data
Custom development on SAP HANA
Options for customers and partners
CD / PD = customer development / partner development, SoH = SAP Business Suite powered by SAP HANA
1) Accelerators for
Add-Ons
develop new applications running side-by-side with Business Suite (similar HPAs)
accelerate existing Z-coding, develop application-specific
accelerators
possible since AS ABAP 7.0x SAP Business Suite SAP HANA Any DB CD / PD SAP Suite / BW SAP HANA CD / PD
2) Add-Ons for Suite /
BW on HANA
customer-specific developments
enable existing Add-Ons to run on SoH / BW
optimize them for SAP HANA
technology
develop completely new Add-Ons
SAP HANA
Any Client
3) New applications
on HANA XS
develop new applications running with SAP HANA Extended Services (XS)
specifically designed and implemented for SAP HANA
technology
SAP XS-Engine
SAP HANA
New Applications / any app. server
4) New applications
develop new applications running with SAP HANA
Any application server with common DB interfaces, e.g. SQL, JDBC, ODBC, etc.
SAP HANA Platform
The Agony of Choice
logic as close as possible to the data
Pre-defined or own developed models within the database Data available
instantaneously
NW AS, HTML5-based, SAP BusinessObjects BI, third party tools, any application Server
XS Engine
Application Services Web
Resource oData Service
Database Layer Physical Tables
SAP HANA PLATFORM
Customer Views Customer Queries
Customer SQL Script
Stored Procedures Modeled / Scripted views
SAP- delivered
HANA Development
https, ODBC, JDBC, oData, SQL, MDX, …
Integration Layer Libraries, R-integration, Hadoop, data sources
SAP HANA is an open platform!
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
SAP HANA Development
SAP HANA Modeling / Development
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
Scripting
Main procedural language of the SAP HANA database Push data intensive operations into the database
Utilized in script-based Calculation views and procedures
SQL
Script
Modeli
ng
Views
Leverage the power of external libraries
Open-Source, statistical functions through R Integration leveraging predefined functions
Intregr. Libraries
SAP HANA embedded application server
SAP Extended Services (XS)
Presentation logic
Control flow logic
Calculation logic
Client
Data
Data artifacts
Control flow artifacts
Presentation artifacts
HANA
Scope & features
•
Lightweight small web-based
applications
•
leveraging the built-in strengths of SAP
HANA capabilities
•
minimize
“layers”
•
with an http-based UI (browser,
mobile apps)
•
run directly on SAP HANA, without
an additional external application
SAP ABAP Netweaver Application Server
NW Releasses
•
NetWeaver 7.3x first release ready for HANA
•
NetWeaver 7.40 massive HANA optimizations
SAP ABAP Optimizations
•
HANA optimized tools
•
SQL Trace (ST05)
•
Runtime Analysis (SAT)
•
Code Inspector (SCI)
•
DBACOCKPIT (ST04)
•
Statistical records (STAD)
In-Memory HANA DB
To guarantee the persistency
Development Artifacts
Disk
ABAP Application Server
Customer Schema SAP Schema
Application logic
Data transfer via network
NW ABAP Optimizations
DEMO
Plunge into the real world…
HANA Models
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…
Thank you!
And enjoy SAP HANA @ SAP FORUM 2013 - Baden
Matthias KupczakHANA CoE Switzerland
SAP Switzerland AG
Althardstrasse 80 8105 Regensdorf
matthias.kupczak@sap.com www.sap.com