Home / SAP HANA, platform edition

SAP HANA, platform edition

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 …

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 …

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 …

Read More »

XSA Python Buildpack and MTA Example

While the HANA documentation gives some guidance as to how to create your own buildpacks to support custom run-time environments, to date there hasn’t been a stand-alone example that illustrates the concept in action.  This post intends to fill the gap for developers wishing to use the python programming language …

Read More »

Simplified In-Database Machine Learning with SAP HANA

SAP HANA 2.0 SPS02 introduces new predictive and machine learning procedures SAP HANA provides native in-memory capabilities for predictive analytics and machine learning executing at unprecedented speeds directly inside the database. In combination with other advanced processing capabilities like spatial, text or graph analysis SAP HANA inherently enables multi-modal analysis …

Read More »

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 …

Read More »

XSA Python Buildpack Generator

This generator script and accompanying example now have a permanent home. See this blog post for a discussion and details. https://blogs.sap.com/2017/08/03/xsa-python-buildpack-and-mta-example/ While the script posted here may continue to function, it will not be maintained. The following is to provide an example of an XS Advanced Buildpack in order to …

Read More »

SAP HANA TDI Migration from M-Node to N-Node

Purpose System Privileges How to Perform a Backup Manual Backup Check Prereqs before Recovery Recovery Monitoring redistribution Related Documents Related SAP Notes/KBAs Common Questions knows issues and fixes Tips   Purpose This Document is to explain the steps on how to perform a TDI Migration of HANA Database from a HANA M …

Read More »