- Replicate: This option is used to have real-time replication with historical data. All the data is loaded to HANA and logging tables will be created source for real-time replication.
Steps
- Create a Table using SE11 Transaction code.
- Enter the data.
- Now go to Transaction code LTRC.
- Here we using already created configuration.Else create configuration .
- Configuration name is ECC_TO_HANA.
- Enter the Master Transfer Id and click on Execute.
- By default we get these three tables (DD02L, DD02T and D008L).
- Click on Data Provisioning.
- Enter table name and select start replication.
- Click on Execute.
- Check the status.
- Refresh.
- Logging Table created and Trigger Status activated.
- Go to HANA studio -> open Quick view launch ->click on Data Provisioning.
- At target schema select our configuration name. Whatever you give configuration name that name is created in HANA as schema name
- Select our schema.
- Click on Refresh.
- First entire data will Load.
- Click on Refresh.
- Go to catalog -> here we filter our schema.
- Enter Schema name -> Click on ok.
- Here we see our created schema.
- Expand tables -> here we see our replicate table ZCOPA_ACTUAL .
- Click on ZCOPA_ACTUAL table -> Right click on it -> click on data preview.
- Now we see data preview of the table.
To know Replication effect.
- Enter a record in SAP ECC in ZCOPA_ACTUAL table.
- Refresh in SAP-HANA studio.
- Within fraction of milisecond data will available in SAP-HANA. Similarly try for DELETE , MODIFY record.
To do Analysis.
- Click on Analysis.
- Drag and Drop ZBUKRS to Label axis.
- Drag and Drop ZVV010 to Values axis.
- For clear view.
- Looks like,
No comments:
Post a Comment