How to connect your CAP application to SAC – Creating HANA Calculation View

CAP applications in either NodeJS or Java are a powerful tool for rapid development in the cloud. With simplified syntax, it is reasonably simple to create a beautiful and powerful application.

Usually a CAP application has the following structure

◉ /db

◉ /srv

◉ .hdiconfig

SAP on Azure: What are the Options?

In this article I review SAP solutions offered on Azure, main approaches for migrating SAP workloads to the cloud, and key considerations when planning your migration.

SAP Solutions on Azure

SAP HANA on Azure

This service lets you run large workloads of SAP HANA on Azure. You can use SAP HANA on Azure to handle transactions and analytics in-memory on a single data copy. 

SAP HANA on Azure offers on-demand virtual machines (VMs) that are certified for SAP HANA, Azure spot pricing, purpose-built SAP HANA instances and more. Organizations use this service to accelerate business processes, simplify information technology (IT) environments, and gain business intelligence (BI).

Principal propagation setup with SAP S/4HANA on-premise system and SAP Cloud Platform

Principal propagation gives the ability to forward the user context of the message unchanged from the sender to the receiver.

In this blog post, lets discuss on how to implement SSO with principal propagation in a way that it trusts the requests coming via the cloud connector configured.

There are two levels of trust that needs to be configured. First, the Cloud Connector needs to identify itself with the system certificates for the HTTPS. Second, we need to allow this identity to propagate accordingly, so that a short lived X.509 certificate could be forwarded.

Finally, we map the user in the target system – the SAP S/4HANA on-premise system, in this case.

Set up real-time replication tasks with the SAP Web IDE and SAP Smart Data Integration

The SAP Web IDE provides so-called replication tasks to set up real-time replication. It provides a graphical UI to browse tables in your connected source systems, create virtual tables, create subscriptions for real-time replication, create data load partitioning strategies, and more. The replication tasks in Web IDE are part of the SAP Smart Data Integration (SDI) toolset, which comes integrated with the SAP HANA platform, both on-premise and in the cloud.

Create your trial SAP HANA cloud instance in sap cloud foundry

SAP HANA Cloud Instance setup

To get started with SAP HANA Cloud, you need to create your trial instance. Because you are using a trial account, you will only be able to create one instance with a predefined size, which you see now on the screen. However, the process to create the instance is very similar to what you will see later if you choose to have a production instance of SAP HANA Cloud.

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

Overview

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.

SAP HANA Enterprise Cloud Vs SAP Cloud Platform Vs SAP HANA Cloud

In this blog post, I am trying to bring 3 different concepts with SAP cloud offering and demonstrate how these are different from other. First, we will discuss about SAP HANA Enterprise cloud and then narrow down to discuss about SAP HANA Cloud platform to understand about cloud foundry environment and then we will further narrow down to understand SAP HANA Cloud database features and new innovations.

Import large flat files into SAP HANA using Python and SQLAlchemy

Introduction

SAP HANA provides and supports various capabilities for data integration and data provisioning to realize lots of different integration scenarios. However, there are also certain scenarios in which you just want to load data from local flat files once, without putting effort in setting up a proper data integration landscape.

As part of my daily work with SAP HANA, this requirement usually pops up when working on demos, proof of concepts or performance/load tests. In such cases, I sometimes receive large flat files with the data I need to load into SAP HANA.

CAP: Demystify User Authentication

Before the release of the CAP Model, I have been working on the XSJS framework both in XSA and Cloud Foundry environments. And because of that, I’ve gotten familiar with how the framework handles user authentication. Now, with the CAP Model taking over, I have to start over again and figure out how does the CDS framework handles the user authentication.

In this blog post, I will share my journey in understanding how CAP handles user authentication and what it does behind the scenes. I will show how to set up user authentication for a CAP-based service. Subsequently, I will deep dive into the inner workings of the CDS framework and unearth how user information is handled.

Tips: VS Code Extensions

In this blog post, I am sharing the top 10 extensions that I personally use on my Node.js development, as well as when developing in Cloud Application Programming (CAP) Model. I hope you would find it useful too in your backend development work.

CAP: Consume External Service – Part 2

