• USA : +1 973 910 5725
  • INDIA: +91 905 291 3388
  • info@tekslate.com
  • Login

SAP HANA ETL Based Replication

SAP HANA ETL Based Replication Overview

Extraction – Transformation – Load (ETL) based Data replication uses SAP BODS to load the relevant business data from the source system, SAP ERP, and replicate it to the target, SAP HANA database.

This method enables you to read the required business data on the level of the application layer.

You deploy this method by defaming data flows in Data Services and Scheduling the replication jobs.

Since this method used batch procession it also permits data checks, transformations, synchronizing with additional data providers, and the merging of data streams. 

Data Flow

As for any replication scenario you have to define a sense of parameters for the two systems involved.

Utilizing Data Services you have to setup data stores to define such parameters

You use the designer to setup data stores.

Data Store Setup

Setting up a data store for the source system SAP ERP, Choose SAP Applications for the type of data store and specify the address of the system.

The user name and pass word – allowing Data Services to access the system.

Additional settings depends on the type of SAP ERP objects to be read.

For the target system of the replication, the SAP HANA database, you have to set up a separate data store as done for the source system.

Interested in mastering SAP HANA Training? Enroll now for FREE demo on SAP HANA Training.

Data flow Modeling

Once Data stores are setup, Data Services can connect to the source system by RFC.

Based on the metadata imported from the ABAP Data Dictionary to Data Services, you can determine the business data to be replicated.

Data Services offers replication functions for a variety of data source types.

However, for the replication of SAP ERP data to SAP HANA database, we recommend you to use extractors.

Choose the extractors that are relevant for the replication job Data for Initial Load and Update

Both the initial Load of business data from the source system into SAP HANA database as well as updating the replication data (delta handling) is done using SAP BODS.

The Initial load can be set up modeling a simple data flow from source to target.

For the update, in most cases, the data flow is enhanced by a delta handling element, such as Map-CDC-Operation or Table_ Comparison It depends on the environment and the requested setup of the target tables which data flow design best serves your requirements.

Although we recommend you to use delta supporting extractors. You can use SAP ABAP tables.

Replication Job Scheduling

Since you can schedule the replication jobs when using data Services, this method is suitable where the source system must be protected from additional load during the main business hours.

In this way, you can shift the replication workload, for eg to the night.

AS a result, the data that is available for reporting always represents the state reached by the time when the latest replication job was stated.

Use the Management console, which corner with DS, to schedule replication jobs.

You can choose from different tools and methods for the scheduling.

You can also use the Management Console to monitor the replication process. (Model the dataflow for each extractor you have selected Indicate the Source for the dataflow, which is the extractor

For the target of the replication, choose a template table, which us then used in the SAP HANA database to store the replaced data.)

Learn more about SAP HANA Interview Questions in this blog post.

Required Software Components

This replication method requires the following main Components

SAP HANA database.

SAP Business Objects Enterprise.

Business Objects Enterprise Central Management Server,

Which is a part of SAP BD Enterprise.

SAP BODS X14.0

Trigger-based Replication

The Trigger – Based Replication method uses the SAP Landscape Transformation (LT) Replication Server Component to pass data from the source system to the SAP HANA database target system.

Continuous Delta Replication After Initial Load

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

Required Software Components

Replication method requires the following component

SAP Landscape Transformation

This controls the entire replication process by triggering the initial load and coordinating the delta replication.

For an Indepth knowledge on SAP HANA, click on below

Summary
Review Date
Reviewed Item
SAP HANA ETL Based Replication
Author Rating
5

“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 info@tekslate.com, we will update the article in 24 hours.”

1 Responses on SAP HANA ETL Based Replication"

  1. Can u let me know how SLT Plays an important role in etl tool and main taining real time

Leave a Message

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

Site Disclaimer, Copyright © 2016 - All Rights Reserved.

Support


Please leave a message and we'll get back to you soon.

I agree to be contacted via e-mail.