Skip to Content
avatar image
Former Member

Archiving - SAP HANA Native Stand Alone

Hi Experts,

Is there any Archiving mechanism or tool available in HANA Native or HANA Stand Alone (we are not using BW on HANA and NLS is not an option for us)?

We have a HANA box with Information Models which replicates data from ECC to HANA Stand Alone using SAP and reporting is done through Analysis Office BO tool.

I have two questions -

1. What happens to data in which is archived in ECC? For example I have data from 2011 to 2014 and I move to year 2015. Now data of 2011 will get archived in ECC as we move to year 2015. But how to manage that 2011 data in HANA. Do we need to manually delete this data or SLT automatically syncs and deletes that as it gets archived in ECC?

2. We also have external source of data in HANA. We ideally want to archive 2011 data within HANA or outside HANA as this is coming from external source and in case it is deleted, it will be a permanent loss as it will not be even available in ECC archives.

Your quick reply will be appreciated.

Thanks.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Dec 30, 2014 at 05:33 AM

    Hi Shiwesh,

    The answers to your questions:

    1. What happens to data in which is archived in ECC? For example I have data from 2011 to 2014 and I move to year 2015. Now data of 2011 will get archived in ECC as we move to year 2015. But how to manage that 2011 data in HANA. Do we need to manually delete this data or SLT automatically syncs and deletes that as it gets archived in ECC?

    Answer:

    From the SLT Operations Guide, section 5.2 I can see the following statement

    5.2 Archiving Data in Source Systems

    The trigger-based replication also considers the deletion in source tables by archive activities (since it is not possible to distinguish on the database level between delete actions cause by archiving versus regular deletion of data records). As a consequence, SAP LT Replication Server will also replicate archiving activities as delete actions in the SAP HANA database.

    Hence, SLT takes care of Deleting 2011 data in HANA.

    2. We also have external source of data in HANA. We ideally want to archive 2011 data within HANA or outside HANA as this is coming from external source and in case it is deleted, it will be a permanent loss as it will not be even available in ECC archives.

    Answer: Yes, if you delete the data without taking a backup from HANA, it will be permanently deleted.

    Thanks Much,

    Abhishek

    Add comment
    10|10000 characters needed characters exceeded