Monday 26 October 2015

How to Capture Multi-valued Attributes in HANA Table?

SAP HANA is well known for its proficient Architecture along with hardware and software optimizations. With hardware optimization SAP HANA database allows the developer/user to specify whether a table is to be stored column-wise or row-wise.

As an extension to the existing features of column table in HANA, user can now define the columns in a way to make it store multi-values or Array of values.

This document helps in understanding of how to define and work with Multi-Valued Attributes/Columns.

To understand the same let us consider a simple example of storing personal details of an Employee in a single table.

Step 1 : Create a column table that helps to store Employee ID, Employee Firstname, Employee Lastname and Employee Phone details. Former 3 details in the table are considered to have Single Value for each Employee, where as Phone details can be a Multi-Valued column for each Employee. That means, each Employee can have more than one phone details. Thus to make sure the table structure suffice the need to store multiple phone details for each Employee in same column of the table, we must define 'Phone' column in the table as Multi-Valued or Array column as shown below:

CREATE COLUMN TABLE Employee (
      ID int PRIMARY KEY,
      Firstname VARCHAR(20),
      Lastname VARCHAR(20),
      Phone VARCHAR(15) ARRAY --WITHOUT DUPLICATES
)

'Without Duplicates' condition implies that storage of same phone number more than once in the array list is not allowed.

Tuesday 20 October 2015

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.

Wednesday 7 October 2015

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

Monday 5 October 2015

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