In my previous blog post Consume External Service – Part 1, I have tested the application using mock and real data. Just by configuring the NorthWind OData service URL in the credentials.url property, I was able to connect to the external service. This approach is only applicable for local development testing. If you try to deploy this into SCP Cloud Foundry, you will encounter an error stating that this approach is not valid for production use.

The reason behind this is that external service consumption in this CDS framework is meant to use the Destination Service in Cloud Foundry. And this is the topic of this blog — deploying the Node.js project into SCP Cloud Foundry using Destination Service.

CAP: Consume External Service – Part 1

Prerequisites

- SAP Business Application Studio / Visual Studio Code
- SAP Cloud Platform Account – Cloud Foundry Environment

SAP Intelligent Robotic Process Automation & SAP Conversational AI – Part 2

Introduction:

I have used SAP Intelligent Robotic process automation to create a record which automates a SAP UI5 Application. This is same app which was built in the previous step using SAP Cloud Application Programming Model. This app is running on LOCALHOST on my desktop and wanted to see SAP Intelligent Robotic Process Automation bot in action which will help to automate the tasks.

Index for Development Details:

Introduction, Prototype briefing, Details of Technical Implementation of SAP Intelligent Robotic Process Automation, SAP HANA Graph on ABAP Platform for SAP S/4HANA 1909 and SAP Conversational AI are mentioned in the following Blog Posts.

Transform into an Insight-Driven Business using SAP Data Warehouse Cloud – Part 2

In the previous blog post, I had covered the concepts around connecting to remote HANA systems and modeling the views so that they are ready to be consumed by analytical tools. In this blog post, I will show how you can use the embedded SAC as well as 3rd party tools to connect to the modeled views.

Business Catalog:

The Data builder, provides the technical layer in DWC where we can create tables and model the views. The Business Catalog gives access to the business layer of DWC. This is where business users will be able to browse through existing business entities, view how they are all connected and also understand the business purpose and metadata which would help them build their reports.

Consume Qualtrics survey results in SAP Analytics Cloud with live connection to SAP HANA service

More than ever businesses around the world are recognizing the importance of treating their customers and employees like ‘real’ people and not “users”, “buyers” , “resources”et al. Welcome to the experience economy! It is time everyone understands the importance of experience management and the powerful outcome and business value generated through the insights obtained by combining X-data and O-data.

SAP offers some powerful solutions to enable such an experience economy. SAP Business Technology Platform at the core and center helps businesses in by connecting X-data from Qualtrics and O-data from various SAP Line of Business services together. SAP Analytics cloud is the go-to analytical solution offering on the platform, that can be leveraged for data-driven insights connecting O-Data from  Line of Businesses to X-Data from Qualtrics, enabling decisions that create “people experiences”

Creating Reports via Calculation Views Using Cube – Star Joins

Introduction:

In this blog post, we will discuss on how to create reports via calculation views using cube – Star joins.

OUTPUT:

Overview of SAP HANA 2.0

In this blog post I want to elaborate and giving you an overview of SAP HANA 2.0.

Overview

Need for Digital Platform

The world is becoming the digital world, the world is now more connected and digital due to the extreme growth of mobile and tablets devices results the huge increase of data volume in every seconds and now the addition of “Intelligent” is much needed like never before. The “Intelligent” is that how we can get reward from any raw data smoothly. In today’s world the users needs instant response for their queries no matter how far the responsible person is. Data science is also available to businesses and every economic sector, this means machine learning and AI (Artificial Intelligence) is now displaying in every application due to this rapid and fruitful responses creating in every moment. New types of data is also available because of this the analysis on huge data has its high.

4 Best Practices for Securing Your SAP HANA Database

Databases hold the proverbial keys to modern business processes. These systems contain vast amounts of highly valuable and often sensitive data. This makes database systems a prime target for attackers. Comprehensive security processes and configurations are vital to prevent possible attacks.

AppToAppSSO between SAP Cloud Platform and SAP HANA DB

Introduction

HTML5 or Java based application deployed in SAP Cloud Platform fetch data from backend source, display it in application. There are different methods to establish connection between two applications in SCP. One such method is using destination which is a service offered by SAP Cloud platform.

Using Destination in SCP you can connect Application hosted on SCP with other application or DB using HTTP, LDA, MAIL & RFC.

Monitoring HANA Service: Custom Email Alerting

Background

There are several options to monitor the SAP Cloud Platform HANA Service.