Skip to Content

Hi All

In this blog we are going to discuss how to replicate the data which had been archived on source systems through SARA files.

In every project based on agreement we will go for archiving either it will be to keep only last 12 months data or last 24 months based on business agreement.

If we have Archive user exclusion setting on SLT system from initial phase of the project then we are good but in some cases we may have to reload tables from source systems but if the tables already archived then we can use below steps to replicate archived data directly from SARA files without loading data to source system.

Refer my below blog for archive exclusion steps:

https://blogs.sap.com/2017/09/29/hana-sltsap-landscape-transformation-archiving-settings-when-source-table-being-archived/

Steps to Replicate Archived Data to HANA Directly from SARA files.

  1. Lets Check HANA system table for which data had been archived to make sure data no record counts showing for specific periods.

Example:Below table don’t have data for 2014 because had been archived so on source system also you don’t find any records.

HANA:

Source System Records for 2014:

2. Lets go to SLT system and use SE38 to execute IUUC_CREATE_ARCHIVE_OBJECT program.

If archive Object is not correct then you don’t see options for tables which archived through this archive file name so we have to make sure to enter correct name.

Portion size leave it as it which is 8000 portion.

We can use archive date from and to in case source system archived multiple times but we are interested to retrieve data only for specific periods so please enter the dates between when archive job had been executed.

Write behavior keep it 3 so that it will use array modify for replication.

When you execute above program screen then if you archive object name is correct it will shown you below screen to select for which tables you want to replicate data from SARA file.

After table selection please use below enter button to proceed.

As soon as you press enter button it will create migration object for replication and it will display below successful screen with names.

Press enter to see next successful message

3. Go to LTRC transaction on SLT system to see weather migration object created with the name which used in step 2.

4. If you see loaded in above step for migration object then next step check HANA table record counts for same table and same period which we checked in above steps.

 

With this we are successful replication from SARA files to HANA directly without using source system.

Thanks

Jagadeesh

 

To report this post you need to login first.

2 Comments

You must be Logged on to comment or reply to a post.

  1. Chandrashekhar Mahajan

    Hi Jagadeesh,

     

    Nice blog. I have few questions on this topic.

    1. As per my understanding, Archive files are getting stored into content server so how is it being accessed from LT server?
    2. what is the file format of archive file?
    3. if archive file having data from archive object [which could be from multiple associated DB tables], how it will be parsed when it is read from HANA and replicated back to similar DB schema? is this taken care by LT system?

    Please let me know.

     

    Regards,

    Chandra

    (0) 
  2. Jagadeesh Mandepudi Post author

    Hi Sorry for the delay

    Please see my answers for your questions.

    1. As per my understanding, Archive files are getting stored into content server so how is it being accessed from LT server?

    Since we are using SAP recommended archive mechanism it will support automatically to extract data which is stored in other system like Dolphin etc.

    1. what is the file format of archive file?

    SARA files.

    1. if archive file having data from archive object [which could be from multiple associated DB tables], how it will be parsed when it is read from HANA and replicated back to similar DB schema? is this taken care by LT system?

    If you see my steps above in case of multiple tables associated with SARA file then you will get option to select table for which you wanted to replicate so SLT will take all these.

    Regards

    Jagadeesh

    (0) 

Leave a Reply