Restrictions for SAP HANA Connectors

Validity

For the MX_VALID_FROM user attribute, take into account that, if the valid from date for the user is earlier than the current date, the user is provisioned to the SAP HANA system with a validity from the current date. This limitation comes from the SAP HANA system, in which you cannot create a user with a validity starting in the past.

Password Provisioning

If an administrator sets a productive password in the Identity Management system, the user also has to configure it in the SAP HANA system. For more information, see the SAP HANA Platform documentation.

Privilege Grouping

Since no multiple assignments are possible in the SAP HANA system, the SAP HANA Connector in the Identity Management system does not support assignment grouping. For this reason, privileges are provisioned to the SAP HANA system separately, but not as a group.

SAP HANA SP100 SDA setup with Apache Hadoop

In my documentation I’ll explain how to setup and configure a SAP Hana SP10 SDA with Apache Hadoop. I will show in detail step and configuration point to achieve this it.

HANA revision 100 reserve a lot new features, refer to the following link for the complete list
SAP Hana SP10 what's new

In order execution

• Apahce Hadooop installation
• Setup Hana to consume Hadoop data
• Connect SAP Hana studio to Hadoop for SDA
• Manage Hadoop Cluster with Ambari

Guide used
Simba ODBC Driver for Apache Hive
HDP installation GuideHANA SDA guide

Note used
2165826 - SAP HANA Platform SPS 10 Release Note
2177918 - SAP HANA Hadoop Ambari Cockpit SP10

Link used
http://hortonworks.com/products/releases/hdp-2-0-ga/#installhttp://www.simba.com/connectors/apache-hadoop-hive-odbchttp://hortonworks.com/products/releases/hdp-2-0-ga/#install

How to Install SAP HANA SPS10 on Red Hat 6.6

In my documentation I’ll explain how to install SAP Hana SP10 on a Linux Red Hat 6.6 system in my test environment.

I will show in detail step and configuration point to achieve it.

For my setup I’ll use my own lab on Vmware Vsphere 5.1.0 and run Hana revision 101, I’ll reuse my existing environment setup in my previous documentation.

In order execution

• Download Red Hat 6.6 release
• Install the minimal RHEL
• Configure RHEL
• SAP Hana installation

SAP HANA - Complete Simplifier Solution

As the lead for SAP’s HANA business in Asia Pacific & Japan, customers constantly ask me how they can accelerate their business processes to meet the demands of a digital economy. A key challenge that resonates with all customers, across various industries, is seeking innovation and tracking results in real time. Traditional databases, unfortunately, have not allowed organizations to meet these demands successfully.

In this post, I’d like to discuss the fundamental problem with traditional databases and highlight why in-memory computing is the only viable option for organizations in a digital economy.

Absurd Complexity – The Fundamental Data Management Problem

The absurd complexity of traditional database systems, proliferated by competitors over the last 40 years, is killing innovation. This is a common problem faced by many organizations across Asia Pacific. While CIOs are aware that delivering innovation is key, the sheer complexity of traditional databases and the costs of “keeping the lights on” deplete their IT budgets and stifles innovation!

In the last month, I met numerous CIOs across Australia, India, Korea and Japan who are forced to manage outdated and complex data infrastructures on traditional database systems. Given the limitations of a traditional database system, CIOs are only able to manage a single business workload at any given time, resulting in massive data duplications and data processing latency.

I recently presented this data management problem at the SAP Forum in Seoul, South Korea. Watch this short video to understand why SAP HANA is so fundamentally different.

Connecting SAP HANA 1.0 to MS SQL Server 2012 for Data Provisioning

There are several Data Provisioning techniques available within SAP HANA. These are "Smart Data Access" (SDA) and "Smart Data Integration" (SDI). Also available is the Hadoop Integration. This Document will cover the connectivity between SAP HANA 1.0 and MS SQL Server 2012 for SDA and SDI.

In the nature of things it is quite tricky to connect a Linux based Application (In our case SAP HANA 1.0) to a Microsoft Windows based Application (In our case MS SQL Server 2012). The official Documentation guides you to the right direction. But, as so often, it tells only half the truth. This Document will show you the rest of the required Information.

1. Prequel
Please find here some Information before we start. These Information are Resources, Guides, Links, etc.

1.1 Exclusion
This Documents excludes the process of installing and configuring SAP HANA and MS SQL Server 2012. Please consult the official documentation for the correct process.

How to Configure SAP HANA RDL (River Definition Language)

1. Introduction

SAP River is a new development language and environment for developing a complete SAP HANA backend application, describing the data model, the business logic and access control within a single, coherent and integrated program specification.
Developing an application using RDL has several key benefits over traditional technologies and development models:

1. Easier and faster development and maintenance:
1. Declarative, focusing on application intent
2. Expressive language constructs
3. Flexible code specification, enabling easier separation of concerns and iterative refinement of application code.
4. Smaller bill of materials – coherency across different layers and components of the application.
2. Easily leveraging HANA’s power, while remaining agnostic to underlying technology containers (XS, SQLScript).
1. Can leverage any underlying supported runtime container, without compromising on running time optimization.
2. Application execution improves together with the underlying technology, transparently; taking advantage of new capabilities.
3. Open to legacy and extension code, in all supported containers.

To enable RDL for HANA developer in HANA, as SAP HANA administrator you have to complete below installation and configuration.

SAP HANA: Achieving Set operations using Joins

Now we can have multiple discussions. As we know that achieving with UNION is better than JOINS. But again it depends on the volumes of the data and the place at which you are applying it.

As per our experiences, we also know that if we can achieve with the help of Attribute /Analytic Views it is better than doing the same with Calculation View Graphical / SQL. In this document i have tried to achieve with Attribute views as much as possible and while doing this i came to know about the Full Outer Join option through graphical models is not possible anymore.

These are 7 questions on which Jody has discussed,

Here are our Tables:

Table 1:

Table 2: 

A Guide to Integrate GRC with SAP HANA

1. PURPOSE

The purpose of this document is to define clear steps required to implement GRC on HANA plug in to integrate GRC 10.1 with HANALIVE DB for user provisioning.

2. SCOPE

This scope applies for Basis team who support SAP GRC on HANA configuration after will go live. This procedure applied for pre requisites, installation and post installation configuration of complete SAP GRC HANA “plug in” setup.
This document does not cover security setup that required for User provisioning on HANALIVE through SAP GRC system

3. Component details

Need at least GRC 10.1 with SAP NW 7.4 system to integrate this with HANA
SAP GRC ACCESS CONTROL  11  sap.com SAP ACCESS CONTROL 10.1
SAP NETWEAVER  7.4 sap.com SAP NET WEAVER 7.4
HANACLIENT SPS 8 Rev 82 Patch level 0
HANALIVE DB SPS8 Rev 82 Patch level 0
HCO_GRC_PI SP06 Patch level 0 (GRC Plugin)

The Science and Art Behind HANA Performance Modeling

During the course of last 2 years, I’ve conducted SAP HANA performance workshops and reviewed information models at various customers. I encounter similar modeling issues or mistakes almost at all customer projects. The good news is that most of the performance problems can be resolved by making with minor changes to the model.

However it is critical to understand the reasons behind the performance problems consistently observed in the HANA implementations. Here are my observations.

1. HANA modelers have pretty good idea on how to build attribute views, analytic views, and calculation views which are part of HANA modeling. However, there is significant gap in the knowledge of using these HANA information views effectively to address the business requirements.
2. Some of the HANA modelers do not have data warehousing background and hence lack the knowledge of basic multi-dimensional analytical reporting, which leads to poor solution design.
3. Modelers and developers seems to have the knowledge of “what works and what does not work”, but they seem to lack the knowledge “Why it is behaving the way it is behaving”, hence the struggle to apply the knowledge effectively while building the models.
4. Finally there is a fundamental flaw in the understanding of Software Development Life Cycle (SDLC). Is performance testing a phase before Go-Live or is it part of unit testing? HANA’s query response is extremely fast for the smaller data set regardless of the modeling approach. This gives a false positive of efficient modeling. The realization of performance issues become visible only in Staging/QA system where models are tested against large data volumes.

Steps to follow Disaster Recovery with SAP HANA

Abstract
As devices, systems, and networks become more complex, there are simply more things that can go wrong due either to man-made or natural disasters. See the options available with SAP HANA for disaster recovery that help organizations keep business running smoothly in such circumstances.

Key Concept
SAP HANA provides a single platform to extract and analyze massive amounts of structured and unstructured data in real time from multiple sources such as social media, blogs, online reviews, emails, and discussion forums. The analyzed information helps customer to answer specific questions, increase revenue, and make accurate and timely decisions. The analyzed information and the data that is accumulated over the years is the backbone for an organization. If something happens to the data due to natural or man-made disasters, business can come to a halt. Making use of the SAP HANA disaster recovery features can save companies from such an outcome.

Learning Objectives
By reading the article you will be able to:

• Understand the concept of disaster recovery
• Understand the disaster recovery options with SAP HANA

Nowadays most every company has its business continuity plan that helps during an unfortunate event such as flood or earthquake. A disaster recovery plan is part of business continuity plan focusing mainly on the restoration of IT infrastructure and operations after a crisis.