Monday 30 July 2018

Use Case to S/4HANA Smart Data Integration (SDI)

Every new technology or platform is developed as a need to address the challenges faced by older technologies, cater to the unmet needs of the consumer or to facilitate a change by making the processes easier and/or economical. Smart Data integration is no exception.

Friday 27 July 2018

Step by Step Installation Guide for SAP IDES S/4HANA 1610 Part 5

In this Part of blog we are going to install SAP S/4HANA Application server.

◈ Installation of SAP S/4HANA IDES Application Server


1. Open Terminal and use cd /HANAIDESSetup/SAP_Software_Provisioning_Manager/ command to go to SAP Software Provisioning Manager Directory (Figure 5.1)

Wednesday 25 July 2018

Step by Step Installation Guide for SAP IDES S/4HANA 1610 Part 4

In this Part of blog we are going to install SAP HANA Database

Install SAP HANA Database

1. Open Terminal

2. Go to HDB_SERVER_LINUX_X86_64 Directory using cd /HANAIDESSetup/SAP_HANA_Platform_Edition_2.0_SPS03_rev30/51053061/DATA_UNITS/HDB_SERVER_LINUX_X86_64/ command (Figure 4.1)

Monday 23 July 2018

Step by Step Installation Guide for SAP IDES S/4HANA 1610 Part 3

In this part of blog we create the partition of disks /dev/sdc and /dev/sdd, create directories for both HANA Database and HANA IDES Setup files, mounting both directories to relevant disk is also part of this blog, finally we extract and copy the setup file to the HANA IDES setup directory.

Saturday 21 July 2018

HANA Procedure performer XS JS Project

In this post I want to share the way how to call HANA Procedures via XS JS. This is not a how-to guidepost, I want to share the end functionality that we use in our work. This approach might be very convenient in integration projects when the data extraction rules can be changed during the UAT, so you won’t need to change anything in your integration solutions you just need to apply this requirements in your procedures and change will be committed on the fly.

Thursday 19 July 2018

Step by Step Installation Guide for SAP IDES S/4HANA 1610 Part 2

In this part of SAP IDES S/4HANA installation we will install SUSE Linux in the Virtual Machine which we created in the Part 1 of this blog.

◈ Install SUSE Linux Enterprise for SAP Applications in the Virtual Machine

1. Select S4HANA IDES Virtual Machine from the left panel of VMware vSphere Web Client and click the Power on the selected virtual machine icon  SAP HANA Study Materials, SAP S/4HANA, SAP IDES S/4HANA, SAP HANA Certifications (Figure 2.1)

Monday 16 July 2018

SAP WebIDE for HANA 1.0 SPS 12

SAP WebIDE for HANA 1.0 SPS 12


SAP Web IDE for SAP HANA is a browser-based IDE for the development of SAP HANA-based applications comprised of web-based or mobile UIs, business logic, and extensive SAP HANA data models.

Saturday 14 July 2018

Step by Step Installation Guide for SAP IDES S/4HANA 1610 Part 1

In this first part of SAP S/4HANA 1610 IDES installation we download all the required files for installation and create a virtual machine in VMware vCenter Server.

◈ Download all Required Files for Installation

For installation of SAP IDES S/4HANA, we have to download ISO file for installing SUSE Linux from SUSE Downloads and SAP installation files from SAP Software Downloads.

Monday 9 July 2018

Hana Hadoop Integration with Federated Access

Data Lake analytics have become real. But the challenge is to access the data quickly and provide meaningful insights. There are several techniques to access the data faster. In this blog we see how we can integrate Hana with Hadoop to get insights for larger data sets quickly.

If you have both Hana & Hadoop in your eco-system. SAP has provided an option to integrate HANA and Hadoop using Hana Spark controller. Where power of In-Memory processing can be used for real time insights and we can in parallel use Hadoop ability to process huge data sets.

Saturday 7 July 2018

Accessing Data using REST APIs with Python on XSA

My previous blogs have been focused on setting up Python on HANA XSA, connecting applications to HANA Databases, and configuring security and routing settings for applications. In this blog, I am going to delve deeper into accessing a HANA Database within a Python application and creating REST APIs to query data.

Wednesday 4 July 2018

How to Expose a HANA Table via oData

With IOT gaining traction and SAP’s HANA DB as well as applications becoming warehousing tools, we’re seeing a greater need to integrate IOT data into HANA. One method of achieving this is by allowing sensor data from IOT devices to publish or post data directly into HANA database tables. Once data is in HANA, additional data modelling can be carried out and formatted data exposed for end user consumption to front end tools such as SAP Analytics Cloud or Business Objects.

Tuesday 3 July 2018

Myth and truth about cluster & pool tables on HANA

In general nearly everyone knows that with new installations based on NW750 there are no cluster tables anymore. When you migrate to HANA one prerequisite is that all cluster and pool tables have to be declustered/depooled.

But is this really correct? In my last projects there were a lot of issues regarding cluster and pool tables. SUM and SWPM have not worked as expected and so some data was not migrated / depooled / declustered automatically in cause of bugs.