SAP HANA Purpose

A)Functional Purpose:

  • Enable end user to do ‘Near real-time’ reporting from SAP/Non-SAP ERP systems (Near real time- to get updated data subsequently)   Ex: for every minute
  • Enable process oriented BI from SAP BW/Non SAP OLAP data sources.
  • To create hybrid in-memory database using advance process.

B)Technical Purpose:

i) Replication.

ii) Hybrid database development.

iii) Modelling.

iv) Smart intelligence.

How to retrieve data from DATA providers to SAP HANA?


We can retrieve data from data providers by performing REPLICATION

There are 3 types of replication to retrieve data from data providers

A)   Trigger-based replication.

B)   ETL based replication.

C)   Log-based replication.


A)Trigger Based Replication:


Trigger-based replication using SAP Landscape Transformation replication server is based on capturing database changes at a high level of abstraction in the source ERP system, this method of replication benefits from being database independent and can also parallelize database changes on multiple tables or by segmenting large table changes.

sap hana replications-bigclasses

B)ETL Based Replication:


Extraction transformation loading based data replication uses SAP BO data services to specify and load the relevant Business data in defined periods of time from an EPR system into

You can reuse the ERP application logic by reading extractors or by utilizing SAP functional modules. In additional, the ETL based method offers for the integration of third-party data providers.


C)LOG Based Replication:


Transaction log-based replication using Sybase replication is based on capturing table changes from low-level database log files. This method is database dependent.

Database changes are propagated on a per database transaction basis, and they are replayed on SAP HANA database. This means consistency is maintained, but at the cost of parallelization is not being used to propagate changes.