Smart Data Integration: Increase Initial Load Performance for Replication Tasks

This Blog Post aim is to assist you in your daily work using Smart Data Integration and the Replication Task.

In some situations i faced performance issue and i want to use this Blog as a central sweat spot for Best Practices and Lessons learned about performance issues surrounding SDI and the initial Load Replication Task.

HANA SDI | Smart Data Integration 2.0 – H2H Real-time Replication: Lessons Learned

In this blog entry I would like to convey some of the experiences we made throughout an SDI HANA to HANA (H2H) implementation project. To gather an understanding of the context, we will start off with the scenario description and solution architecture.

These are the items that will be covered throughout this blog:

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:

SDI/SDQ OData Adapter in HANA SPS12 - GET, PUT operation and REPLICATION flowgraph

It is a really simple scenario we are dealing with: Accessing a public OData URL, read from and write to the tables exposed there. HANA is running on SPS12 on premise. The purpose of this blog entry is to better illustrate the different steps analogous as they are explained in the HANA EIM Administration Guide.

In this scenario we are accessing the following public OData Service URL (ODATA V4) which allows read and write operations.

http://services.odata.org/V4/OData/(S(1t3xkksfwh00yknrwftrjhm5))/OData.svc/

[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.