Saturday 22 October 2022

SAP Data Intelligence and SAP PaPM Cloud integration

For those of you who enjoy using SAP Data Intelligence Cloud (SAP DI Cloud) for data management, integration and processing, and are wondering how it can be integrated with SAP Profitability and Performance Management Cloud (SAP PaPM Cloud). Well, you’re in luck because this blogpost will cover this topic, so just keep on reading!


A source table is created as an input for the View function. 


The source table can be created in: 

a) SAP HANA Cloud and consumed by SAP PaPM Cloud using Model Table HANA

b) SAP PaPM Cloud directly using Model Table and Environment fields

Friday 21 October 2022

Analyze SAP S/4HANA On-Premises Data using SAP Analytics Cloud Powered by SAP Data Warehouse Cloud

This simple blog post helps you get an understanding of how data from an SAP S/4HANA on-premises system can be Analysed using SAP Analytics Cloud which is connected using Data Warehouse Cloud in SAP Business Technology Platform (BTP).

This blog post covers –

◉ Connectivity of SAP S/4HANA On-premise system to SAP Data Warehouse Cloud.
◉ Creation of a View using SAP Data Warehouse Cloud Data Builder.
◉ Consume the View in SAP Analytics Cloud and create a story.

Wednesday 19 October 2022

AWS EC2 OS patching automation for SAP Landscape

For SAP Landscape hosted in cloud Infrastructure, keeping Linux patching up to date is a very key requirement to address security hardening, vulnerability assessment and for other mandatory compliance requirement on a regular basis. Applying Linux patching for a large SAP Landscape is a very time-consuming efforts, as it does require a clean stop and start of all SAP applications in the landscape during this exercise.

This document particularly describes the procedure that how OS patching can be fully automated using AWS System Manager for a SAP landscape hosted on AWS EC2 running on Redhat Linux with multiple SAP applications running on HANA DB.

Monday 17 October 2022

SAP S/4HANA Cloud Content Federation with SAP BTP Launchpad Site

In today’s world end-users are spending valuable time accessing multiple access points to gain access to their required apps and content. Even business processes are often spanned across multiple entry points and do not provide this single point of entry that users require.

With companies adopting the Two-Tier strategy, SAP is also providing various deployment options for realizing this two-tier ERP strategy. Two-Tier provides enterprises with an opportunity to standardize the end-to-end business processes across multiple tiers. By using SAP S/4HANA Cloud for their Tier 2, customers get the benefit of Software as a Service (SaaS) which can be implemented by standard template, thereby reducing the cost and ancillary IT expenses by having pre-configured solution. But this also introduces an additional entry point from an end user perspective.

A central entry point for business applications simplifies access and increases user productivity. Designing and configuring a central point of access to SAP and third-party solutions (both cloud and on-premise), in particular accessing multiple SAP S/4HANA systems from one common launchpad on SAP Business Technology Platform alleviates a lot of the pain points mentioned above for end-users

Saturday 15 October 2022

Receive Notifications from Amazon Simple Notification Service for SAP S/4HANA BTP Extension App

Nowadays many companies choose to build business process extension projects for the SAP product they use and deploy on SAP Business Technology Platform, so that they could write the custom code and integrate with other SAP managed services or SaaS (software as a service) easily and quickly. At the same time, hyperscalers (AWS, GCP, Azure, etc…) are playing an increasingly significant role today as they help companies lower the capital expenses, increase scalability and elasticity to the system, and enhance the performance of the system. Under such circumstances, it would be better for us to understand how to leverage the services provided by the hyperscaler while developing the BTP based business process extension project, so that we could be benefit from the advantages provided by both SAP Business Technology Platform and hyperscaler. 

In this blog, I will show you how to integrate Amazon Simple Notification Service (Amazon SNS) with SAP Cloud Application Programming Model (CAP), to build an SAP S/4HANA business process extension App and receive email notifications by leverage the Amazon SNS (Simple Notification Service) service. In this blog, we will focus on how to implement Amazon SNS Service within CAP (Cloud Application Programming) App to send out email notifications. 

Friday 14 October 2022

Develop a Machine Learning Application on SAP BTP – Data Science Part

In a series of blog posts, we address the topic of how to develop a Machine Learning Application on SAP BTP. The overall sequence of steps performed by the involved personas is depicted below:

SAP HANA Exam, SAP HANA Prep, SAP HANA Career, SAP HANA Certification, SAP HANA Guides, SAP HANA Tutorial and Materials, SAP HANA Learning, SAP HANA Preparation Exam

In this particular blog of the series, we focus on the data scientist’s work, i.e., understanding the business problem, performing experiments, creating appropriate machine learning models and finally generating the corresponding design time artifacts. These artifacts can then be exchanged with the application developer by pushing/pulling them to a common git repository.

Wednesday 12 October 2022

HA/DR Architecture on SAP Shared File system on Windows in Azure Cloud

Introduction: This blog explains a reference architecture of a High available SAP system in Windows in Azure Cloud  with DR solution. This is one of the recommended architectures from Microsoft & SAP in Windows in Azure cloud where we will be utilizing Windows DFS-N to support flexible SAP shared file systems.

We will be referring shared file system as below, but same architecture can also be followed in case we have any other shared file system (e.g Interfaces which we would like to have in both regions):

1. \\<ANF or AFS name >\sapmnt
2. \\<ANF or AFS name >\trans

Scenario: We can refer this in below scenario:

Monday 10 October 2022

Data migration from SAP S/4HANA Cloud and SAP HANA Smart Data Integration


This blog post is aimed to share my experiences working on data migration activities migrating data from a SAP S/4HANA Cloud system to a SP S/4HANA On-Premise system and the usage of SAP Migration Cockpit together with SAP HANA Smart Data Integration (SAP HANA SDI) helping on this purpose.

There are a few challenges on this scenario for data migration:

◉ Extract data from SAP S/4HANA Cloud
◉ Transform the data extracted (in files) to use as a source data for Migration Cockpit

Friday 7 October 2022

How to recreate a HANA Cloud service key aka password rotation


SAP HANA Cloud uses BTP services and service keys.

There might be the need to update the service-keys.


Warning: This is advanced scripting and you could harm your configurations. Please test carefully with dedicated spaces before you are applying this to production instances. This includes also development environments/spaces.

Wednesday 5 October 2022

GDAL with SAP HANA driver in OSGeo4W

I got great news from our SAP HANA multi-model engineering team: now OGR driver for SAP HANA is included in OSGeo4W too!

OSGeo4W is a binary distribution of a broad collection of open-source geospatial software for Windows environments.

Setup SAP HANA plug-in…

Now, when installing or configuring OSGeo4W on your Windows machine, search for hana and include gdal-hana package to be installed.

Monday 3 October 2022

Python hana_ml: Classification Training with APL(GradientBoostingBinaryClassifier)

I am writing this blog to show training with APL using python package hana_ml. With APL, you can automate preprocessing to some extent.


Environment is as below.

◉ Python: 3.7.14(Google Colaboratory)
◉ HANA: Cloud Edition 2022.16
◉ APL: 2209