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