Saturday, 22 July 2017

Get your SSH keys to HANA Express instance in Google Cloud Platform

You’ve been watching this SAP CodeTalk or following this tutorial on how to setup your SAP HANA, express edition, (or HXE) with the Google Cloud Launcher. Now you would like to connect to the instance from some SSH client, such as PuTTY or the console on your Mac or Linux computer.

You need the SSH keys, but where are they? If this is your first project and you have not generated your keys before, chances are that you won’t find them in your .ssh folder as this tutorial indicates:

Friday, 21 July 2017

SAP HANA – Detailed Memory Analysis Walkthrough


In this exercise, I’ll give a walkthrough on how to perform a top down investigation on high & peak HANA memory usage and its associate top memory consumers with the aid of HANA SQL scripts attached to SAP Note 1969700 – SQL Statement Collection for SAP HANA and Statistics data (History / Current) collected by ESS / SSS (Mandatory. Recommended retention = 49 days)

I’m taking below example where I was asked to perform a memory analysis on a productive system where there was a spike of peak memory usage, around 5.9TB.

A practical example of ABAP on HANA optimization

A practical example of HANA optimization

In this blog, I’ll try to recap my journey through the land of SELECT’s and internal tables towards the realm of HANA. I wanted to take a slow-performing ABAP, not something from a tutorial or playground module from SAP, but something “real”, tangible, a proper “pain point”, and describe how it can be converted to using HANA view(s).

Thursday, 20 July 2017

Bridging two worlds : Integration of SAP and Hadoop Ecosystems

Proliferation of web applications, social media and internet-of-things coupled with large-scale digitalization of business processes has lead to an explosive growth in generation of raw data. Enterprises across the industries are starting to recognize every form of data as a strategic asset and increasingly leveraging it for complex data driven business decisions. Big Data solutions are being used to realize enterprise ‘data lakes’, storing processed or raw data from all available sources and powering a variety of applications/use-cases.

Wednesday, 19 July 2017

Dedicated SAP HANA XS Advanced Runtime host installation through resident hdblcm on HANA 2 SPS 01

In this blog I will cover installation of XS Advanced Runtime on a dedicated host on HANA 2 SPS 01. Even though my example covers HANA 2 SPS 01, the process is similar on HANA 1 SPS 11+.

  1. The SAP HANA system has been installed with its server software on a shared file system (export options rw, no_root_squash).
  2. The host has access to the installation directories <sapmnt> and <sapmnt>/<SID>.

Monday, 17 July 2017

HANA MDC cross-database access

In a multi tenant database setup for HANA, the tenants are isolated from each other and can not see the content in other tenants by default. But there can be need to access some data from the other tenant. This can be accomplished using a cross-database access functionality that is provided by HANA.

The first thing to know about cross-database access is that it only allows SELECT access to data from the source database.

Saturday, 15 July 2017

Creating CDS/EDM views from RAW HANA SQL TABLES

If you need to create a CDS/EDM views from raw SQL HANA is a script. There seems to be no automatic utility in HANA studio.

The below assumes you know SQL and how to create a CDS/EDM view.

A definition of a SQL table, which need to be converted.