Cloud Integration - How to Manage Abnormally Large Files with SFTP Adapter and SAP HANA Database

This blog provides a comprehensive guide for users seeking a solution for processing large files from an SFTP source and transferring the data to a HANA Database. The solution outlined in this guide employs SAP Integration Suite. There have always been challenges associated with processing large files, which may include issues related to performance, memory usage, and overall efficiency. All of which are solved by the solution shared in this guide.

Background Information

During a recent migration project - we were challenged with designing a solution that eliminated a previously designed integration using Informatica Platform. Replacing it with SAP BTP Cloud Integration Suite, during the migration project a crucial task emerged: retrieving large files from an external SFTP and seamlessly loading the data into a HANA Database On-Premise table.

SAP Datasphere Replication Flow from S/4HANA to Azure Data Lake

Introduction

SAP Datasphere has introduced a new feature, 'Replication Flows.' This new capability (now available with Azure Data Lake) allows for the process of copying multiple tables from one source to another, offering a fast and seamless experience in data management. 

In this blog, we’ll provide a step-by-step tutorial on replicating data from SAP S/4HANA to Azure Data Lake, showcasing the practical application and efficiency of this new feature in real-world scenarios. 

Now, let's dive in. We'll walk you through each step necessary to effectively utilize 'Replication Flows' for transferring data from SAP S/4HANA to Azure Data Lake. 

SAP Datasphere – Enable SAP HANA Development Infrastructure (HDI)

Introduction

Use SAP SQL Data Warehousing to build calculation views and other SAP HANA Cloud HDI objects directly in SAP Datasphere run-time database and then exchange data between HDI containers and SAP Datasphere spaces. SAP SQL Data Warehousing can be used to bring existing HDI objects into  SAP Datasphere environment, and to allow users familiar with the HDI tools to leverage advanced SAP HANA Cloud features.

S/4HANA federated roles assignment to users in BTP via SAP Identity Provisioning Service

In this article I will explain how these federated roles from S/4HANA assigned automatically to users in BTP via SAP Identity provision service without any manual intervention.

To achieve this scenario, we should have below prerequisite: -

1. SAP BTP cockpit, where we subscribe to the Cloud Identity Services connectivity plan in the subaccount.In SAP BTP Cockpit, open the subaccount and choose Service Marketplace Integration Suite- Cloud Identity Services and then choose for what type of tenant (test or productive) to use in the subaccount.
2. The Identity Provisioning section of SAP Cloud Identity Services administration console, where we configure the S/4Hana system and SAP IAS as provisioning system.
3. Content Federation has been setup and S/4HANA role content are federated and visible as role collection in BTP.

Integrating SAP Cloud ALM and the test automation tool for SAP S/4 HANA Cloud

In this blog post I will explain how SAP Cloud ALM integrates with the test automation tool for SAP S/4 HANA Cloud.

SAP Cloud ALM provides (among other capabilities) test management, including manual testing as well as test automation integration.

This simple picture gives an overview of the SAP Cloud ALM Test Orchestration capabilities:

BTP Destinations and SAP Build Apps to integrate SAP C4C & S/4HANA

Introduction: In today's digital world, businesses are looking for ways to streamline their processes and enhance their customer experience. One way to achieve this is through the integration of different systems. In this blog post, we will explore how to integrate SAP C4C and S/4 HANA using BTP destinations and SAP Build apps.

To integrate SAP C4C and S/4 HANA, we can use BTP (Business Technology Platform) destinations and SAP Build Apps.

Optimizing HANA Cloud: A Practical Exploration of Replication, Latency, and Availability Zones

Introduction

In general crafting my blog posts, I usually avoid lengthy theoretical discussions. I find more value in exploring real-world scenarios, practical applications, and best practices. However, for this particular post, I'll make an exception. I'd like to start by briefly delving into some theoretical concepts you may already be acquainted with

—Replica, Latency, and Availability Zones in Cloud Databases. Allow me to provide a concise overview, accompanied by practical insights and optimization strategies. Together, we'll lay the groundwork for a resilient and high-performing system in HANA Cloud

Azure APIM TO S4HANA CONNECTIVITY VIA CI (Principal Propagation)

Requirement:

Establish trusted relationship/connectivity between source systems at client side to Azure APIM and from Azure APIM to S4HANA system via CI and cloud connector using short lived certificate i.e., principal propagation.

More Info: C_HANATEC_19 Key Points

Overview

Principal propagation means the ability to forward the user context of a message unchanged from the sender to the receiver. It enables authentication of a message in the receiver system with the same user that issued the message in the corresponding sender system. Thus, the receiver application is virtually part of the sender application, and the permissions and audit functions of the receiver application can be applied to the original user of the sender application.