Summary about HANA Query execution and optimization - Good to know about SAP HANA

Today I am going to discuss how when a query executed in SAP HANA, How it is processed and Optimized and generated a plan and push to a engine. This concept is will help you to optimize HANA Query in latter stage.

The summary architectural diagram is given below which is provided by SAP in the below URL –

Automating SAP HANA Scale out System with Non-shared Storage

This document demonstrates the steps required to automate the installation of an SAP HANA scale out system with non-shared storage. Participating hosts have the mandatory file systems (XFS) mounted locally, such as /usr/sap, /hana/data/, and /hana/log.

For this demonstration, two nodes have been considered, but the design can be scaled up as needed. The only file system that is shared between the hosts is /hana/shared.

The generated template can be extended with other automation scripts (refer section: Extension) for provisioning the systems automatically using Terraform in AWS.

Create a XSJS application consume calculation view and sent it to Https in HANA XSA

In this section I will discuss about the create a XSJS application consume calculation view and sent it to Http response to SAPUI5 in SAP HANA XSA using WEB IDE.

Architecture:

Expose Calculation view as a service via OData in HANA XSA using Web IDE

In this blog I am going to discuss how we can  expose Calculation view as a service via OData in HANA XSA using Web IDE. Then  either you can consume it in SAPUI5 or other front end interface applications.

Before that we need to understand the architecture of HANA XSA  which is given below –

SAP HANA Cloud Document Store – Enabling JSON Document Store

Introduction

SAP HANA has well known Row and Document Stores, allowing us to store relational data in Tables and process that data using HANA’s various engines including graph and spatial

SAP HANA actually offers a third store – the JSON Document Store. With the SAP HANA Cloud Document Store (DocStore), we can store JSON Documents in Collections within HANA itself, then process that data using the same SAP HANA engines

ArcGIS on the HANA Platform – putting the pieces together

This series, we looked at how the HANA platform’s capabilities reduce technical debt and complexity by eliminating the need for ETL when integrating your SAP S/4HANA and ArcGIS Enterprise systems.

SAP HANA Cloud Document Store – HANA DocStore First Steps

Introduction

In this blog post, we’re going to walk through some of the technical details around how we interact with the SAP HANA DocStore

JSON Collections

While the Column and Row Stores use Tables to store data, the Document Store uses a JSON Collection

Consuming SAP HANA Cloud from the Kyma environment

Overview

With the December 2022 release of the SAP HANA Cloud Tools, you can now develop Kyma applications that work with HANA HDI containers and schemas. This blog post explains one essential part of what you need to do.

The overall process is as follows:

1. From the multi-environment edition of SAP HANA Cloud Central or using the btp CLI, provision a HANA database instance in a subaccount.

2. From the multi-environment edition of SAP HANA Cloud Central, use the “instance mapping” feature to map the instance into a Kyma namespace (or Cloud Foundry space), either in the same subaccount or in a different subaccount.

HANA Docker Install with NFS mounts – (Fully Automated)

With the new evolving modern methodologies around many SAP applications and database technology, i am trying to contribute with some idea that can be helpful or spark a new idea for others.

The thought is …

What if we can create HANA docker container with database filesystems mounted to the container using NFS filesystems from an external source?

This will allow us to create HANA containers instantly with existing data and no dependency on container build process, we can even use native Linux Container images directly without modifying. This will reduce the HANA container build time, keep a persistent layer for data, less image space required for the container, reuse/redeploy the container instantly, etc..

Accessing SAP HANA Cloud, data lake Files from Python

Overview:

In this blog, we will learn how to use the SAP HANA data lake REST API to Create/Write, Access/Read and list your files through a python script. The REST API reference documentation link can be found at (SAP HANA Cloud, Data Lake Files REST API), and it may be used to access the file containers of the SAP HANA data lake. The Python demonstrations that follow, however, use some of the most typical endpoints. We will learn how to use a Python http client to fire a http request and then parse a response status and get response body data. In this post on python http module, we will try attempting making connections and making http requests like GET, POST, PUT, DELETE. Let’s get started.