Group Discounts available for 3+ students and Corporate Clients

Comparison of Replication methods in SAP Hana


Comparison of Replication methods:-

Capability                Trigger-Based                       ETC-based Replicates                   log – based Replication
Replication                           (Data services 4.0-SP2)               (Sybase Replication)
(SLT Replication)

Release                    SAP R/3 4.6C-SAP                ERP 4.6c – SAPERP 6.0                SAP ERP 6.0 (only it unicode)
coverage                  ERP 6.0 (EDHP06)
All other ABAP –based
SAP applications (Basis

Non-unicode                     Yes                                             YES                                        Unicode only

MDMP                  Partial (if table
contains only ASCLL
Characters or Languages
key included)

Transparent                      Yes                                         Yes                                                         YES

Cluster 4pool                    YES                                        Yes                                                         NO

Non – SAP          Yes(For SAP suspected)              Yes                                         Yes, but not in scope
DBS only : Informix
out of maintainable
therefore not supported
DBU and Sybase ADE
sybase ASE not yet
corued planned with
sp sole.

Capability                                           trigger                                  ETL                                                       log

Compressed values                        yes                                         yes                                           DB2 (,9.7)

Row compression DB Table      yes                                         yes                                           DB2 9.7 oly
(no support for 9.1
or 9.5)

DB support (Sour vive)                All SAP supported
DB s, ind. ASE                    All SAP supported DBS.
incl. ASE and others         DB 2 LUW/UDB
See PAM for full list         only
(no MAXD B Support)

OS support (source side)             All SAP supported
OS                                          NO                                           YES

Hotly system support                   Multiple source                Multiple source                  single source
system to multiple                                                           system to  single
SAP HANA instances                                                        SAP HANA instance
core source system
can be connected to
schema only

Transactional integrity                                Not covered yet               No                                          NO
(planned with sp

Work load balancing                     Yes                                           Yes                                         Yes
(parallelization of

Real time and /or                            Real time and                      scheduled                           Real time
scheduled replication                   scheduled cor table                                                          (by logical
level)                                                                                      work Units)

Initial load & data                           initial load initial load     initial load data                initial load + delta
replication                                         data replication for          replication (for                replication (always
relevant tables                   table based needs            incl. repository
delta information           info for all tables !)
through timestamp
column or chough
delta enabled

Transformation                               support dashboard           via data service own     Performer dash
capabilities                                                                                          management console    board(load progress
or through the inte-       and through put
gration with SAP             structure)
solution manager

Access to trouble                            yes                                           via data services
shooting future                                                                                  own management                                                                                                                                        console or through
the integration with
SAP solution





Integrating SAP in-Memory Appliance (SAP HANA) into your system landscape:

(a) SAP HANA Overview:-




(b)  SAP HANA Installations & updates :-

  • Pre packaged solution, delivered as installed and pre-configured system to the customer site
  • Built – in Tools for life cycle management securing optimization and operation
  • Best practices in tasks, concepts and procedures necessary for the ongoing operation

Architect &     Untitled      Installation                        Administration     Untitled        update    Untitled    Backup &
landscape                                                     Untitled      & monitoring    Untitled    & patching  Untitled recovery


(c). SAP HANA Combines software & hardware:-




In memory Computing engine (s/f)


Pre installed system (H/W).

Both are designed by Hp, IBM, Fujitsu, CISCO, DELL.



The SAP HANA appliance software from an deployment point of views:

A well defined and validate stack of HW & SW components

  • SAP HANA 1.0 SPS 02
  • SAP HANA database
  • SAP HANA database clients
  • SAP HANA stucco (p2 repository)
  • Sybase replication server
  • SAP HANA LOAD controller
  • SAP Host Agent
  • LM structure files
  • OS configuration & uses
  • SL TOOL set 1.0 SPS D2
  • Software 1.0 update manager for SAP HANA


  1. E) Scale out:-
  2. Multiple nodes utilizing shared files for workload distribution



2. Disaster Tolerance Redundant Hard wore:-




3.Faibre node:-

Cold stand by node will table over for downed nodes




  2. RAM RAM = Source data footprint * 2/5
  3. Disk Disk persistence = 4* RAM

Disk log = 1* RAM

  1. CUP 0.2 CUP cores / active user


  1. Memory sizing : static data

Memory requirements for static data is derived from the database foot print of the corresponding tables of the source database system

Data base foot print in source system must be determined using  database specific catalog information

(Eg: in Order : dba _segments: in DB2 : syscat tables)

Database specific scripts and more details on how to determine the database footprint can be found in not 1609322

Average compressing factor database table size:

SAP HANA memory = 5:1

Note that this compressed factor refers  to uncompressed database tables, and space for database indexes is to excluded.



  1. Memory sizing: runtime objects:-

Additional memory required for objects that are created dynamically

  • When loading new data
  • When exciting queries

We recommend to reserve as much memory for dynamic objects as for static objects:



So the total RAM is


  1. 3. DISK SIZING:-




4, ’cuP’ sizing:-

Sizing approach similar t user based CUP sizing of BW & BWA

Maximize query through  by multi user scenarios with queries of differen delivered content, 10-20M records


“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at, we will update the article in 24 hours.”

0 Responses on Comparison of Replication methods in SAP Hana"

Leave a Message

Your email address will not be published. Required fields are marked *


Please Enter Your Details and Query.
Three + 6