Friday, 22 September 2017

Reducing workload on HANA hosts by routing end user query

SAP HANA is known for its versatile capabilities as a database as well as a platform by providing solution for varied end user requirements.

HANA appliance has evolved from storing data in column/row store fashion towards serving as a data container for unstructured data too and helping end user to transform data set like xml and JSON to relational data structure and vice versa with at most ease.

Being a hub of solution for all the end user needs, SAP HANA also helps end user to avail the flexibility in query handling and fine tuning the performance of his/her operations performed on the database.

Thursday, 21 September 2017

SAP HANA Smart Data Integrator on SAP HANA, express edition (HXE)

High level architecture


Any data integration must procure data and output data or information. To address the procurement and output of data there are components that need to play in harmony. Primary components of SAP HANA Smart Data Integration are:

Tuesday, 19 September 2017

Bring the Power of SAP HANA to SAP (Sybase) Adaptive Server Enterprise Applications

Legacy Adaptive Server customers totally understand and appreciate the technical and economic benefits of a reporting database. Using replication server, many Adaptive Server customers are replicating to an Adaptive server reporting instance and running their reports against the reporting copy. Some are replicating into analytical engines like SAP IQ or third party databases like Netezza. But this requires rethinking and re-writing their Transact-SQL reporting applications and procedures.

General information about Data Aging

Many people heard about data aging in context of HANA. You see it on a lot of SAP slides with DLM (Data Lifecycle Management) or in BoH / S/4HANA context, books about HANA and especially in the result of the HANA ABAP sizing reports. In my opinion the naming here – “clean-up” – is a little bit  misleading. It is a bit more than just housekeeping and lot of things you have to pay attention to.

Monday, 18 September 2017

Technical details about data aging

If you successfully finished my last blog post about data aging ‘General Iinformation about data aging’ it is time for the deep dive. How SAP has implement it and how it works in detail.

As you already have read partitioning is an elementary part of data aging process to separate the current from the historical. Therefor range partitioning is used with an additional column called ‘_DATAAGING’:

SAP HANA Tutorials and Materials, SAP HANA Certifications, SAP Guides, SAP Learning

Friday, 15 September 2017

Going for the Gold with a New Data Management Platform for Digital Transformation

As an avid fan of the Olympic games, I was reminded by the 2016 Rio games of the Olympic motto “Citius, Altius, Fortius” (faster, higher, stronger). Since their inception in 1896, the goal of the modern Olympics has been to provide an international forum where the world’s elite athletes could come together and compete. That is why the founder of modern Olympics Pierre de Coubertin said that “athletes need freedom of excess. That is why we gave them this motto … a motto for people who dare to try to break records.”

Thursday, 14 September 2017

Salesforce.com adapter for SAP SDI: replication of Salesforce data into HANA tables.

1. Overview


The Advantco SFDC adapter is an adapter for SAP HANA Smart Data Integration (SDI), its purpose is to batch load or to replicate changed data in real time from Salesforce.com to the SAP HANA tables.

This blog describes in detail how to replicate Account data from Salesforce.com in HANA tables.

Wednesday, 13 September 2017

Working with the predictive analysis library in HANA 2.0 SPS02

HANA 2.0 SPS 02 is now available and there have been a number of important updates to the predictive analysis library (PAL). The focus is on ease-of-use rather than introducing a bunch of new algorithms (though there are a couple).

In this blog I’ll introduce the updates and show you where to find hands-on tutorial videos:

Tuesday, 12 September 2017

General information about Data Aging

Many people heard about data aging in context of HANA. You see it on a lot of SAP slides with DLM (Data Lifecycle Management) or in BoH / S/4HANA context, books about HANA and especially in the result of the HANA ABAP sizing reports. In my opinion the naming here – “clean-up” – is a little bit  misleading. It is a bit more than just housekeeping and lot of things you have to pay attention to.

Monday, 11 September 2017

Introducing SAP HANA Cloud Platform predictive services

Here at the SAP HANA Academy we’ve put together a series of hands-on video tutorials that show the basics of predictive services from both an admin and developer perspective.

The first video tutorial covers getting started topics such as where to find the documentation.

Tutorials 2,3 & 4 cover the one time setup process for new HCP landscapes – admin tasks.

If you just want to get a feel for how to develop with predictive services you can jump straight into tutorial #5 “First Steps”.

Saturday, 9 September 2017

Size of log backup, complete data backup in HANA

Basic information:

Backup performed for

Data

The data volume contains the data from the last completed Savepoint.

Thursday, 7 September 2017

Getting a Permanent License Key for SAP HANA Streaming Analytics

When you first install SAP HANA streaming analytics, a temporary license is automatically installed so you can run streaming analytics for 90 days. After that, you’ll need to request and install a permanent license, which you can do using HANA cockpit and the SAP Support Portal. Here’s how:

1. Log into SAP HANA cockpit and connect to your system as a user with the LICENSE ADMIN system privilege

2. From the system overview page, scroll down and click Manage system licenses. This will give you some important system info that you’ll need to request a license.

Change Master/Shadow role of cloud connector manually

High Availability configuration requires Master-Shadow cloud connector. While taking over, sometimes in exceptional situations, where both of cloud connector in High Availability configuration are shadow role/master role.  In case such bad-configuration occurs, SCP connection will be lost and Satellite systems cannot connect to SAP cloud platform (formerly known as HANA cloud Platform)

Wednesday, 6 September 2017

Calling SOAP Web Service from HANA XSJS

I am writing this blog to share my experience and code snippets for calling a SOAP Web Service from XSJS, creating a XML input (based on input parameters) and understanding the XML response to build a JSON output of your XSJS service.

Firstly, the xshttpdest file should be in the same folder, as your XSJS file (which has code calling the SOAP Web Service, in our case). It is not just the main package, but also the same folder/sub package.