SAP HANA als Entwicklungsplattform Matthias Kupczak HANA Center

SAP HANA als Entwicklungsplattform Matthias Kupczak HANA Center of Excellence (Co. E) 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 Net. Weaver 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 n develop new applications running side-by-side with Business Suite (similar HPAs) n accelerate existing Z-coding, develop application-specific accelerators n possible since AS ABAP 7. 0 x CD / PD n customer-specific developments n enable existing Add-Ons to run on So. H / BW n optimize them for SAP HANA technology n develop completely new Add-Ons 3) New applications on HANA XS 4) New applications Any Client New Applications / any app. server SAP XS-Engine SAP HANA n develop new applications running with SAP HANA Extended Services (XS) n specifically designed and implemented for SAP HANA technology n develop new applications running with SAP HANA n Any application server with common DB interfaces, e. g. SQL, JDBC, ODBC, etc. CD / PD = customer development / partner development, So. H = SAP Business Suite powered by SAP HANA © 2013 SAP AG or an SAP affiliate company. All rights reserved. 5

SAP HANA Platform. SAP HANA is an open platform! The Agony of Choice Not only SAP applications benefits. BI, ofthird HANA capabilities! NW AS, HTML 5 -based, SAP Business. Objects party tools, any application Server https, ODBC, JDBC, o. Data, SQL, MDX, … Web Resource o. Data Service SAPdelivered XS Engine Application Services Integration Layer logic as close as possible to the data © 2013 SAP AG or an SAP affiliate company. All rights reserved. Customer Queries Customer SQL Script Modeled / Scripted views SAP HANA PLATFORM Database Layer Customer Views Stored Procedures 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 / SAPUI 5 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 • 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. Client Presentation logic Presentation artifacts HANA Control flow logic Control flow artifacts Calculation logic Data artifacts 9

SAP ABAP Netweaver Application Server NW Releasses • Net. Weaver 7. 3 x first release ready for HANA • Net. Weaver 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 (ST 05) Runtime Analysis (SAT) Code Inspector (SCI) DBACOCKPIT (ST 04) 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 1. AS ABAP • NEW tools with NW 7. 40 • e. g. code inspections, Runtime Analysis • Get SAP standard optimizations • Extended UI experiences due to HANA capabilities 2. Push down • Optimize ABAP source code (open SQL optimizations) • Replace „SELECT * …“ into „SELECT <fieldlist>“ • SQL push down instead of loop internal table 3. HANA Dev. • HANA capabilities (Views, Stored Procedures, DT*) • Integration with external data and or programming libraries • Consume high performance HANA artifacts in ABAP *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 Co. E Switzerland SAP Switzerland AG Althardstrasse 80 8105 Regensdorf matthias. kupczak@sap. com www. sap. com