SAP HANA interview preparations Day 2

Data Provisioning

Important links

https://blogs.sap.com/2016/07/05/the-various-data-provisioning-options-for-hana/

https://www.guru99.com/data-provisioning-sap-hana.html

https://blogs.sap.com/2014/11/27/hana-sp9-data-provisioning-overview/


Major ETL Tools

BODS/  SAP Data Services

SDA

SLT

SDI

BODS

works with any source and any target, most widely used ETL tool. It focuses on Batch performance, connectivity to any source and any target also provides fairly complex transformations.

Project Use

Source: flat files of two type delimited and fixed width
Target : SAP HANA tables (columnar ) called landing layer

Transformation : mostly 1 to 1 direct mapping, cleansing like removal of trailing white spaces, leading zeros, junk characters .

Structure :

JOBS -  Workflow - Data flow - Pre-processor - Post processor


SDA

(Smart Data Access) enables use of virtual tables in HANA,  These are HANA objects that point to an external table and provides data remotely to HANA, does not store any data in HANA. It is just a pointer to a remote table.

Project Use: Get ECC reference data like province code, activity code, contract treatment code etc.

How to :

Creating virtual table
                Right click, -> new virtual table
                Browse -> select table

Creating Data sources
               Provisioning-> Remote Source -> Create new remote Source
               Provide connection details
               Run


Connection managed by separate team

SLT/SDI not used


SDI
 Smart Data Integration, SAP built all in one solution for all data provisioning needs
Any source target is only HANA
 Supports batch and real time
allows transformation

SLT SAP Landscape Transformation
 Trigger based Data replication from any source  to HANA
Real time
Source ECC
Target HANA