Wednesday 31 July 2019

Develop a Spring Boot (Java) application with HANA database on SAP Cloud Platform (Cloud Foundry) – PART 1

In this blog series, we will develop a Spring Boot application and deploy it on SAP Cloud Platform (Cloud Foundry). For persistence, we will make use of SAP HANA service on SCP. The goal of this project is to show how we can make use of HANA database in Cloud foundry. The application itself is very simple – REST endpoints supporting CRUD operations on Employee entity.

Monday 29 July 2019

HANA Backup Recovery Strategy On AWS

Purpose


The purpose of this blog is to highlight backup solution that can be designed for HANA database on AWS without any overhead of using third-party tool. The idea of specifically mentioning AWS is because I’m using AWS Simple Service Storage (S3) for this solution, otherwise you can incorporate this approach in any other cloud provider (Azure, GCP) or even on-premise.

Friday 26 July 2019

Upgrading HANA XSA & WebIDE + SSL Configuration

Backup

First backup all your existing XSA projects to Git and/or export the mta archives.

Obtaining the Software

It’s easy to forget exactly what’s been installed, so I have captured here the pieces I needed.

Thursday 25 July 2019

How to deal with Value Unconverted in SAP Tables for CDS Views, Calculation Views or BW Enhancement

This Blog Post Provide Information on difference between Value and Unconverted Values in SAP Tables. In some table when we check in SE11 or SE16 we can only see Unconverted Values for fields, but when check in SE16N  we can see its actual char value. In this blog post we will deal with scenario where we need to use these values in our modelling scenarios how can we overcome the problem on whether which values to consider.

Wednesday 24 July 2019

Increase HANA data capacity with – SAP HANA Native Storage Extension(NSE).

Introduction:


SAP HANA Native Storage Extension(NSE) is a general-purpose, HANA built-in warm data storage solution. This solution is available on HANA 2.0 SP04. As we all know that now a day’s value of data is enormous from an organization standpoint of view and Hence data storage solution and Access mechanism of data matter a lot. Data is broadly categorized into 3 different temperature tiers – Hot, Warm and Cold. Frozen is also there, normally it is not considered in HANA data tiering options(DTO).

Monday 22 July 2019

xsjs – Job Notification Via Email with Attachment

One of the requirement that we often come across is Jobs Execution Notification in SAP HANA via email .I also want to address the issue of email attachment (We often come across requirements asking to automate the results notification via email as an attachment) – So I thought we can address both the issues today

Friday 19 July 2019

End to End Model of Data Analysis & Prediction using Python on SAP HANA data

This blog post helps to connect with SAP HANA DB (Version 1.0 SPS12) then extract the data from HANA table/View and analyze the data using Python Pandas library. Then you can clean and select independent variables/features data to feed the Machine learning algorithms to predict dependent variables or find insights.

Wednesday 17 July 2019

SAP S/4 HANA Manufacturing Cycle (MTS / MTO) in Fiori Apps

After the Release of HANA from 1509 the Usage of Fiori Application is becoming mandatory day by day and with every New Release of HANA it’s becoming more and more

So many of Us are not aware of how to Use those Fiori Apps in our Manufacturing Cycles like MTS / MTO.

For each and every Transaction is having a Significant App in Fiori.

Let’s Get into the process and explore some of the important Apps to use in our day to day projects.

Tuesday 16 July 2019

Just another dummy data generator for SAP HANA

The most of the times we don’t have enough data, or even any access to customer real data, so we have to generate some rows. In order to do that, i just wrote a python script to generate dummy data and I want to share it with you.

In very simple terms, this python script works generating rows for a given HANA table; it takes table metadata for columns definitions (taking account data types, length, etc), and then it generates a random value according to column specification. I’m using Python and SAP Python HDBI client for SAP HANA, and I think it would work with PyHDB Python library as well.

Monday 15 July 2019

SAP HANA Smart Data Integration and Smart Data Quality Webcast Recap

Analytics is the core of running the business with deep insight for decision making. Running the business is better or rather say best, when the platform is SAP HANA. The critical fuel for analytics is right data. Data can be raw and as is or it can be enriched and improved to make it meaningful. Data Integration with Data Quality is the key to procure and make data meaningful. In this session we will be sharing level two information about SAP HANA Smart Data Integration and Smart Data Quality with additional information on Data Virtualization.

Friday 12 July 2019

SAP HANA Development from Alternative IDEs

In this blog I’d like to revisit the topic of using alternative IDEs but this time also look at how to connect to and use a HANA DB. I think we’ve perhaps created the incorrect impression that only way to perform modern development with HANA (HDI in particular) is to use XSA/Cloud Foundry and the SAP Web IDE. While there is a strong focus on making development easy in the SAP Web IDE and deploying to XSA/CF; that certainly isn’t the only way to develop on HANA.  So in this blog I’ll also dive deep into the topic of using the SAP Cloud Platform based HANA As A Service from outside the Cloud Platform tooling.

Thursday 11 July 2019

How to access an SAP HANA XSA Container schema from external applications such as NodeJS

My Licensed To Code colleague Roland Schulz and I have been working on SAP HANA XSA development for the past few years. We have been doing lots of NodeJS development on both SAP HANA XSA and also outside of HANA. We have a scenario which we are developing of a NodeJS application and needed to write data from the external NodeJS application into an SAP HANA Container schema but we could not connect to the schema from the outside.

Monday 8 July 2019

Improve the quality of your data with SAP Data Hub

Data drives the business processes we all rely upon, yet in many organizations poor quality data causes inefficiencies that could be avoided. SAP Data Hub includes various data quality operators that allow data pipelines to be created that can improve the quality of data in motion, or at rest.

Saturday 6 July 2019

Binding Node.js Application to HANA Databases

Introduction


In this blogs, I will explain about the way of accessing HANA tables from Node.js Application.
Especially, I will explain about issuing certification on SCP and implimenting conn_param in app.js

Friday 5 July 2019

Robotic Test Automation Brings Ends To Scripting

Robotic Test Automation Brings Ends To Scripting


Scripts always brings an expression that can foray fear into the hearts of the most fearless team of developers, QA experts and project managers as they try to deliver changes into an SAP system on time and under budget.

Well, possibly not so much ‘fear’ as a discouraging sense of acknowledgement.

Wednesday 3 July 2019

SAP Hana Geospatial – Making things simple

SAP Hana customers often ask about an easy way to use Hana Geospatial capabilities to address their business scenarios related to simple location problems such as determining the “distance between two locations” or if “location X is accessible from location Y in less than 10 minutes by car”, or what is “minimum distance between location Z to location A”…

Monday 1 July 2019

The power of the HANA-optimized Business Content (SAP BW/4HANA) – Example FI-AA

In this blog post I want to demonstrate you the power of the HANA-optimized Business Content and how it can help to speed up your BW/4HANA implementation.

For this, let us have a closer look together into the business content area of Fixed Asset Accounting – as an example.