Monday, 28 January 2019

SLT based HANA replication-FusionOps activity

This article uses as To perform SLT based replication in hana with ecc system

Login to D1H and execute LTRC T-Code

SAP HANA Tutorial and Materials, SAP HANA Guides, SAP HANA Certification, SAP HANA Study Materials

2) Choose the respective System , in which replication needs to be done. Here we are doing in first (SR1)

SAP HANA Tutorial and Materials, SAP HANA Guides, SAP HANA Certification, SAP HANA Study Materials

3) Find the table lists whose count is greater than million records. Search that list of tables first to find out which is already present.

SAP HANA Tutorial and Materials, SAP HANA Guides, SAP HANA Certification, SAP HANA Study Materials

4) Verify tables are available for replication in HANA

SAP HANA Tutorial and Materials, SAP HANA Guides, SAP HANA Certification, SAP HANA Study Materials

Only 2 tables are in HANA

Out of 6 tables-2 tables are already replicated in HANA SIDE CAR, So we need to replicate 4 tables

We need to replicate only the below 4 tables

NAST
COBRB
COBRA
S115

Come out of LTRC T-Code and then again execute LTRC T-code

Click on Data Provisioning

SAP HANA Tutorial and Materials, SAP HANA Guides, SAP HANA Certification, SAP HANA Study Materials

Click on Start Replication

SAP HANA Tutorial and Materials, SAP HANA Guides, SAP HANA Certification, SAP HANA Study Materials

Click on execute button

SAP HANA Tutorial and Materials, SAP HANA Guides, SAP HANA Certification, SAP HANA Study Materials

Click on No.Of Tables and click on Descending

We will get the list of tables in scheduled state

We could see Replication is in stopped status. We need to start the replication in order the tables to replicate.

SAP HANA Tutorial and Materials, SAP HANA Guides, SAP HANA Certification, SAP HANA Study Materials

Once the replication is started, you can see the status Replication (Initial Load)

SAP HANA Tutorial and Materials, SAP HANA Guides, SAP HANA Certification, SAP HANA Study Materials

Once the Replication is completed, you will get the Current Action as “Replication”

Now, after replication. We have to create the scenario. Here the scneraio name is Z-FUSIONOPS2.

Before , Go to SE16 and give table name as RDA_CONFIG and give here scenario name. You will get that there is no entries in the table list.

SAP HANA Tutorial and Materials, SAP HANA Guides, SAP HANA Certification, SAP HANA Study Materials

Now, you have to create the scenario. Go to SE38 and give Program Name as RDA_MAINTAIN

This program is used to upload scnerio

SAP HANA Tutorial and Materials, SAP HANA Guides, SAP HANA Certification, SAP HANA Study Materials

You have to create the XML file for those listed tables. XML files creation reference take it from local path where you have saved

Give the path where xml file is located

SAP HANA Tutorial and Materials, SAP HANA Guides, SAP HANA Certification, SAP HANA Study Materials

Click on execute button, a message will come that Scenario Z_FUSIONOPS02 was added.

SAP HANA Tutorial and Materials, SAP HANA Guides, SAP HANA Certification, SAP HANA Study Materials

Click on Maintain Database Connection

SAP HANA Tutorial and Materials, SAP HANA Guides, SAP HANA Certification, SAP HANA Study Materials

Choose the scenario name. You will see the new scenario name added in the list.

Now Database Connection –SLT_SR1

Here now the database connection for Z_FUSIONOPS02 is assigned to SR1.

Now we have to activate the scenario

SAP HANA Tutorial and Materials, SAP HANA Guides, SAP HANA Certification, SAP HANA Study Materials

Click on execute and activate the scenario

Now to RDA_CONFIG table and give the scenario name and click on number of entries

SAP HANA Tutorial and Materials, SAP HANA Guides, SAP HANA Certification, SAP HANA Study Materials

Here you will get the number of entries

Suppose 6 tables then double of that i.e 12 because we have 2 programs using the same set of tables

SAP HANA Tutorial and Materials, SAP HANA Guides, SAP HANA Certification, SAP HANA Study Materials

Click on execute and you will see the list of tables entries

1 comment:

  1. copy-pasted, from https://blogs.sap.com/2019/01/27/slt-based-hana-replication-fusionops-activity/ link.

    if you have dont have knowledge at least dont copy paste from another site.

    ReplyDelete