1 2 3 59 Previous Next

SAP HANA and In-Memory Computing

872 Posts



In the upcoming weeks we will be posting new videos to the SAP HANA Academy to show new features and functionality introduced with SAP HANA Support Package Stack (SPS) 10.


What's New with SAP HANA SPS 10 - by the SAP HANA Academy


The topic of this blog is the SAP Database Control Center (DBCC or DCC).





What's New?


Cloud Enablement


SAP HANA SPS 10 introduces support for registration of multitenant databases in DCC but also enables for the registration of SAP HANA system running in the cloud, like SAP HANA Cloud Platform (HCP) system or SAP HANA Enterprise Cloud (HEC) systems.


Run Simple


Configuration of DCC has been made easier through the use of the DBCCConfig role for post-installation setup and the documentation of how to perform the whole setup using a simple SQL script.


Enterprise Alert and Health Monitoring


New is the ability to store historical alert, availability, capacity, and performance health statistics for monitored systems. This makes it possible to built custom reports based on historical alert and health data, for example using SAP Lumira, SAP Crystal Reports, or even Microsoft Excel.





Tutorial Video


SAP HANA Academy - What's New with SAP HANA SPS 10: SAP DCC  - YouTube




Thank you for watching

You can view more free online videos and hands-on use cases to help you answer the What, How and Why questions about SAP HANA and the SAP HANA Cloud Platform on the SAP HANA Academy at youtube.com/saphanaacademy.


Follow us on Twitter @saphanaacademy


Connect with us on http://linkedin.com/in/saphanaacademy

New and updated security documentation is now available for SAP HANA SPS 10 on SAP Help Portal.


You'll find all the details in the What's New in the SAP HANA Platform. Here are some of the highlights:

SAP HANA cockpit

The SAP HANA cockpit now has two new security-related tile catalogs: one for user management and one for certficate management. Both catalogs have a link to the documentation, available directly in the cockpit.

Unified certificate handling

The X.509 client certificates required for securing external JDBC/ODBC communication channels, as well as several user authentication mechansims (SAML, X.509 certificates, logon tickets), can now be stored directly in the SAP HANA database. In-database certificate management is documented in a new section in the SAP HANA Security Guide.

Secure internal communication

Internal communication channels are now secured using a simple public-key infrastructure (PKI) that is set up during installation. In particular, this mechanism is used to secure communication between tenant databases in a system configured for high isolation. The Secure Internal Communication section of the SAP HANA Security Guide has been comprehensively updated.

SQL-based analytic privileges

SQL-based analytic privileges have been available for some time, but they are now supported by both the SAP HANA Web-based Developer Workbench and the SAP HANA studio. Both versions of the SAP HANA Developer Guide (for Web Workbench and for studio) contain updated information.

SAP HANA auto-content

The reference section of the SAP HANA Security Guide now includes information about delivery units installed as auto content.



In the upcoming weeks we will be posting new videos to the SAP HANA Academy to show new features and functionality introduced with SAP HANA Support Package Stack (SPS) 10.


What's New with SAP HANA SPS 10 - by the SAP HANA Academy


The topic of this blog is database backup and recovery.


What's New?


Delta Backups


SAP HANA SPS 10 introduces support for delta backups, both incremental and differential. Incremental backup saves the data changed since the last data backup while differential backups save all the data changed since the last full data backup.




Delta backups enable you to optimize your backup strategy, for example by less frequently executing the more time-consuming full data backups. Compared to log backups, delta backups can reduce the time needed for a recovery as the amount of log that needs to be replayed is reduced.


SAP HANA Cockpit


You can now back up the SAP HANA database using the SAP HANA cockpit. The progress of a backup is displayed on the Data Backup tile. Detailed information for each backup is available on the Backup Catalog page.


Tutorial Video


SAP HANA Academy - What's New with SAP HANA SPS 10: Administration - Backup and Recovery - YouTube




Thank you for watching

You can view more free online videos and hands-on use cases to help you answer the What, How and Why questions about SAP HANA and the SAP HANA Cloud Platform on the SAP HANA Academy at youtube.com/saphanaacademy.


Follow us on Twitter @saphanaacademy


Connect with us on http://linkedin.com/in/saphanaacademy

