Tuesday, September 20, 2016

SAP HANA SPS 11 new features


SAP HANA SPS 11 is available and comes with new capabilities to innovate modern
applications, accelerate insights, and simplify IT. Customers continue to select SAP HANA
to run mission critical applications and create next-generation applications that converge transactional,
analytical, predictive and streaming data processing. Now, SAP HANA SPS 11 allows you to innovate even faster by leveraging micro services architectures through a broaden choice of programming languages. And you can also transparently accelerate insights on any kind of data – including geospatial and data streams – from any source. With SAP HANA SPS 11

SAP HANA SPS 11 also delivers several enhancements to development tools and data modeling,
to simplify application development and accelerate application performance.
These include a new “where-used list” functionality to find object dependencies,
enhancements to SQL scripts, and enhancements SAP HANA calculation views to SAP Power Designer.

Accelerate Insights:

SAP HANA SPS 11, can transparently mange large data volumes by moving data across memory, disk, and Hadoop/SAP IQ with the Data Lifecycle Manager (DLM) tool. This allows you to gain total visibility from data across your organization and optimize price-performance considerations


To speed-up Hadoop data analysis, SAP HANA SPS 11 includes a new SAP HANA Vora connector. SAP HANA Vora is the new in-memory query engine for Apache Spark and Hadoop that adds business context to analysis by combining enterprise and Hadoop data.



In the area of data integration, SAP HANA SPS 11 delivers new adapters to replicate or perform bulk data loads from SAP Business Suite DataSources (BW Extractors), SAP Business Suite on SAP ASE, Microsoft Excel, and SOAP Web Services. To facilitate data discovery, the new Enterprise Semantic Services available in SAP HANA SPS 11 helps developers, and business users search SAP HANA database tables and remote sources to identify relevant business content. These services use metadata, semantic information, and table contents to build knowledge graphs that answer users’ search requests.

In SAP HANA SPS 11, Smart Data quality adds survivorship rules for data cleansing and reverse geocoding capabilities for data enrichment. Survivorship rules use multiple data records to create a new one, based on predefined custom rules, such as creation date, completeness of the data and source of the data. Reverse geocoding helps to identify all addresses in given radius from the geolocation.

 Simplify IT:

SAP HANA is an ideal platform to run mission-critical applications and simplify IT landscape with its built-in application services, advanced data processing and data integration and quality services.

SAP HANA SPS 11 comes with several high availability and disaster recovery capabilities, to further strengthen the platform and deliver business continuity. The new Hot Standby functionality helps you regain faster access to data after a data center failure, by enabling applications to fail-over to a fully up-to-date standby database. The primary and the standby databases as kept synchronized by continuously replaying logs.



Additional capabilities in SAP HANA SPS 11 can help you shorten the database recovery time even further. For example, you can now analyze database logs and parameters while the database is down, restart the database recovery from the point of failure, rather than from the beginning, and perform parallel backup and recovery.

In the area of security, SAP HANA SPS 11 delivers built-in SQL injection prevention functions to prevent malicious SQL code execution, and a new security dashboard in SAP HANA Cockpit to give you complete visibility into security KPIs.



For your SAP landscapes, integration with SAP Solution Manager – Early Watch Alerts and SAP Security Baseline – simplifies the monitoring of security breaches and the implementation of default security policies across all SAP systems.

In SAP HANA SPS 11, SAP HANA database administration has been further simplified. For example, you can automatically partition rapidly growing tables using dynamic range partitioning and achieve optimal resource utilization for data loads and transformations, by allocating system resources (CPU threads and memory) to individual processes.

On the tools front, SAP HANA Cockpit, a modern web based administration tool, supports delta backup, database start, stop & restart, analysis of diagnostic files, log analysis when the system is down, and the troubleshooting during scheduled or unscheduled system maintenance.





SAP HANA Cockpit also includes enhanced administration capabilities for Dynamic Tiering, Smart Data Access, Remote Data Sync and the SAP ASE accelerator. SAP HANA Database Control Center, a tool designed to streamline management of multiple SAP HANA systems, comes with enhanced installation capabilities and centralized configuration management.

Openness is a key theme of SAP HANA. You can expand your hardware choices as IBM Power Systems include support for SAP Business Suite applications, SAP Business Warehouse scale-out features, and virtualization of SAP HANA production instances for more flexible deployment options.

Additionally, the SAP HANA certification program has been expanded to include synchronous storage mirroring tools, Smart Data Integration/Smart Data Access adapters and additional database backup and recovery tools.



  1. Download SAP HANA SPS11 from SAP Service Marketplace : https://support.sap.com/swdc
  2. SPS11 release notes are available at http://help.sap.com/hana/Whats_New_SAP_HANA_Platform_Release_Notes_en.pdf
  3. The SPS11 release note (2227464) can be found at http://service.sap.com/sap/support/notes/2227464

5 comments: