SAP HANA REPLICATION DATA


SAP In-Memory reporting and analyzing of business data requires the replication of the data

from a source system to SAP In-Memory Database (IMDB). Let see an overview of the possible
replication methods that are available for SAP In-Memory Appliance (SAP HANA 1.0) and its
the application fields and the main components required for each method.




There are three methods available for performing the data replication. 

 The main components involved in all replication scenarios are:
• SAP HANA, consisting of the IMDB and SAP In-Memory Computing Studio, which is used to
administer the appliance. User interfaces, such as SAP BusinessObjects Dashboards or Web Intelligence or Visual  Intelligence.

• Source system, such as SAP ERP
• Software components supporting the data replication


The software components that support different methods of data replication are described in the following three replication scenarios.


There are three alternative methods for data replication from a source system to the IMDB.

Each method handles the required data replication differently, and consequently each method has varying strong points. It depends on your specific application field and the existing system landscape as to which of the methods best serves your needs.


• Trigger-Based Replication
The Trigger-Based Data Replication Using SAP Landscape Transformation (SLT) Replicator 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 also can parallelize database changes on multiple tables or by segmenting large table changes.
• ETL-Based Replication
The Extraction-Transformation-Load (ETL) Based Data Replication uses SAP BusinessObjects Data
Services to specify and load the relevant business data in defined periods of time from an ERP system into the IMDB. You can reuse the ERP application logic by reading extractors or utilizing SAP function modules. In addition, the ETL-based method offers options for the integration of 3rd party data providers.
• Log-Based Replication
The Transaction Log Based Data Replication Using Sybase Replication is based on capturing table changes from low level database log files. This method is database dependant.


Database changes are propagated on a per database transaction basis, which are then replayed on the IMDB. This means consistency is maintained, but at the cost of not being able to use parallelization for change propagation.

For more details read also:

SAP HANA Data Modeling and Data Replication

SAP HANA Trigger-Based Replication

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