Skip to Content
Product Information
Author's profile photo Joerg Latza

What’s New in SAP HANA 2.0 SPS 04

SAP HANA 2 is the business data platform for the intelligent enterprise. Leveraging state-of-the-art database and data management technology, advanced analytical capabilities and intuitive application development tools in the only all-in-one, in-memory-first data platform – SAP HANA 2 frees up valuable resources and human capital for new and innovative application development to meet your business’s strategic objectives.

Today we are pleased to announce the release of SAP HANA 2.0 SPS 04. SAP HANA 2.0 SPS 04 includes a mix of new and continuous innovations across the themes of database management, data management, analytical intelligence and application development.

Database enhancements allow for advanced data and privacy protection including enhanced data anonymization with additional algorithms and configurable retention policies for the audit log. Improvements for high availability/disaster recovery (HA/DR) will further increase system availability and help protect enterprise-critical applications with a new multi-target system replication option that now also supports multiple region-local A/A secondary, a further enhanced time travel option and a “Follow-the-sun” option that optimizes the latency for write transactions by rotating the primary system around the world. In addition to the enhanced support for Non-Volatile Memory, SAP HANA now also offers a fast-restart option that is using TMPFS on OS Level to significantly reduce restart times with existing hardware. The new Native Storage Extension allows tables, columns or partitions to be flagged as warm data, residing mainly on disk. Warm data is loaded to an in-memory buffer cache only as required for query processing. Enhancements in the areas of dynamic tiering, workload and performance management and analysis will further improve performance and usability and will reduce TCO and supportability.

Data Management enhancements include support for federated access to high-availability Hadoop clusters, and a generic adapter framework for Smart Data Access. Smart Data Integration now allows to group multiple agents, provides real-time support for Mainframe DB2 and integration into Web IDE. To enhance the quality of your data we provide geocoding support for India addresses and FIAS compliant address assignments in Russia. For data modeling, the Enterprise Architecture Designer now offers support for SAP Big Data Services and Hadoop Hive 2.0 data lakes as well as support for HANA versioned tables. Calculation View modeling via Web IDE now allows to integrate data sources more easily, comes with improved user experience, enhanced support for parallelization and extended variable support for models.

Analytical Intelligence enhancements further increase execution performance and productivity for data scientists by providing API’s for Python and R as well as a new Gradient Boosting Tree algorithm. New methods for linear referencing, hexagonal grid-based aggregation, labeling tools, new APIs with reduced memory footprint and Data Hub integration will allow you to gain the most insight from geocoding your business data. Improved flexibility, debugging support, new functions and algorithms as well as extended GraphScript capabilities and openCypher support allow more complex analyses and scenarios for your connected data.

Application Development and Tool enhancements include new functions for both SQLScript and SQL, SQLScript Debugger and Code Analyzer enhancements and a unit test framework. The Web IDE comes with improved editors, Python support, wizards and dialogs and now allows multiple workspaces and mass import of synonyms. A pending deployment indicator helps developer to keep track of their deployment. The XSA runtime now supports X.509 as well as SPNEGO authentication, supports tenant specific installations and support for symbolic links. The HANA Run Time Tools include an enhanced SQL console with session recovery, performance improvements and more flexibility. The catalog browser now supports search across multiple schemas and comes with an improved user experience.

These are just a few highlights of the capabilities in this release. Please watch the series of webinars highlighted below in which the SAP HANA Product Management team provides more details on the new features and enhancements:

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Prashant Dhas
      Prashant Dhas

      Thank you for the post.

      Author's profile photo Diana Lamce
      Diana Lamce


      When you will release  Hana 2.0 SP04 Exam ?



      Author's profile photo Henricus Bouten
      Henricus Bouten

      @dianalamce, Hi Diana,

      Thanks you for asking this question.

      The exam for SAP HANA 2.0 SPS04 (C_HANATEC_16) will be ready in Q4 2019.  It will build on knowledge of the following courses.

      • HA200 SPS04 (Collection 16)
      • HA201 SPS04 (Collection 16)
      • HA215 SPS04 (Collection 16)
      • HA250 SPS04 (Collection 16)

      The courses will be available around end Q3 2019.

      The HA240 SPS04 (Collection 16) has been moved to the SAP Certified Technology Professional - System Security Architect (P_TSEC10_75) where it fits better as a SAP HANA security course.

      -- Hay

      Author's profile photo Naren Karra
      Naren Karra

      Henricus Bouten , Hi ,

      Thank you for the info..


      Any information on this certification code: - C_HANADEV_15  and it's latest version.

      Any chance of C_HANADEV_16 coming up this year 2019 ?





      Author's profile photo Diana Lamce
      Diana Lamce

      Thank you Hay.

      I really appreciate.

      Author's profile photo Mohammad Saif
      Mohammad Saif

      Thank you @Joerg Latza for this post.

      Author's profile photo Gary Hiang Chan Tan
      Gary Hiang Chan Tan

      I want to ask you 3 question,

      1.  After getting C_hanatec16, what should a SAP basis aspire to be certified? Are those administration certificate for various databases(C_Tadm5x_*)still a long term certification plan by SAP?
      2. When is E_S4HCON_75 release by SAP and what is the road map of this certification?
      3. How is OS/db migration certification compared to E_S4HCON_75?

      Thank you for your time!