SAP HANA Trigger-Based Replication



The Trigger-Based Replication method uses the SAP Landscape Transformation (SLT) component to pass data from the source system to the SAP In-Memory Database (IMDB) target system.
Initial Load and Simultaneous Delta Replication
The initial load of business data is initiated using the SAP In-Memory Computing Studio. The initial load
message is sent from the SAP HANA system to the SLT system (based on SAP NetWeaver 7.02 with
kernel 7.20) which in turn passes the initialization message to the ERP system. The ERP system begins
by setting up database transaction log tables for each table to be replicated. After the transaction tables
are completed, the SLT system begins a multi-threaded replication of data to the target system which
allows high speed of data transfer to be achieved.
The initial load of data can be executed whilst the source system is active.
The system load that this process causes can be controlled by adjusting the number of worker threads performing the initial replication.

In parallel to the initial load, by means of database-specific triggers, the SLT system begins detecting
any data changes that occur while the initial load process is running. These changes are logged to the
transaction tables, and are propagated to the target SAP HANA system. The multi-version concurrency
control (MVCC) of the IMDB prevents issues that could be caused by the initial load process and new
database transactions overlapping.

Continuous Delta Replication After Initial Load

 After the initial load process has completed the SLT system continues to monitor the transaction tables
in the ERP system and replicates data changes in the source system to the SAP HANA system in near
real time.

Required Software Components
This replication method requires the following component:
• SAP Landscape Transformation: Component that controls the entire replication process by triggering
the initial load and coordinating the delta replication.

Installation considerations
The SLT system can be installed in two ways. You can select between these options depending on
your current system landscape and the software versions in your landscape:
• Installation on your ERP system
• Installation on a standalone SAP system

Read  also:

SAP HANA REPLICATION DATA

SAP HANA ETL-Based Replication

SAP HANA Log-Based Replication

Comments

Post a Comment

Popular posts from this blog

SAP Dashboard Error - Cannot find the BusinessObjects Enterprise report source. (LO 26608)

<!-- Google tag (gtag.js) --> <script async src="https://www.googletagmanager.com/gtag/js?id=G-NL0CYP13VZ"></script> <script>   window.dataLayer = window.dataLayer || [];   function gtag(){dataLayer.push(arguments);}   gtag('js', new Date());   gtag('config', 'G-NL0CYP13VZ'); </script> Cannot find the BusinessObjects Enterprise report source. (LO 26608) Environment SAP BO XI 4.1 SP 5 two nodes Cluster Windows Server 2012 While refreshing dashboard (based on Live Office connection) from BI Launchpad with a no administrator user the above exception was erased. SAP says: Cause The document is not available; for example it does not exist, or it has been removed. Action Check the report path from CMS and use SetLocation in Live Office to re-define the report source. Otherwise, check if the user has sufficient rights to view the object. Solution In our case  we fixed this problem was to remo
Read more

SAP HANA Introduction

Image
SAP HANA:The future of database technology The capacity of main memory in servers has continuously increased over the years, whereas prices have dramatically dropped. Today, a single enterprise class server can hold several  terabytes of main memory. At the same time, prices for server main memory dramatically  dropped over the last few decades. This increase in capacity and reduction in cost makes it a  viable approach to keep huge amounts of business data in memory. This section discusses  the benefits and challenges. In few words you can understand SAP HANA plus  analyzing this evaluation: Typical access speeds Disk     4,000,000 ns Memory         0.4 ns Speed   10,000,000 Falling prices move processing from Disk/SSD to In-Memory In-Memory Computing The elements of In-Memory computing are not new. However, dramatically improved hardware economics and  technology innovations in software has now made it possible for SAP to deliver on its vision of the
Read more

SAP BusinessObjects 4.0 - Suite Presentation

Image
The latest Business Objects Suite, B.O. 4.0,  is suitable for every kind of user from top managers to simple clerk. It has a new  styling and unified look and feel in every tool of the suite. It garantees common query design experience across all data sources. It allows interactivity with shared charting, alerting, and search options. B.O. 4.0  has a new information design tool for heterogeneous access over all sources that represents  abstraction layer for multi-dimensional data sources. Beside it allows: A simplified, Right-Scale Deployment Enhanced scalability with virtualization and native 64-bit support Comprehensive system diagnosis and monitoring New auditing for compliance and usage analysis. New User Experience SAP BusinessObjects Mobile BI  Interactive Reports & Dashboards Allows to: Make informed decisions with instant access to personalized information Leverage existing BI investments & skills to quickly reach mobile users E
Read more