Partitioning Data Volumes for HANA DB performance improvement

Partitioning Data Volumes

Below is a simple question and answer format to understand the usage of data volume partitioning ,how it helps in improving over all HANA DB read and write performance and how this is different from data volume striping

1. What is data volume partitioning? How does it add performance advantage over default setup? Since when it is available?

Data volumes on the Indexserver can be partitioned so that read and write operations can run in parallel with increased data throughput. Also, the HANA startup time will benefit from this feature because the data throughput will increase massively, depending on the number and performance of the additional disks or volumes

Configuring BI Platform to open Lumira discovery HANA document created using OLAP HANA HTTPs connection

Lumira 2.0 supports HANA live connectivity via INA over HTTP/HTTPS. Know more on how to get your user have the relevant rights and roles http://www.saphanacentral.com/2017/06/step-by-step-how-to-create-local-sap.html to get this connectivity working.

Lumira 2.0 Discovery can successfully leverage your HANA OLAP connections (managed connections in BI platform). This connectivity is over HTTP protocol and we recommend that you have it configured for secure communication i.e. HTTPS.

Consuming SAP HANA Express Edition information models in Microsoft Power BI using live connection

Initially I created my account at https://powerbi.microsoft.com. I also subscribed for the Microsoft Power BI YouTube channel.

so, I decided to play around connecting Power BI with my SAP HXE instance. Generally speaking there are two ways of connecting and consuming SAP HANA information models in Power BI: Import and DirectQuery. For this post, I will be showing my SAP HANA live data connection with Power BI (DirectQuery).

New in SAP HANA, express edition: Streaming Analytics

SAP HANA smart data streaming (SDS) is HANA’s high speed real-time streaming analytics engine.  It lets you easily build and deploy streaming data models (a.k.a. projects) that process and analyze incoming messages as fast as they arrive, allowing you to react in real-time to what’s going on. Use it to generate alerts or initiate an immediate response. With the Internet of Things (IoT), common uses include analyzing incoming sensor data from smart devices – particularly when there is a need to react in real-time to a new opportunity – or in anticipation of a problem.

Google Sheets and Google Script calling SAP HANA Express

Of course, you will need to create a Google Spreadsheet. Once you are there, you need to create a Google script. It sounds complicated, but it is as easy as going into Tools -> Script editor.

Five stars to SAP HANA Express Edition on Google Cloud Platform

Ever since I installed my SAP HANA, express edition (HXE), instances on Google Cloud Platform I have been using them as my main platforms for development and different experiments. My experience has been so good that I feel it has to be shared so others do not miss on it.

What I like about Google Cloud Platform (GCP) is that it makes it extremely easy to get my SAP HANA instances up and running when and how I want them.

The web SSH client and GCloud console stand out as a star feature. Two clicks and you are logged in to the operating system, ready to cast some commands using the web interface.