Friday, 11 October 2024

SAP Datasphere – How-To integrate Open SQL Procedures in a Task Chain

Introduction

Within SAP Datasphere a task chain is a structured sequence of tasks or operations designed to be executed in a specific order or concurrently. It automates the process of running multiple related tasks, ensuring that they are executed in a predefined sequence or parallel, depending on the requirements. Such objects can be Remote Table Replication, View Persistency, Intelligent Lookup, Data Flow, Replication Flow and Transformation Flow runs.

SAP Datasphere now allows also the integration of SQL Procedures directly into Task Chains. To achieve this, you start creating a SQL Procedure within the underlying SAP HANA database. Once the procedure is created, it can be incorporated into your Task Chain. This guide provides a quick overview of the necessary steps and considerations for this process.

Saturday, 5 October 2024

How to execute SAP C4C/BYD OData service using certificate-based authentication in Postman

This blog describes how to execute SAP C4C/BYD OData services using client certificate when testing custom/standard OData services in the Postman.

As in the custom/standard OData service, you can use the business user and technical user basic authentication in the Postman. In addition, you can use the SSL certificate-based authentication in postman.

SCENARIO: Testing SAP C4C/BYD OData service using client certificate-based authentication in Postman.

Tuesday, 17 September 2024

Quality Gate Reporting with SAP Cloud ALM

Quality Gates are, as the name suggests, "gates" or checkpoints that are planned and carried out at a specific time. The goal is to check the status and content of a delivery object, based on quality criteria determined in advance.


For reporting, SAP is currently working on an expanded option to make "Quality Gate Reporting" even more efficient and effective. So it will be interesting to see what will follow. We have already been able to place some of our requirements and wishes for SAP.

Saturday, 14 September 2024

Exploring Data Access Control: Ensuring Consistency from SAC to Datasphere and Back - Blog 1

Introduction

Welcome to the first segment of this two-part series. In this introductory blog, I want to provide an overview of the following key aspects in relation to data access control in SAC and going from SAC to Datasphere:

  • What is Data Access Control (DAC) in SAC?
  • The different type of DACs - dimension based and role based
  • Benefits & drawbacks for both dimension based and role based controls
  • Which Type of Data Access Control Is Best for Different Situations

Saturday, 7 September 2024

Cloud ALM for Team Task Management and Planning

Today I would like to demonstrate how to manage and plan a support team's tasks with SAP Cloud ALM.

I do understand that there are applications available that is specifically designed for this, but my blog post is to try something different with Cloud ALM and see what the result will be. You might have done some reading and training of Cloud ALM. You might also have used the Cloud ALM Demo Tenant (sap.com) to experience it. What if you don't have an upcoming implementation or conversion project. How can you use Coud ALM for Implementation in a productive way in between projects?

Example Scenario:

One support team with multiple consultants and customers

Manage support tickets, daily tasks, recurring tasks, mini projects.

Tuesday, 27 August 2024

BEx Analyzer and Analysis for Office Comparison & Migration from BW to BI

Existing users who are familiar with BEx Analyzer will find the transition to Analysis relatively smooth. With a familiar MS Office UI, comprehensive feature set and overall improved design, unlocking value out of your enterprise DWH should be made even easier.

Below are the screenshots that shows the look and feel in terms  between Bex and AO and also shows to login to AO.

Initial screen once open the respective tool as below: