What is new in SAP HANA SPS 09

Michael Eacrett

Posted by Michael Eacrett on October 21, 2014

VP Product Mangement

More by this author


Introducing SAP HANA SPS 09: The Platform for All Applications

SAP HANA SPS 09 provides numerous exciting functionalities developed by SAP, as well as additional capabilities provided by SAP co-innovation partners. This new release renews our commitment to accelerating cloud adoption, providing the most powerful platform for both transactional and analytical applications, creating instant value from big data assets, and enabling co-innovation with our customers and partners.

When it comes to cloud enablement, SAP HANA SPS 09 lets you run multiple independent SAP HANA databases in one single SAP HANA system (SID) and mange as a single unit. We call this functionality Multi-tenant database containers and it is specifically designed to simplify database administration, while maintaining a strong separation and isolation of data, users, and system resources, among individual tenant databases. This innovation allows you to dramatically lower the TCO of your installations–whether that be on-premise or in a cloud environment. Additionally, co-innovations with partners such as IBM, Hitachi and Unisys offers a broad array of secure and professionally managed SAP HANA Enterprise Cloud (HEC) services to accelerate cloud deployments and reduce migration risk.

SAP HANA SPS 09 greatly improves the application development experience with a number of new enhancements to both tools and the core platform. On the tools’ front, SAP HANA Web-based Development Workbench has new SQLScript editor, SQL Script debugger and a Calculation View editor, while SAP HANA Studio has extended its code completion capabilities and offers end-to-end debugging. Additionally, the Visual Application Function Modeler (AFM), allows developers to build reusable application functions based on complex algorithms. The AFM provides prebuilt integration with predictive analysis libraries (PAL), business function libraries (BFL) and R, allowing developers to easily tailor the existing algorithms to specific analytical application needs and then run them in SQLScript.

On the platform front, SAP HANA SPS 09 turbocharges advanced analytics with many new innovations. It exposes to developers a native Graph Engine to efficiently persist and analyze property graphs without duplicating data. This simplifies the analysis of complex relationships and the uncovering of new insights. Additionally, SAP HANA SPS 09 includes Nokia/HERE maps and spatial content to facilitate the development of applications that leverage location-based services. Text mining capabilities have also been added to the platform to help identify relationships among documents. As an example, documents can be stored, indexed and ranked based on a reference document or key terms.

Big data and IoT
open new challenges and opportunities for businesses. SAP HANA SPS 09 comes packed with new functionalities to help your company to operate in this new reality and create instant value from the variety of your big data assets. The new smart data streaming capability captures, filters, analyzes and takes action on millions of events (streaming data) per second, in real-time. To optimize available resources, smart data streaming can be configured to pass high value data in SAP HANA for instant analysis and direct remaining data to Hadoop – for historical and trending analysis. Of course, HANA can analyze data in both HANA and Hadoop at the same time through Smart Data Access, but HANA can also now call a Hadoop Map Reduce job directly from HANA and then bring the result set back to HANA from Hadoop/HDFS for additional analysis. Another powerful feature is dynamic tiering, which can move warm data from memory to disk – still in columnar format, optimizing in-memory usage for extremely large data volumes. This will enable customers to achieve great performance on hot data and great price-performance on hot and cold data. Moreover, smart data integration and smart data quality in SAP HANA SPS09 enables the provisioning filtering, transformation, cleansing and enrichment of data from multiple sources into SAP HANA, eliminating the need for a separate ETL or replication stages . Pre-built adapters are available for common data sources such as IBM DB2, Oracle, Microsoft SQL Server, OData, Hadoop and Twitter, and an open SDK is also available to build new adapters. In addition, special adapters are provided to consume SAP Business Suite data from databases such as IBM DB2, Oracle and Microsoft SQL Server. Smart data integration is architected for cloud deployment requiring no firewall exceptions to provision data to HANA in cloud.

is an exciting theme in SAP HANA SPS 09. You can now choose from 400+ SAP HANA configurations supplied by 15 different SAP partners. This is 4 times the number of server configuration options we had in August of 2013. Co-innovations with partners such ad IBM and Hitachi has allowed us to leverage system virtualization at new levels with the support of LPARs for optimal system resource utilization. Scale-up configurations have also expanded with new certified appliances from Cisco, HP and SGI. Additionally relaxed hardware requirements, support for lower cost Intel E5 processors, and new guidelines to utilize existing networking components – part of SAP HANA Tailored Datacenter Integration – provides a new choice to start small and grow your configurations as needed, reducing adoption barriers and improving TCO for SAP HANA.

Feedback from both press and analysts on SAP HANA SPS09 has been extremely positive. Read the full press release announcing the new HANA innovations.

Interested in more details about all of the new features and functionalities in SAP HANA SPS 09? Check out these resources:

Administration & Monitoring

Application Lifecycle Management

Backup & Recovery

SAP DB Control Center

Development Tools

Dynamic Tiering

Full-Text Search Hadoop Integration HANA Modeling

HANA SQL and Core

HANA Scalability

Multitenant Database Containers

Predictive Analysis Library

SAP River

