SAP HANA Landscape with Business Objects

Settings at HANA system level

HANA DB creation secure uid & pword.

Creation of HANA ODBC connection

Settings at BO Environment

ROLAP connection at BO Information Design tool layer

1----------- Data Replication

2.0--------   Persistence Layer

2.1--------   HANA DB (In Memory DST)

3.0--------   View (View Schusses)

3.1--------   HANA Metadata mgmt.

4.0 -------- DDBC / TDT for BO HANA DB

5   ----------   Semantic Layer

6 ----------- Project (Domain Specification)

7 ----------   Relational conn (1-N) system/view

8 ----------   Combining one/more ROUAP Conn in BO schema.

9 ---------   Business intelligence Layer

10 -------    Business intelligence





DS in SAP HANA Landscape

Need :- To do ETL based data replication

Desired to gain proficiency on SAP HANA? Explore the blog post on SAP HANA Training to become a pro in SAP HANA.

Settings at BW 

If your BW system is less than 7.3 version then add DS as source system manually

Note:  For BI / BW system (7.3) version DS is already added as Source System.

Settings at DS Level

In DS Mgmt console, create connection using RFC details DS/R3 (or) BW system

In DS Designer Create,

  1. SAP Application Data store
  2. SAP BW Source DST (data store)

SAP Target (Data store)

  1. NON SAP ERP / DB Data store

Settings at BO CMC 

In BO CMC in application (tab) select DS and encrypted file message which is given at HANA studio

Create Replication jobs (using LCM (ube cycle manager ) for periodical replication)

Settings at HANA Studio

Add Data Services system encrypted file message

Enable replication at DS System level

Note :  We generates prefer extractors metadata to replicate from source to target



Configure the HANA Hardware whiles is provided by IBM, HP, CISCO

Select storage layer either data vol or log volumes

Based on storage layer select persistence layer either page mgrnt, logger mgrnt

Relational engine select row store, column store or object store based on our requirement




Check out the top SAP HANA Interview Questions now!

We can retrieve data about COPA module seem ECC6 through ETL tool (Data Services)




  • We can retrieve data related to COPA in ECC 6 using log based (Sybose)




We can retrieve data from NONSAP cubes using ETL (Data Services)


ERP Replication method in Three System Landscape


Trigger Based Replication



ETL Based Replication






Loading Data Into SAP HANA



If replication process is ETL based & Trigger based then data is mapped into mappage management

If it is log base replication then data is mapped into database via logger under supervision of transaction Manager

Data Modeling



In HANA Landscape implementation, we do technical modeling (DST) and views at HANA studio.

We also do business modeling using BO information deign tool (Data foundation and Business layers) with respective to reports & dashboard.

Metadata Manager stores all the views and DST.





We can create crystal reports, dashboard (XCelsius), Advanced Analysis, Explorer, Webi.

If further any modification for report we can do changes in IDT

For an Indepth knowledge on SAP HANA, click on below