SAP HANA Smart Data Access: Modeling Recommendations

SAP HANA Smart Data Access: Modeling Recommendations

Hadoop and HANA Integration

HANA Hadoop:

Lets start with advantages of using Hadoop:

It can easily handle huge amount of data volumes
It is very good for storing Unstructured data
It is reliable, scalable and fault tolerant
It is Open source so is less costly
It provides Batch Processing

Now Lets look at some of the limitations of Hadoop:

It is not efficient to use for small anmount of data
It is less mature
It is difficult to find qualified Talent
It is not suited for real time scenarios

[SAP HANA Academy] Discover How to Connect SAP HANA to Facebook with the Apache Camel Facebook Adapter

In a trio of tutorial videos the SAP HANA Academy's Tahir Hussain "Bob" Babar details how to setup and use the Camel Facebook Adapter. The Camel Facebook Adapter is used to connect SAP HANA to Facebook. These videos are part of the SAP HANA Academy's What's New in SAP HANA SPS 11 series, with a specific focus on the new features of Smart Data Integration.

How to Setup the Data Provisioning Agent

The first video in the series shows how to setup the Data Provisioning Agent. Follow along with the video below.

SAP Hana EIM (SDI/SDQ) setup

In my documentation I’ll explain how to setup and configure SAP Hana SP10 EIM (SDI/SDQ) with Sybase IQ database and ERP on Hana database schema source system to replicated data for realtime data replication.

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

In order execution

• Create Sybase IQ database
• Enable DP server for SDI
• Enable Script server for SDQ
• Install SDQ cleanse and geocode directory
• Install DU HANA_IM_DP (Data provisioning)
• Install and Register Data Provisioning Agent
• Create remote source
• Data replication and monitoring

Configuration required on SP9
The xsengine needs to be turn to true (if not done)
The statistic server needs to be turn to true (if not done)
The DU HANA_IM_ESS needs to be imported