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:
ii) Hybrid database development
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.
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 SAP HANA database.
You can reuse the ERP application logic by reading extractors or by utilising 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.
Learn more about the different components in SAP HANA