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 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 to the SAP HANA tables.

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