Skip to Content

Difference between ETL and trigger based approach on hana

Hi All,

Could you please let me know, in what kind of situations we opt trigger based approach and ETL based approach and Log based approach. What are the main differences between these methods.

Regards,

Joytsna

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Aug 03, 2012 at 08:00 PM

    Hi Joytsna,

    1. Trigger based Replication:

    • Uses SAP landscape Transformation Server.
    • Near Real-time data.
    • Replication server based on capturing the database changes at high level of abstraction in ERP source.
    • Benefits for data base independent and parallelize the database changes on multiple tables.

    2. ETL based Replication:

    • Uses SAP BO Data services.
    • Data services specify and load the relevant data in defined points of time from an ERP system into SAP HANA DB
    • Reuse the Application Logic by reading the extractors or using SAP Function modules.

    Offers integration to the 3rd party tools.

    3. Log Based Replication:

    • Uses Sybase
    • Based on capturing the Table changes from low level database Log files.
    • Method is Database dependent.
    • Database changes propagated per database transaction basis, replayed on SAP HANA database i.e.consistency maintained but at the cost of not being able to run parallelization to propagate the changes.

    Depending upon the sources we go choose the replication.

    For SAP ECC sources-----Trigger Based replication using SLT

    For Non SAP Sources/3rd party----ETL based Replication.

    Thanks,

    Aravind

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 31, 2012 at 07:27 AM

    Hi,

    Log Based replication

    This is when the replication server reads the logs from the database to pick up the data movements.

    Trigger based replication

    When a change occurs in the source database a trigger is fired to track the data change.

    ETL

    This is when an ETL tool is used to move data from Source to Target. Data Services is the supported ETL tool for HANA. Typically these jobs will run at certain time intervals and you can do more complex types of transformation on your data.

    As you can see Replication vs ETL will depend on your business requirements. With replication you will have real time/ near real time data loaded into your HANA system while using ETL you will have batch data loaded.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 06, 2012 at 08:32 PM

    Jyotsna:

    When you are looking at these options. Please also review DXC (direct data xchange) option to replicate data from SAP ECC into SAP HANA. This is the most effective way to replicate data provided real-time replication is not mandatory. The DXC replication can replicate data every few minutes from ECC into HANA.

    Review my write-up on HANA SPS4 (DXC, etc..) from http://www.sendspace.com/file/p3vbls

    Hope this helps.

    Regards,

    Rama

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.