Monday 27 February 2023

Migrate your SAP HANA Services for BTP (on Cloud Foundry) to SAP HANA Cloud using Self-Service Migration Tool

1. Benefits of migration to SAP HANA Cloud

SAP HANA Cloud is a cloud-native database-as-a-service (DBaaS) for modern applications and analytics across all enterprise data. SAP HANA Cloud provides exciting new innovations and features that were not offered by SAP HANA Service on Cloud Foundry (CF) such as pay-per-usage billing, multi-tier storage, including a petabyte scale built-in data lake allowing you to scale computing and storage resources separately and elastically. SAP HANA Cloud also offers automated near-zero downtime upgrades, HA/DR (up to 99.99% SLA), and availability in a large variety of regions via four different cloud service providers, including Microsoft Azure, Google Cloud Platform (GCP), Amazon Web Services (AWS) and Alibaba Cloud. Last but not least, you can also achieve Total Cost Ownership (TCO) benefits, as it is cheaper to run comparable workloads on SAP HANA Cloud versus HANA Services on CF. You can always use Capacity Unit Estimator to anticipate the cost benefits you will have depending on your SAP HANA Cloud configuration. 

Friday 24 February 2023

SAP Hana Dynamic Tiering Installation and Configuration


What is Dynamic Tiering? 

SAP HANA dynamic tiering is a native big data solution for SAP HANA. Dynamic tiering adds smart, disk-based extended storage to your SAP HANA database. Dynamic tiering enhances SAP HANA with large volume, warm data management capability.  

SAP HANA dynamic tiering adds the SAP HANA dynamic tiering service (esserver) to your SAP HANA system. You use this service to create the extended store and extended tables. Extended tables behave like all other SAP HANA tables, but their data resides in the disk-based extended store.  

Wednesday 22 February 2023

SAP HANA Cloud Intelligent Enterprise vision

In many companies the business application system landscapes over time have become very large and extremely complex. This scale and complexity slows down innovation, because even a small change can have a huge impact on the whole system landscape. The impact could be business process related, so extensive testing in all affected systems is required. The change could also impact system landscape infrastructure, which might result in ordering additional hardware or upgrading the affected database or operating system. All these steps are time consuming, cost money and involve different experts in specific knowledge areas. This is the opposite of what the business expects. A move to the cloud would improve this situation in many business areas.

In this article you will learn how about SAP HANA Cloud, it’s position in the SAP Business Technology Platform (BTP) and how the SAP BTP and SAP HANA Cloud fit into the SAP Intelligent Enterprise vision.

Monday 20 February 2023

SAP Data Migration Cockpit – Nutshell


With introduction of S4 HANA, SAP has introduced us to many new tools built in the system. Today we will talk about one such tool used for data migration in S4 HANA, SAP Migration Cockpit.

I will try to cover the details which I have got over the period by working on this tool.

What’s in it for you?

The blog will explain the different pieces of migration cockpit which will give you the very good start and understanding of tool.

Friday 17 February 2023

SAP Mobile Platform 3.1 Installation, Migration and HA

SAP Mobile Platform (formerly Sybase Unwired Platform) is a mobile enterprise application platform designed to simplify the task of creating applications that connect business data to mobile devices for workflow management and back-office integration.

Scenarios: Below scenarios where SAP Mobile platform can be used

◉ No Back-end
◉ OData service in SAP Cloud platform
◉ SAP Gateway OData Service on-premise
◉ 3rd Party Back-end System on-premise

Wednesday 15 February 2023

Technical Setup guide for the Co-PIN Integration between SAP S/4HANA Cloud and SAP Cloud for projects, project collaboration service

Business Purpose and Flow

The integration allows you to integrate the SAP S/4 HANA Cloud with the application SAP Project Intelligence Network. With this integration, you connect with project owners, engineering service providers, contractors, subcontractors, and building material suppliers on a single BIM collaboration platform to eliminate waste and rework and increase productivity with the SAP Project Intelligence Network application.

◉ Cloud deployment
◉ Single repository of construction information
◉ Shared digital twin that supports open BIM standards
◉ Source of reusable operations information

Monday 13 February 2023

Native Base64 decode function in SAP HANA

Recently I had to work around some limitations in SAP Business One’s Service Layer. As a result, I had to decode some BASE64 string that was stored in our customer’s database, modify the (unencoded) string and then save it back, all from within a native SAP HANA Stored Procedure.

To my surprise, there is no native function to achieve this, at least not that I could find in my couple of hours of investigation.

So I set out to build my own function to allow for decoding Base64 strings on the database level.

I am posting this function here, so that others can save themselves a few hours if they are ever presented with the same problem.

Saturday 11 February 2023

New Robotic Process Automation for Performance and 360 Review forms


The manager, second level manager, and their coworkers’ ratings should all be taken into account when calculating the overall rating in PM form.

Customer pain point

Whenever the overall scores or final ratings are been given to employees the ratings to be considered by the manager, second level manager, Human resource head and only 20 % of total ratings to be considered from ratings provided by the peers of employee and in the ratio of 80:20 the ratings to be calculated and added to the overall scores of pm form and the ratings should not be revealed to any of the team members (including partners team).

Friday 3 February 2023

Autostop HANA database when reboot a linux system (with systemd integration)

As a technical sap consultant working for large companies we are facing several challenges concerning big SAP- and HANA-landscapes. There are a lot of automated processes for administrating of these landscapes and this leads to problems in connection with HANA databases. One of these challenges I wan’t to share in the following blog post.

Initial situation

Because of security reason there is a monthly linux patching timeframe which is during night and there is no one that can stop the HANA databases before patching and rebooting the linux servers. Currently the reboot is triggered although HANA is running, so the database has always to recover after restart because there is no ordinary shutdown of the HANA database. When analyzing the traces we always see entries like the following in the startup process after a reboot (without shutdown HANA database before):