SAP HANA multitenant database containers is fully documented in the now updated SPS 10 documentation set available on SAP Help Portal (http://help.sap.com/hana_platform).


However, for those with a special interest in MDC, the most important content from the main SAP HANA guides has been compiled into a single document.


You'll find it here: http://help.sap.com/hana/SAP_HANA_Multitenant_Database_Containers_en.pdf


Let us know (using comments or 'Like' for this blog) whether or not you find this helpful and if you would like to see more of this type of "cross guide" from the documentation team.



In the upcoming weeks we will be posting new videos to the SAP HANA Academy to show new features and functionality introduced with SAP HANA Support Package Stack (SPS) 10.


What's New with SAP HANA SPS 10 - by the SAP HANA Academy


The topic of this blog is administration.


What's New?


SAP HANA Cockpit


The SAP HANA cockpit is an SAP Fiori Launchpad site that provides you with a single point-of-access to a range of Web-based applications for the administra tion of SAP HANA. You access the SAP HANA cockpit through a Web browser.


In SPS 10, SAP HANA cockpit has been greatly enhanced:

  • The administration and monitoring features of the SAP HANA cockpit are now split into the tile catalogs System Administration (for MDC) and Database Administration
  • Manage Services app (replaces Database Status app SPS 09): app that allows you to start/stop/remove services (same actions as in SAP HANA studio)
  • Performance app (replaces Memory Overview and Resource Utilization Statistics apps of SPS 09): This app allows you to visually analyze historical performance data across a range of key performance indicators related in particular to memory, disk, and CPU usage.
  • Monitor Statements app is a new app that provides you with information about the 100 most critical statements currently active in the database.
  • User Tables app is a new app that allows you to visualize tables by size, explore the usage history of tables, and move tables to warm storage.
  • Backup app that allows you to start new backups, monitor status and view the Backup Catalog
  • Integration for the SAP HANA Platform Lifecycle Management tool web (HDBLCM)


Tutorial Video


SAP HANA Academy - What's New with SAP HANA SPS 10: Administration - SAP HANA cockpit - YouTube




Multitenant Database Containers


Security of SAP HANA Multitenant Database Containers


SAP HANA SPS 10 introduces an additional hardening option for multitenant database container (MDC) isolation. In a regular configuration, all database processes in an MDC system run under a single operating system user, the Linux account that owns the software. Tenant databases are self-contained/isolated in terms of users, database catalog, repository, logs, etc. but from the operation system point of view share all resources. To provide additional protection at the OS level, you can now configure your system for high isolation, which provides a dedicated operating system user and group for each tenant database.



Integration with SAP HANA Cockpit


New System Administration catalog provides tiles for monitoring and managing tenant databases in multiple-container systems. Contains:

  • Manage Databases tile indicating the overall health of the system and status of tenant database. Opens the Manage Databases app where you can monitor the status and resource usage of individual databases and drill-down into the Manage Services, Performance Monitor and Alerts apps for individual database monitoring, stop, start, and delete existing tenant databases and even create new tenant databases.
  • System Alerts tile indicates the number of high and medium alerts currently raised in tenant databases and opens the Alerts app where you can view and analyze alert details.


Run Simple


Additional enhancement for MDC are a simplified setup for the webdispatcher, support for synonyms for cross-database queries and a new script to convert regular SAP HANA systems to multitenant databases




See SCN Document SAP HANA Multitenant Database Containers for a compiled guide on the topic from the documentation set.


Tutorial Video


SAP HANA Academy - What's New with SAP HANA SPS 10: Administration - MDC - YouTube




Thank you for watching

You can view more free online videos and hands-on use cases to help you answer the What, How and Why questions about SAP HANA and the SAP HANA Cloud Platform on the SAP HANA Academy at youtube.com/saphanaacademy.


Follow us on Twitter @saphanaacademy


Connect with us on http://linkedin.com/in/saphanaacademy

SAP HANA remote data sync is a completely new option that is included with SAP HANA SPS10, and it is also a mature technology that has been in the market for more than a decade. This blog post explains what it does, outlines three major use cases, and describes a bit about how to use it. And because SAP HANA remote data sync is too much for me to type I’ll refer to it as RDSync from here on.


So let’s get started.

What it does

Technically, the point of RDSync is to synchronize data between SAP HANA and many remote databases. Let’s take a second to say what each part of that sentence means.

First, synchronization. Data replication is the copying of data between two or more databases so that each has an up-to-date copy of the data. Data synchronization is a particular form of replication, built to replicate data across high latency or intermittent networks. It is session-based: each remote database initiates a synchronization session, uploads any changes made at the remote site to SAP HANA, downloads any changes from HANA to the remote site, and then the session is completed.

In many cases the remote database does not need all the data in SAP HANA, or in the same layout, so RDSync provides ways to subset and transform data as it moves between SAP HANA and the remote databases.



Next: SAP HANA. RDSync is based on the SAP SQL Anywhere data synchronization technology called MobiLink, but RDSync integrates the MobiLink synchronization server into the HANA Platform, with many benefits for IT staff who have to manage the server.

Third: “many remote databases”. The databases at remote sites are either SAP SQL Anywhere databases, which provide a rich client/server database on Windows, Linux and other operating systems, or are SQL Anywhere UltraLite databases, a compact database library that can be built into applications for mobile operating systems such as iOS or Android.

There are existing deployments of SQL Anywhere MobiLink with tens of thousands of remote databases, each with hundreds of tables. Scalability, performance, and correctness in managing these complex and large-scale deployments is a key part of RDSync’s role.

You can see from this description that RDSync joins the family of data provisioning technologies for SAP HANA: software that moves data between SAP HANA and other applications or data stores. In the diagram below, the technologies on the right move data between SAP HANA and other enterprise data stores: real-time replication with other relational databases (SAP Replication Server), complex and high-performance extract, transform and load operations (SAP Data Services), and data exchange with Business Suite (SAP Landscape Transformation).

The two technologies on the left can also exchange data between SAP HANA and external data sources, often over public networks. SAP Smart Data Streaming provides a fast way to collect data from multiple sources, and RDSync is more useful when there is a need for structured data at the remote site.



What it is for

The mainstream of the computing world is moving, as we have often heard, to a centralized cloud computing architecture in which all data is accessed over the Internet. Clearly RDSync is built for a different paradigm, in which data is stored at the edge of the network as well as at the center. Why would one use such a technology when Cloud is the mainstream?

There are three common use cases for RDSync that show why a distributed data model still has a role to play, even in this age of cloud computing, and I’ll look at each in turn. One is what we call “satellite servers”: remote workplaces where enterprise systems might not be available in an acceptable way, but where work needs to carry on. A second is one category of mobile applications: those that drive an employee’s whole day, and which are key to their productivity. Third, and maybe most importantly right now, is a set of Internet of Things (IoT) applications: while simple data acquisition is enough for some, other IoT applications need significant amount of computing, and of structured data, at the edge.

Let’s look at each one in turn.

Satellite Server use cases

Satellite servers are remote workplaces, where important business processes take place but which need to be able to operate even when not connected to a network. One extreme example is oil rigs, where an SAP offering called Transaction Availability for Remote Sites (TARS) has shown a way to bring SAP functionality to the most isolated of workplaces.

Oil rigs are technically sophisticated workplaces, but the network connectivity between the rig and the enterprise is a satellite link (very high latency) which can be interrupted at any time, especially when the rig is moving to a new site. Yet maintenance operations, which involve collaboration among workers, must carry on, and in fact are often best carried out when the rig is moving (so not actively drilling).

The TARS solution is built on RDSync and MobiLink technology, and makes SAP transactions available through UI5 web applications on the rig at all times, using a local SQL Anywhere server. It extends SAP business processes to new parts of the company.

Other industries where the TARS solution is finding a use include retail (an in-store server guarantees stores can keep running), other resource industries (mining, forestry), and transportation.

Mobility use cases

Instead of a whole workplace, the remote site may just be a tablet, a phone, or a laptop computer. Most mobile applications do not need a database on the device, and fewer still need a data synchronization architecture, but those that do need it are key applications which drive an employee’s whole day. Examples include inspections applications (asset management) for railways, direct store delivery applications for consumer goods companies, and inventory management applications for the retail industry, as well as industry-specific Customer Relationship Management appliations.

Internet of Things use cases

As with satellite server and mobility use cases, not all IoT solutions need RDSync, but some do. SQL Anywhere runs on “IoT gateways”: boxes containing a cheap single-board computer, like the Raspberry Pi and others designed more for industrial uses. It can collect data from sensors over low-powered radio or Bluetooth networks and relay it to HANA for analysis. Some set of IoT applications carry out significant computation at the IoT gateway, and rely on having structured data available, so a data synchronization solution makes sense. In one recent engagement, a 50-table database is being put onto an IoT gateway: even though the data collection feeds almost entirely into a single table, the other tables provide valuable metadata and also enable a smart application at the IoT gateway.

There’s a common thread here: the mainstream of computing deployments may be cloud-based, but that should not lead us to neglect these valuable niches where reliable, highly-available data at the edge is available to help extend business processes to new parts of the organization.

How it works

This is not the place for detailed product documentation on how to build solutions (see http://help.sap.com/hana_options_replication for more), but here is a brief description of how data synchronization works.

Each SQL Anywhere remote database has a built-in data synchronization client which can pick up changes made to the remote database, and communicate over public networks with the RDSync server. Periodically the synchronization client initiates a session: it uploads changes, receives an acknowledgement and then ensures they are not re-delivered, and then collects changes from SAP HANA. The protocol is a proprietary and high-performance communication mechanism that works over TCP/IP or HTTP protocols, and which takes full advantage of network security options.

The synchronization server does not have significant data storage of its own; all the metadata for an application is stored in a special schema in SAP HANA.

The server implements an event-based model: each synchronization request fires a number of events (eg, events to handle the upload data for each table) and the synchronization server runs so-called “synchronization scripts” for each event. It’s up to the developer to provide those scripts. Often, synchronization scripts are written in HANA SQL Script, and can be as little as a single SQL statement (eg, for an “upload_insert” event, the script may be a single INSERT statement).

The synchronization scripts can take advantage of built-in parameters that come from the synchronization client, so that each remote database may have a different set of data.

A framework of over 60 separate events allows for a large amount of customization, so that RDSync can handle the most demanding of applications. And a single server can handle multiple versions of an application or even multiple applications.

Being built on a mature technology, RDSync comes with a set of advanced features. Its design provides transaction integrity guarantees as well as proven performance and scalability; it provides end-to-end encryption both over the network and at the remote site; there are comprehensive logging and error-handling options, and the ability to integrate with a range of enterprise authentication systems.

(In this initial release, development time assistance is limited: this is not the easiest-to-use technology, and it takes an investment of time and learning to make the most of the powerful capabilities RDSync provides.)

SAP HANA integration

What is new in RDSync is the integration of the synchronization technology into the HANA platform. Instead of being a separate server that has to be managed by itself, RDSync is integrated into HANA’s capabilities.

  • Lifecycle management, from install to system rename and upgrade, or moving from one host to another, is all carried out using the SAP HANA lifecycle management tools
  • The SAP HANA name server utilities provide a single point of configuration, and also provides auto-start services as well as high availability in case the host running RDSync becomes unavailable.
  • Integration into HANA Cockpit and HANA Studio makes sure that system configuration and monitoring can be carried out as part of the broader picture of managing the HANA landscape.
  • The port assignments, monitoring capabilities, license management, and metadata schema are all created at install time in a systematic and reliable fashion, in a way that fits with SAP practices, for operational ease of use.

In conclusion: SPS10, SAP HANA remote data sync is a first release, but the core functionality is mature and proven, and the integration with HANA platform brings a new level of operational consistency for SAP customers.

How to buy it

SAP HANA remote data sync is a part of the SAP HANA real-time replication bundle, which also includes SAP Replication Server and SAP Landscape Transformation.

Customers using RDSync must also buy SAP SQL Anywhere for use at the remote sites; usually in the form of SAP SQL Anywhere remote database client.

The software is available from SAP Service Marketplace along with other SAP software. Look for it under the letter H for HANA in the SAP Software Downloads.

Support issues should be filed under the application component hierarchy codes of HAN-SYN and HAN-CPT-SYN for the monitoring components.

You can find out more by reading the documentation at http://help.sap.com/hana_options_rdsync, and the SQL Anywhere documentation at http://dcx.sap.com.

In February this year SAP introduced S4HANA. As the top brass at SAP has put it, this is the most important product from SAP since it introduced R/3 in 1992.


Some of the advantages of S4HANA as highlighted by SAP are:

Massive reduction in data footprint

Transactions are much faster

Simpler configuration

Reduction in DB maintenance


There are several other advantages too as highlighted by SAP which are also available in many other articles.


However,With S4HANA , SAP is throwing a different level of challenge to the various CIOs who are already invested heavily in SAP.


First of all, the scary part is that the infrastructure is going to be indirectly connected to the application. S4HANA , as the name suggests, runs on HANA database alone.For HANA, we can either have RHEL or SUSE linux as the OS. The customers can continue to run business suite on other databases until 2025, but if you need the latest innovations you need to be on S4HANA.This reduces the flexibility that most customers enjoyed earlier. They could choose their own hardware vendors and OS and also the database of their choice. With most customers the choice of database depended heavily on expertise available in-house. If you are a customer who outsources all your IT requirements, then we can argue that it will all be taken care of by the vendor. Even then, the internal IT staff who handles the vendor will be at a big disadvantage. There is also a lack of skill and understanding in the market when it comes to HANA as against the more established databases.


With flexibility being limited, the CIO will be faced with a difficult decision. Once he joins the S4HANA bandwagon there will be no looking back. There is no question of changing the ERP ever, as the infrastructure and database are all linked to the ERP solution. He can only hope that SAP will remain reasonable with the pricing while providing him with all the tools to provide the most suitable solutions to the business.


Secondly , the IT strategy/ road map will have to be changed. For example, I know a customer who is currently planning an SRM upgrade from 5.0 to 7.02. Due to certain complexities, one of their options is to install and implement a fresh system of the target version and then move required changes one by one from the old system to the new system. Additionally, they have also recently started an SCM implementation. With S4HANA, all these systems such as SCM, SRM and CRM are going to be part of the S4HANA system . So the question is , should the customer continue with these upgrades and implementations or should they immediately start thinking about S4HANA? Both these projects are going to run for at least a year if not more. They will result in significant costs to the customer.


In the past SAP has constantly churned out newer and newer versions with enhancements and functionality. Most customers who are several years behind SAP would hardly take notice of the new versions. They would chug along at their own speed and move to the new versions at their own pace, just before their current versions go out of support. However with S4HANA, customers need to change their strategy. They need to consider this right now and make changes in their strategy right now with the future in mind. Otherwise many of the projects that they are working on right now may seem obsolete when viewed from the perspective of S4HANA.


One of the other key aspects of S4HANA is simplification. Although it is true that S4HANA massively simplifies the usage and deployment of SAP, the one question everybody will ask is why the complexity was there in the first place. Wasn't it SAP themselves who got us into this complex landscape in the first place?



Regardless of all this, I believe that SAP has made the right decision. It is a very bold one , but I think it is the right one. While flexibility may be limited, how

many customers actually have the knowledge or the guts to go against a market trend and make a decision purely because he has analyzed and come to the conclusion that his decision will be better for business? I have seen that most customers like to play it safe and simply go with the marketing material that is provided by the ERP software providers to convince the business.It is true that the CIOs will have several new challenges to deal with, but ultimately I think they will stick with SAP and move to S4HANA.


Let us also look at it from another perspective. We constantly blame big companies of not being able to innovate or bring something new to the table. In this case SAP has done exactly that. It might cause some disruption to the current way of working and force the customers to take some tough decisions. However if this same innovation had been brought in by another new company we would have praised their ability to innovate and provide fresh solutions. We need to give credit where it is due. SAP is taking the trouble to change their own application to be simpler and faster. This is not something that most big companies actually have the will to do.


On the whole, these are interesting times. SAP is doing a great job of providing a lot of good material for S4HANA through open SAP courses and other blogs.However there are going to be several questions from customers on a case to case basis due to the complexities that exist specific to each customer.SAP needs to address these specific questions and this would provide customers with greater confidence.Another point that would greatly encourage the customer is if SAP could actually project the improvements to major business processes specifically for each customer. SAP should either provide a tool which partners/customers can use or a service should be created which provides this functionality. For example a customer should be able to determine that the cycle time for a particular activity will definitely improve by a factor of x if he implements S4HANA. This would help create a better business case for the customer to move to S4HANA.


Do let me know your thoughts on S4HANA in the comments section!



In the upcoming weeks we will be posting new videos to the SAP HANA Academy to show new features and functionality introduced with SAP HANA Support Package Stack (SPS) 10.


What's New with SAP HANA SPS 10 - by the SAP HANA Academy


The topic of this blog is security.


What's New?


User Management


Two new apps (tiles) have been added to the SAP HANA cockpit in the User Management catalog:

  • Assign Roles to User
  • Configure Role-Based Cockpit Access (defines which role has access to which cockpit tile catalog and/or group)


Both apps simplify role assignment, which helps in making the SAP HANA platform more secure.

Screen Shot 2015-06-25 at 09.52.08.png

Security is further enhanced by making JDBC/ODBC client connections for database users a matter of choice. For database users that only connect using HTTP(S), client connections can now be disabled.


A new option is available in the User editor of the SAP HANA studio: Disable ODBC/JDBC access.

Screen Shot 2015-06-25 at 10.15.27.png

Alternatively, you can also use the SQL statement:



Encryption: Unified Certificate Handling and Secure Internal Communication


SAP HANA SPS 10 introduces in-database X.509 client certificate management for:

  • All certificate-based user authentication mechanisms in SAP HANA: SAML, X.509, and logon and assertion tickets
  • SSL-secured communication for JDBC/ODBC clients


There is a new database object type for this purpose: certificate collection. New SQL statements: CREATE/DROP CERTIFICATE; CREATE/ALTER/DROP PSE. New system views for monitoring in-database certificates and certificate collections: CERTIFICATES, and PSE_CERTIFICATES, and a new system privilege CERTIFICATE ADMIN and SSL ADMIN.


In-database certificate management in SPS 10 can currently only be performed using SQL but there are two news apps in SAP HANA cockpit that provide view access: Certificate Store and Certificate Collections in the Certificate Management catalog.


Screen Shot 2015-06-25 at 10.36.09.png

In SPS 10, the main internal communication channels are now secured using public-key infrastructure (PKI), set up during installation. No user interaction is required for this. For multitenant database container (MDC) systems, secured internal communication is activated when MDC is configured for high isolation (see below).




Security of SAP HANA Multitenant Database Containers


SAP HANA SPS 10 introduces an additional hardening option for multitenant database container (MDC) isolation. In a regular configuration, all database processes in an MDC system run under a single operating system user, the Linux account that owns the software. Tenant databases are self-contained/isolated in terms of users, database catalog, repository, logs, etc. but from the operation system point of view share all resources. To provide additional protection at the OS level, you can now configure your system for high isolation, which provides a dedicated operating system user and group for each tenant database.


The number of features that can be disabled in multiple-container systems has grown from 24 (SPS 09) to 39 (SPS 10). This includes

  • Application Function Libraries (AFL) for business logic in native C++
  • R language
  • Low-level procedures used for the graph engine and the planning engine
  • Low-level procedures used for SAP HANA options  Dynamic Tiering and Smart Data Access (Federation).


User Self-Service Administration


SAP HANA SPS 10 simplifies user self-service administration by adding e-mail templates for new account, account activation and forgot password. Additionally the required configuration of the built-in application server (xsengine) can now be performed from a friendly web page. Run Simple!






Finally, SAP HANA SPS 10 introduces some enhancements for authorisation management. The most notable is SQL-based analytic privileges, which allows you to more easily formulate complex filter conditions that might be cumbersome to model using XML-based analytic privileges. SQL-based analytic privileges can be created both in the SAP HANA Web-based Development Workbench as with SAP HANA studio.


Tutorial Video


In this video, I will show how the new apps for SAP HANA cockpit, in-database certificate management, disable ODBC/JDBC access, user self-service administration and multitenant database container isolation mode.






See Security Documentation Updates for SPS 10


Thank you for watching

You can view more free online videos and hands-on use cases to help you answer the What, How and Why questions about SAP HANA and the SAP HANA Cloud Platform on the SAP HANA Academy at youtube.com/saphanaacademy.


Follow us on Twitter @saphanaacademy


Connect with us on http://linkedin.com/in/saphanaacademy


In the upcoming weeks we will be posting new videos to the SAP HANA Academy to show new features and functionality introduced with SAP HANA Support Package Stack (SPS) 10.


What's New with SAP HANA SPS 10 - by the SAP HANA Academy


To get a good overview from SAP Product Management about what’s new in SAP HANA SPS 10, see Michael Eacrett's blog on the SAP HANA community site or read the press release by SAP News: SAP delivers next release of SAP HANA.



What's New with SAP HANA SPS 10 - YouTube

You can view the full playlist here: What's New with SAP HANA SPS 10 - YouTube




What's New with SAP HANA SPS 10 - SCN Blogs

We also have posted additional blogs to SCN to provide some more context and links to additional documentation (when available) and other resources. We will keep these blogs updated in the next couple of weeks and feel free to add your comments should you have any questions.


SAP HANA SPS 10 What's New: Platform Lifecycle Management


SAP HANA SPS 10 What's New: Security


SAP HANA SPS 10 What's New: System Administration


SAP HANA SPS 10 What's New: Database Backup and Recovery


SAP HANA SPS 10 What's New: SAP DB Control Center


What's new for predictive in SAP HANA SPS 10?


What’s New in SPS10? SAP HANA remote data sync


New Development Tools Features in SAP HANA 1.0 SPS 10


New SQLScript Features in SAP HANA 1.0 SPS 10



For more information, see


SAP Notes


Thank you for watching

You can view more free online videos and hands-on use cases to help you answer the What, How and Why questions about SAP HANA and the SAP HANA Cloud Platform on the SAP HANA Academy at youtube.com/saphanaacademy.


Follow us on Twitter @saphanaacademy


Connect with us on LinkedIn



In the upcoming weeks we will be posting new videos to the SAP HANA Academy to show new features and functionality introduced with SAP HANA Support Package Stack (SPS) 10.


What's New with SAP HANA SPS 10 - by the SAP HANA Academy


The topic of this blog is platform lifecycle management.


What's New?


Two-Step Update


As of SPS 10, you can run an SAP HANA system update in two phases

  • an update preparation phase and
  • a resume update phase


The phased update aims to:

  • Lower the system downtime
  • Reduce the chances of a failed system update due to preliminary steps like archive preparation or dependency conflicts


The prepare update step is activated with the following flag (valid for both the command line tool HDBLCM and the graphical interface HDBLCMGUI.

./hdblcm --action=update --prepare_update 



During this phase, the files will be copied to the file system and all preparation actives are executed. Business is not interrupted.


The resume update step can be performed by any of the three SAP HANA Platform Lifecycle Management tools (command line, graphical or web). The tool will detect that the prepare update step has been executed and will automatically propose to resume. No additional flags are needed.


During the resume update step, SAP HANA is restarted, during which the software switch is executed. After restart, the delivery units are imported and any additional components (client, studio, afl) that have been selected in the first step are installed. During this phase business downtime occurs.





Database Isolation Mode for Multitenant Database Containers


Multitenant databases containers (MDC), introduced with SPS 09, are self-contained databases with their own set of users, database catalog, repository, etc. However, they share a common system database and operating system process, the <SID>adm user that owns the software.


For those not familiar with MDC, there is a full playlist on this topic on the SAP HANA Academy YouTube Channel:


Multitenant Database Containers - YouTube


SPS 10 introduces the option to run a multitenant database container system in high isolation mode. This way, each tenant database will run under it's own operating system user account and group. Additionally, internal database communication will be secured under the secured sockets layer (SSL) protocol, which encrypts the data flow.


You activate the high isolation mode for MDC either during the installation (selection on the system properties screen, or with parameter db_isolation=high), or for running systems with a python script. This operation and the required step are documented in the SAP HANA Administration Guide.


SAP HANA Cockpit integration and Add/Remove Host Support for Web UI

The SAP HANA database lifecycle manager is available in two flavors

  • the installer from the installation medium
  • a resident version for update and configuration (local installation and version compatible)


With the resident HDBLCM tool, you can perform a number of post installation tasks, like add or remove additional software components, etc.


As of SPS 10, the web version of the HDBLCM tool has been integrated with the SAP HANA cockpit. Furthermore, an important additional activity is now web-enabled: add/remove hosts for distributed systems or SAP HANA options.


Screen Shot 2015-06-24 at 22.11.25.png

Platform Lifecycle Management Enhancements


In previous editions of SAP HANA, we have seen gradual improvements of the whole process of installation and updating an SAP HANA system landscape that  culminated in a single tool for platform lifecycle management: hdblcm. With this tool, you can perform all the setup and post-setup configuration activities be it for single host system or a complex distributed landscape with standby node and SAP HANA options like dynamic tiering to manage hot and warm data.


With SPS 10, additional enhancements are introduced:

  • instant logging, which writes preliminary logs in the case that the action hangs or crashes
  • single location log collection for multiple-host setup
  • support for SAP HANA remote data sync (new SAP HANA option)
  • support for SAP HANA option roles


Tutorial Video


In this video, I will show how you can perform a 2-step update of an SAP HANA SPS 09 system to SPS 10 using a combination of both command line and graphical HDBLCM. You can also view how to configure an MDC system in high isolation mode during setup, and the new SAP HANA cockpit tiles to add or remove a host in a distributed landscape.



Thank you for watching

You can view more free online videos and hands-on use cases to help you answer the What, How and Why questions about SAP HANA and the SAP HANA Cloud Platform on the SAP HANA Academy at youtube.com/saphanaacademy.


Follow us on Twitter @saphanaacademy


Connect with us on http://linkedin.com/in/saphanaacademy



SAP HANA SPS 10 was released today.


If you want to delve deeper and see working examples of what's new in predictive then this blog can serve as your starting point.


The SAP HANA Academy produce hands-on video tutorials covering all aspects of SAP HANA and we have content covering SPS 10 from Day 1!


Here's the main playlist: Predictive Analytics - What's New SPS 10


The aim, as with previous SAP HANA support package stacks, is to publish a tutorial for each and every new SAP HANA predictive analysis library (PAL) algorithm as well as covering key enhancements to existing algorithms!


Here are direct links to all of the new PAL videos currently published that feature SPS 10:


Getting Started

PAL: 84. Getting Started with the Predictive Analysis Library

PAL: 91. Exception Handling


Data Preparation

PAL: 92. Data Preparation - Binning

PAL: 93. Data Preparation - Partitioning


Time Series

PAL: 85. Time Series - White Noise Test

PAL: 86. Time Series - Trend Test

PAL: 87. Time Series - Seasonality Test

PAL: 94. Time Series - Single and Double Exponential Smoothing

PAL: 95. Time Series - Seasonal ARIMA Model



PAL: 88. Statistics - Grubbs' Test



PAL: 89. Classification - Parameter Selection and Model Evaluation (PSME)

PAL: 97. Classification - Confusion Matrix



PAL: 90. Clustering - Latent Dirichlet Allocation (LDA) for Text Mining

PAL: 96. Clustering - Gaussian Mixture Model


Each tutorial is accompanied by the SQL script shown and you can also download the example data in order to try the algorithms out for yourself. You'll find the github link in the playlist description or go there directly via: saphanaacademy/PAL

Here's the full academy playlist for the PAL: Predictive Analysis Library


Watch this space as there will be more videos added in the coming days...


UPDATE: June 26th: videos 91-95 added covering exception handling, accessing PAL via SQL window functions, and seasonal ARIMA modeling.

UPDATE: June 29th: videos 96-97 added covering Gaussian mixture model and confusion matrix.


As always feedback is most welcome – in the YouTube comments section, below, tweet me @pmugglestone or mailto:HanaAcademy@sap.com.



What is SAP S4 HANA?

In two words, “S” for Simple, and “4” for Fourth Generation. That’s what SAP S4 HANA is – a highly evolved suite of simple applications (or sERP) running on the HANA database system.

SAP S/4 HANA is SAP’s next generation Business Suite. It was unveiled in New York on Feb 3rd, 2015. It is fully architected for the most advanced In-Memory Platforms, and is designed on most modern principles, with SAP Fiori User Experience. It will be offered on Cloud, On-Premise and Hybrid Deployment option to provide maximum choices to Customers. It is designed to provide simplicity to customers, by connecting people, devices and networks in real time.

What are the Key Points/ Benefits of SAP S4 HANA?

  • Reduction in data foot print by a factor of 10, for lower TCO
  • Even the number of database tables is reduced 10:1 in many areas.
  • Transactions are 3 to 7 times faster
  • Simpler Test scripts and test data is built in
  • Reduction in DB maintenance
  • Alerts Mechanism introduced
  • It creates unique opportunities to dramatically simplify the data model: no aggregates, no indices, no redundancies
  • It is designed for the end user, offering SAP FIORI user interfaces, technology allows us not only to change the layout but also to switch from a functional or transactional operational model to a completely role-oriented one.

What do we mean by Simple Modules of SAP S4 HANA?

The first application to be fully re-written to take full advantage of SAP HANA is Simple Finance / sFinance focusing on Accounting, Cash Management and Integrated Business Planning.  This will allow organizations to have real time views of their financial positions and allow end of month closing to be done in hours not days. SAP did a table clean up. For example the very old Material Master Database Tables from R/2 times (MARA, …) are finally no longer around, only views on the data.

The result is dramatically higher speeds and a 1:10 reduction in Data Footprint. Imagine - a 1 Terabyte SAP Database is down to 100 GB. This year will see the arrival of sLogistics, the next wave of re-written SAP applications for HANA.

With S4 HANA SAP is offering Fiori for free, to allow for all SAP customers to leverage the enhanced user experience through innovative user interface across multiple devices.

Application Delivery Roadmap for SAP S4 HANA?

SAP has stated a “Phased Roll-out” strategy which will take years rather than months to deliver.

  • The first two modules will be Simple Finance (available now) and Simple Logistics (available soon). Following that, we expect functionality to compete with Salesforce and Workday – Sales, and HCM – to be delivered in 2015. Further modules will follow that based on popularity.
  • Today, with Simple Finance in the market, there is no difference between SAP S/4 HANA and Business Suite on HANA, from installation point of view. With Simple Logistics, we expect the first cloud-first release of a SAP ERP product. This likely will pave the way for a separate installation for SAP S4 HANA through 2016 and the regular Business Suite and S4 HANA will part ways.

Which Project Management Methodology to be used?

From Project Management Methodology point of view, both will work- From Solution Manager perspective, people can use ASAP methodology, while from General project management people stick to Agile methodology.


What are the Licensing Implications?

  • For the on premise edition, the pricing model is similar to the one we had with the SAP Business Suite powered by SAP HANA. So, from licensing point of view, for on premise, S4 and business suite on HANA, aren't different.
  • SAP is offering the following promotion until September 30th, 2015:
    • Existing SAP Business Suite customers have to procure the SAP HANA runtime license for SAP Business Suite (@15% HSAV = SAP HANA Software Application Value) and will get the SAP S/4HANA foundation-promotion license at no additional cost. 
    • Existing SAP Business Suite powered by SAP HANA customers with a valid SAP HANA limited runtime license for SAP Business Suite (LREA) are eligible for the SAP S/4HANA foundation promotion license without additional cost.
  • And regarding SAP Fiori, as already mentioned above, with S4 HANA SAP is offering Fiori for free.

What are the major offerings in SAP S4 HANA?

  • Row based, for even faster analytical reporting, on top of HANA Database, that will generate reports on the fly.
  • Analytical Processing on top of OLAP of HANA, will be faster.
  • BO was a separate system suiting HANA, but S/4 is inside and on top of HANA (instead just for HANA), and a core SAP Product.

Thanks to the comprehensive information available on SCN, integrating R with HANA is very easy .However, I could not find any information on SCN about calling an R procedure from within an SQL Procedure. This led to the idea of my first blog on SCN!

This blog intends to demonstrate passing data from SQL Procedure to a R Procedure, perform Analytics on the data and return the result to the calling SQL procedure.

            Let’s consider the following situation :


             The table (“MY_SCHEMA”.”INPUT_DATA”) consists of data related to parameters of flowers.

              Suppose there is a requirement to perform Clustering on the dataset, based on Sepal Length. The Column on which Clustering needs to be performed, has to be selected to a temporary variable and passed to the R Procedure as in the following screenshot :




           The R Procedure to perform the analytics will be as in the below screenshot :



          The Column “Sepal Length” is clustered into 10 Clusters.

          Output from R should be captured in a table type (“OUTPUT_FROM_R”  in the screenshot)

          The Output table type should consist of all the columns  which will be needed after  clustering.

          The output of the SELECT statement in the SQL Procedure will be as below :


               We can analyze how each of the species fall in different clusters based on the Sepal Length.


   Compiling and calling the procedures should be done in the following order :


               1. Compile R Procedure.

               2. Compile SQL Procedure.

               3. Call R Procedure inside the SQL Procedure.

               4. Call the SQL Procedure.


  Hope this helps the community!




Remotely Piloted Aircraft Systems (RPAS), commonly known as drones, are becoming widely used as an aerial data capture platform in engineering surveying and infrastructure incidents handling. Semi-autonomous RPAS performing a mission of assets inventory, damage assessment or threats detection without the involvement of human resources would be an invaluable tool.  With further automatic analysis of real-time sensor data with added dimension of location against customer-specific domain system data (assets and infrastructure management, GIS, etc.), organizations may gain completely new level of knowledge and decision-making capabilities. It may sound like sci-fi, but in fact it is real business concept.


An idea for a Data Science Team presentation


A few weeks before SAP Forum Poland in Sopot, we were asked to turn our experience into a nice presentation.  We decided to raise the challenge a bit higher and not only prepare additional real-time live demo but also give an access by QR code to the app to all interested participants at the same time.


The demo scenario seems simple: collect & transfer via GSM live sensors data from an RPAS during its mission over the Baltic Sea and conduct real-time analysis with SAP HANA platform. As you can imagine, the idea was quite risky – we had to take into account, inter alia, the weather (wind and rain), possibility of a failure of a drone, GSM internet connection, video-streaming over optical fiber, HANA Appliance and custom application with HERE client, network throughput, but also… BALTOPS 2015 – the biggest NATO Allies naval exercise since Cold War.


The crew


Special missions always require a special crew. It was no different this time. We wouldn’t have succeeded without the great support of our colleagues from HP who have delivered the requested HANA Appliance and Novelty RPAS who provided a world class unmanned multirotor system “Ogar”. Thank you!


The app


To keep the presentation on the track of this year’s SAP Forum Poland motto - “Discover simple”, I’ve decided (solely responsible for custom development) to simplify the solution architecture where applicable and reasonable.


The backbone of the application was data model defined within CDS/HDBDD artifact and exposed via REST/oData service, which was also being used by drones to push data. The raw sensor data coming at regular intervals via HTTP POST request were enriched within custom insert procedure with sequence ID, drone ID (based on basic authentication header) and native ST_POINT geospatial type. Final collections of table entities and parameterized calculation views were exposed for public consumption (anonymous connection via restricted user with granted hdbrole).




From the participants’ front-end perspective, custom User Interface based on Nokia HERE v3 client was prepared. Its main task was to track flying objects and display simple server-side calculations results acquired through regular async calls to REST service collections.




XS, with all its pros and cons, was a good choice to demonstrate the simplicity since the final project (maintained as design-time objects in HANA repository) contained only of a few hundred lines of source code, graphical models and native artifacts.


The show


Despite the fact, that the technical crew encountered a problem with the optical fiber just a minute before the start and seagulls didn’t like the new flying friend to such an extent that they were trying to knock it down, we can probably consider the show a success, that can be measured by regular access to the demo app up to 3am during the celebration night.




If you have any questions, please feel free to leave your comment below – I’ll be glad to answer it.

Yesterday I had some fun with a Hortonworks Sandbox environment. For those of you who do not know what that is, it’s a Hadoop system fully running on a virtual image. I thought it would be nice to run some Lumira analysis on it:




You can find the results of my Saturday night session here.


Getting this to work is fairly simple. Just follow this tutorial and you should be up and running in no time. Note that if you want to run Hortonworks on you Mac via Parallels, you need a conversion tool first called: OVF tool.


Connecting to Lumira is fun, but I decided to take it one step further and connect the virtual environment via smart data access (SDA) to HANA One.

There is a great tutorial on connecting an Amazon AWS image to HANA, but with a little tweaking it also works on the virtual sandbox. I wanted to give you some of my notes in case you want to try yourself!


  1. First off, follow the tutorial starting at paragraph 6.3
  2. Note that the wget mentioned will not get your anywhere. Use Winscp and go into your HANA box (via the Suse OS) and copy over the driver manually. You can find the updated Suse 11 driver here. As your tar file has a different name, be sure to update your linux commands to execute the correct instruction
  3. You can create the mentioned “.hortonworks.hiveodbc.ini” file on the mentioned location, but… there are actually two places where that needs to be done. You will find a second copy at “/usr/lib/hive/lib/native/Linux-amd64-64”. Be sure to update that one aswell!
  4. The “.odbc.ini” file needs to be updated with the IP addresses of your virtual machine. The way I did it is as follows:
    • Open up port 10000 on my router
    • Forwarded the port in parallels
    • Created a DNS via No-IP. By doing that, whenever my external IP changes, it will automatically update via the DNS
    • Open port 10000 on Amazon for your HANA instance
  5. Paste the mentioned Linux commands from the manual (e.g. Export…) in notepad first and stop just before stopping the HANA database (command su – hdbadm to switch the DB user). If you don’t use notepad, the commands will get garbled up!
  6. isql did not work for me after doing the install. Here is what I did to get it working:
    • Install UnixODB via zypper:  zypper in unixODBC
    • As an alternative you could install the package manually. As an extra bonus I actually had to install also a compiler as that was not installed yet… : zypper in gcc
  7. All that is remaining then is to create the SDA connection in HANA via the following command and you’re good to go!






Right mouse click on your remote table and select “add as virtual table”:




Et voila, you have a working sandbox connection to HANA!


Thank you for reading,




Filter Blog

By author:
By date:
By tag: