Friday 30 October 2020

Use SLES 15.2 To Automate SAP HANA High Availability

I will talk to you about how SLES HA Automation process and integration work with SAP HANA to facilitate the management of these systems, but also how to get the best of this marriage by leveraging enhanced native SLES tools specifically for SAP platform.

SAP HANA Exam Prep, SAP HANA Tutorial and Material, SAP HANA Certifications

Wednesday 28 October 2020

SAP Data Warehouse Cloud – Connecting local systems like SAP BW/4HANA


The Data Warehouse Cloud (DWC) comes out-of-the-box with the option of uploading your own data in the form of flat files. This is sufficient for smaller demo scenarios, but for serious use the requirement to connect data from existing systems arises very quickly.

The connection of own systems takes place via Smart Data Integration (SDI), which is an integral part of the Data Warehouse Cloud. A data provisioning agent then creates the bridge to the SDI of DWC on premise.

Since the DWC is tenant-based software-as-a-service solution, the SDI component cannot simply be installed on the DWC side or configured using the usual means. Instead, DWC also offers the option of connecting local systems “as-a-service”, which only needs to be connected to the local components accordingly.

Monday 26 October 2020

Private Connectivity to SAP HANA Enterprise Cloud via AWS Direct Connect

In this blog, we explore how dedicated private connectivity between SAP HANA Enterprise Cloud running on AWS and on-premise data center can be achieved. Presently, there are two options for customers to connect from their on-premise data center to SAP HANA Enterprise Cloud.

● Site-to-Site VPN Tunnel

● AWS Direct Connect

Challenges with Site-to-Site VPN are as follows:

From a security and compliance perspective, many government and public sector organization do not allow public internet to access critical business application over the internet. This is one of the biggest limitations and impediments to meeting regulatory compliance requirements. Besides, typically site-to-site VPN offers very limited non-guaranteed bandwidth, typically 1Gbps per tunnel. As the traffic via Internet traverse via multiple internet router hops, it is expected that there would be higher latency traversing over public network.

Friday 23 October 2020

HANA Data Privacy & Anonymization Visualized

I wanted to share a visual example that describes some of the HANA data privacy capabilities and anonymization features. There’s a YouTube video below that shows these exposed through SAP Analytics Cloud (SAC).

HANA anonymisation covers multiple features

1. Data Masking

2. Differential Privacy

3. k-Anonymity

4. i-Diversity

Wednesday 21 October 2020

Decision Table in HANA! Why, When we need and How to Create.

Decision tables are very important concepts in SAP HANA native modelling. Ideally when we are working with IBP and APO even ECC or S/4 HANA source systems in SAP HANA Native modelling then definitely one might had created and used decision tables.

Decision tables are kind of ETL rules applied on a Column. So it a table with ETL rules wrapped in ti with Conditions and Actions.

There are few information about Decision Table but we must know when we need it and if at all we need How to do it. Below blog post Cleary illustrates the creation and usage of DT in SAP HANA 2.0 SPS 04

Monday 19 October 2020

Native HANA project approach to migrate HANA 1.0 to HANA 2.0

In this blog, I am going to highlight on the approaches which will give a detail view of which option we will implement for migration of HANA DB 1.0 SPS12 version to HANA 2.0 SPS 04 or 05 in a ongoing Native HANA Project.

In one approach only DB upgrade is required and no application server upgrade is required and only limited to the basis team activity. In the other approaches along with HANA DB upgrade Application Server(XS server) need to the upgraded and developer involved in lots of activities.

Friday 16 October 2020

Data Provisioning using OracleLogreaderAdapter and CamelJDBCAdapter

What is DATA Provisioning?

DATA Provisioning is a process of creating, preparing, and enabling a network to provide data to its user. Data needs to be loaded to SAP HANA before data reaches to the user via a front-end tool.

SAP HANA Smart Data Integration

SAP HANA smart data integration loads data, in batch or real-time, into SAP HANA (on premise or in the cloud) from a variety of sources using pre-built and custom adapters.

Wednesday 14 October 2020

Agile Data Warehousing with SAP BW/4 HANA


Agile Approaches and organisations have been very present in the media for a long time and have been used in Software-Development for a long time.

We encounter the result of agile software development every day when using Amazon, Spotify, but also SAP cloud solutions such as the SAP Analytics Cloud. The short time until new features are available shape the expectations of users of other software solutions. Agile methods of software development are less widespread in the development of SAP data warehouse solutions. It is argued that in the data management area it is not possible to develop small usable product increments, and that agile development methods are therefore fundamentally out of the question. In this article I would like to explain why methods of agile software development are also useful and possible in the data warehouse. Here I concentrate on SAP BW / 4HANA and highlight which properties are important for an agile design of the data warehouse.

Monday 12 October 2020

Pitfalls at S/4HANA db tables with replacement object

1. Introduction

Due to the change of some data models, SAP uses so-called replacement objects for some db tables in S/4HANA. There are some oddities to consider, which I would like to discuss in this blog post.

Since the basis for the replacement object is a CDS-View, it seems mysteriously that a db table can also exist on the HANA database at the same time, where individual data records can be stored.

Friday 9 October 2020

HANA Fast Restart – Customer Experience

SAP HANA Fast Restart (TMPFS) is available from HANA 2.0 SPS 04. There few nice blogs which already addressing  the  Technical setup and theoretical information of this feature . This year we had implemented this feature in few customer HANA production systems who has very high restart times.

SAP HANA Fast Restart – TMPFS

◉ SAP HANA uses TMPFS Linux Concept to store column store in memory and this concept is know as SAP Fast Restart Option. So, when ever the HANA database is restarted column store tables are never unloaded and there in memory all the time until OS is restarted or any of the maintenance activity is performed on OS

Wednesday 7 October 2020

Conceptualizing Two-Tier SAP S/4HANA Cloud for Enterprise Portfolio and Project Management

Business Background and Introduction of the Concept

Our On-premise customers today face an uphill task of mapping requirements with processes across several solution offerings. Even in a specific area like project management, we see a lot of different capabilities provided in different project management solutions. Some solutions offer a great risk management framework; some offer a wonderful scheduling experience while some others offer seamless integration to downstream and third-party applications. But all these solutions try to address the same base purpose, “The need to have an integrated end-to-end business process setup for project ”, starting from ideation to project closure.

Monday 5 October 2020

Eclipse Dirigible – connect to HANA Schema on the SAP Cloud Platform Cloud Foundry environment


Eclipse Dirigible is an open-source cloud development platform that provides capabilities for end-to-end development processes from database modeling and management, through RESTful services using server-side JavaScript, to pattern-based user interface generation, role-based security, external services integration, testing, debugging, operations and monitoring.

Thursday 1 October 2020

Installing SAP HANA, express edition into WSL2 (Windows Subsystem for Linux)


In this blog post I will describe the steps I went through to experimentally install SAP HANA, express edition into WSL2 – Windows Subsystem for Linux Version 2. Before I jump into any content, though, I want to start with a disclaimer.

Although I work for SAP, what I’m describing here is not an official SAP supported approach to install or run our software.  This is the result of my personal experimentation and exploration. Use at your own risk.