SAP HANA, platform edition

SAP HANA Savepoint Mechanism – Internal stages

SAP HANA persists in-memory data by using savepoints. Each SAP HANA service has its own separate savepoints. During a savepoint operation, SAP HANA database flushes all changed data from memory to the data volumes. The data belonging to a savepoint represents a consistent state of the data on disk and remains so until the next savepoint operation has completed. Redo log entries are written to the log volumes for all …

Read More »

SAP HANA 2.0 Cockpit Installation and Configuration How to Guide

In this blog, I would like to provide a step-by-step procedure to install and configure new SAP HANA 2.0 Cockpit to monitor and maintain multiple SAP HANA databases.  SAP HANA 2.0 Cockpit is a native web based centralized HANA administrator tool used to perform all database management and monitoring of multiple SAP HANA 2.0 and SAP HANA 1.0 SPS 12 databases. HANA 2.0 Cockpit was introduced in SAP HANA 2.0 …

Read More »

Deployment of Arbitrary Java Libraries in SAP HANA XS Advanced Model

Have you ever asked yourself or even been confronted with the task of deploying already compiled Java libraries with or in an MTA application? This would be a frequent requirement, if you are to port existing Java code in an MTA application you are to develop on XSA. And this is something we encountered in a project we conducted several weeks ago. A solution provider had a solution implementing planning …

Read More »

SAP HANA Savepoint Mechanism – Internal stages

SAP HANA persists in-memory data by using savepoints. Each SAP HANA service has its own separate savepoints. During a savepoint operation, SAP HANA database flushes all changed data from memory to the data volumes. The data belonging to a savepoint represents a consistent state of the data on disk and remains so until the next savepoint operation has completed. Redo log entries are written to the log volumes for all …

Read More »

Server-side SSL configuration on HANA for inter-node communication and System Replication using openSSL

Hi Everyone, I am Ganesh Munusamy from HANA Product Support based out of Vancouver, Canada. I am part of support team for more than 3 years. I have been seeing a growing number of security related questions from customers. This blog will cover step-by-step configuration of SSL for internal communication and system replication. I hope this will help you guys out. Security is one of the most significant feature any product …

Read More »

Introducing enhancements to SAP HANA capture and replay in SAP HANA 1.0 SPS12 Revision 122.14 and SAP HANA 2.0 SPS02

SAP HANA capture and replay was first made available with the initial release of SAP HANA 1.0 SPS12. Since release, many enhancements have been added to SAP HANA 2.0 and are now also available on SAP HANA 1.0 SPS12 Revision 122.14. While it greatly simplified testing application workload, the testing of data- and system-related changes remains a challenge for many of our customers today, especially in large-scale and complex environments. …

Read More »

SAP HANA 2.0 XS Advanced: a host auto-failover installation/configuration example

Introduction While the host-auto failover configuration with the core HANA Database is well known, the additional steps when XS Advanced (XSA) is installed are less well known. In below steps I give an example how it can be configured. When you read through the notes several decisions must be made for your own implementation, so your configuration may be different. Failover & High Availability with SAP HANA extended application services, …

Read More »

Column Encryption Decryption on HANA

The last project I’m working on, we have some special requirements to secure sensitive customer data(e.g. social security number, driver license number, credit card number, etc) with encryption and decryption to protect it from data breach. It has nothing to do with recent data breach at Equifax, the client is keen to protect customer sensitive data for a long time before migrating to HANA. Since the customer data security has …

Read More »

Alexa, ask (on-Prem) HANA …

Voice Assistants such as Apple Siri, Google Home, Amazon Echo and Microsoft Cortana are coming around to be a common sight in various personal aspects. We often use them for asking about weather and news updates, looking up local businesses, getting directions, etc. It is indeed a convenient user interface for on-demand updates without having to open up an app, sign-in, navigate menus, etc. This article presents a general architecture for enterprises that …

Read More »

Search UI on HANA

To search on the data present in HANA, there are some applications already available. Recently a blog was published on Enterprise Search UI on HANA which is built using SAPUI5 and is very simple to use. Please refer to the blog on how to setup the Search UI: https://wiki.scn.sap.com/wiki/display/SAPHANA/Enterprise+search+UI+on+HANA Once the setup is done, the UI can be launched using the URL which looks some like: {http_schema}://{tomcat_host}:{tomcat_port}/resources/sap/ushell/renderers/fiori2/search/container/index.html This UI is …

Read More »