Smart Data Integration and Smart Data Quality
Security Smart Data Streaming SQLScript
Series Data Platform Lifecycle Management Text Analysis
Workload Management XS Programming Model

Interested to watch a video to better understand the new features and functions?

Please check out the brand new videos on SAP HANA Academy


Interested in joining a Live Expert Session where a Product Manager answers your SAP HANA questions? Then please have a look at the session schedule below.

To make it easy for you to register, please follow the link here


  • You only need to register one time. After that you will be immediately directed to the HANA Virtual Briefing Center.
  • Once you register, please click on the “HANA SPS09 Live Expert Sessions”.
  • Select the session you would like to join.
  • Reminders for sessions will be sent out.
  • The preferred method of attending these sessions should be via the computer. However, there will be a dial-in number for those who do not have access to a computer.
  • Live “chat” will be available for each call

After each session we provide a link to the recording and slides posted on this blog. Enjoy!

Date Time (EST) Topic Presenter /

Product Manager

Details / further info
December 2nd 11:00 AM – 12:00 PM Overview Session Michael Eacrett Join this session to hear an overview of what’s new in SAP HANA SPS09

Watch recorded session

December 5th 11:00 AM – 12:00 PM Mission Critical DC Operations Ralf Czekalla What’s New presentation for all kind of HA&DR topics

Watch recorded session

December 8th 12:00 PM – 1:00 PM SAP HANA Dynamic Tiering Richard Bremer, Courtney Claussen, Balaji Krishna The new optional component SAP HANA dynamic tiering adds a disk-based column store to the SAP HANA system

Watch recorded session

Check out slides

December 9th 11:00 AM – 12:00 PM Developer Experience – Modeling Christoph Morgen What’s new HANA modeling

Watch recorded session

Check out slides

December 9th 12:00 PM – 12:30 PM SAP HANA multitenant database containers Ron Silberstein (presenter), Joerg Hoffmeister This is a new architectural option for SAP HANA, which provides enhanced ability to deploy various applications and/or use cases on singular, productive, SAP HANA hardware – in a manner that is effective and efficient

Watch recorded session

Check out slides

December 10th 11:00 AM – 12:00 PM Smart data streaming Jeff Wootton An introduction to the new optional HANA component for real-time event stream processing (aka Complex Event Processing – CEP)

Watch recorded session

Check out slides

December 10th 12:00 PM – 1:00 PM Security Mark Hourani (presenter), Andrea Kristen We will give an overview of HANA’s security concept and cover the new security features added in SAP HANA SPS09

Watch recorded session

Check out slides

December 11th 11:00 AM – 12:00 PM Developer Experience – SQLScript Rich Heilman Learn about new features of the SQLScript editor and debugger as well as the SQLScript language

Watch recorded session

Check out slides

December 11th 12:00 PM – 1:00 PM Administration & Monitoring Melanie Handreck & Kaleem Aziz New in HANA SPS09 are HANA Cockpit and SAP DB Control Center (SAP DCC). Join to hear what’s new, as well as the benefits of Cockpit and SAP DCC

Watch recorded session

Check out slides (Administration & Monitoring)

Check out slides (SAP DCC)

December 12th 11:00 AM – 12:00 PM SAP HANA Predictive Analysis Library (PAL) + Application Function Modeling Mark Hourani + Christoph Morgen Learn about the latest enhancements to SAP HANA Predictive Analysis Library. Review the new algorithms in PAL

Watch recorded session

Check out slides

December 16th 10:00 AM – 11:00 AM HANA Scalability Ruediger Karl Explains some fundamental aspects of scalability in SAP HANA. Covers the advantages and disadvantages of scale-up and scale-out and how it will impact the performance of your SAP HANA system.

Check out slides

December 16th 11:00 AM – 12:00 PM Series Data Ron Silberstein New features for storing and analyzing data from sources like machines, stock market, etc.

Check out slides

December 17th 10:00 PM – 11:00 AM HANA Workload Management Ruediger Karl Get insights on new workload management features in SAP HANA. Covers aspects of controlling parallelism and resource consumption in HANA.

Check out slides

December 17th 11:00 AM – 12:00 PM Smart Data Integration and Smart Data Quality Subha Ramachandran and Fernando Velez Learn about the first set of EIM capabilities now natively available in SAP HANA for real-time replication, ETL and data quality to simplify landscapes and eliminate the need for a separate tool

Check out slides

December 18th 10:00 AM – 11:00 AM Developer Experience – Tools Thomas Jung See new developer features of both the SAP HANA Studio and SAP HANA Web-based development Workbench. New editors, easier debugging, enhanced wizards, code completion, etc.

Check out slides

December 18th 11:00 AM – 12:00 PM Developer Experience – Programming Model Thomas Jung SPS09 brings many new features to the XSJS and XSODATA programming models. In this session we will look at the new features, syntax, and entire new extended programming model libraries.

Check out slides

December 18th 12:00 PM – 1:00 PM Text Analysis Anthony Waite Learn about what’s new in Text Analysis

Check out slides



VN:F [1.9.22_1171]
Average User Rating
Rating: 4.7/5 (15 votes cast)
What is new in SAP HANA SPS 09, 4.7 out of 5 based on 15 ratings