Group Discounts available for 3+ students and Corporate Clients

Multiple –sheet extraction in SAP Hana

Multiple –sheet extraction

Step 1 :- format

Excel workbook :

Format Name:

 

Screenshot_62

 

Format:

Directory :

File Name:

O normal range:

O word sheet :

Range    Untitled     All toiled  ousting range

Code pages

  • Use fir row

In port schema

  • Create Job :

 

Select tools     Untitled     variable click    Untitled   select Global (double click)

  • We can create format in excel workbook
  1. Excel work book : CEMD

               ↓

NEW:

Format name:-

Field name         data type        field size
CCID                    voucher            4
PRES                     voucher          15

             ↓

Manually entering the data

 

Format     Untitled      Directory :

File name:

Acun method

  1. Worksheet

Range  1.         All tildes, 2. custom range

Code page

  • Use first row value Import schama

 

OK

 

 

 

 

 

2. Log – Based Replication:-

Screenshot_63

 

 

The figure above gives an overview of the Transaction Log-based Replication using

This replication method is only recommended for customers that have been invited to use this technology during RTC of the SAP HANA product delivery if you are not part of this RTC group SAP recommends using trigger – based data replication using UAP LT (landscape Trans formation)

Relocation server because of the rich feature set offered by this replication technology

The main component of this replication method are the system replication agent, which is part of the source system, SAP ERP, and the Sybase replication server that is to be implemented in SAP HANA

Replication process in detail.

Screenshot_64

 

The figure above shows details of the data replication process and introduce the additional components of this replication method.

 

Initial load and simultaneous delta Replication:-

The initial load of business data needs to be executed only once to replicate the entire existing data set from the source system to the target, SAP HANA database

The SAP HANA load controller, a component tab resides in SAP HANA, co-ordinates the entire replication process: it start the initial load of source system data to the SAP HANA database in SAP HANA, and communicates with the Sybase replication server to co-ordinate the start of the delta replication

The initial load can be executed while the source system is active as described briefly below:

  • The load controller initiates the initial load by celery the SAP R3 load component in the source system. This is a special version of R3 load available as a patch from (SAP) SAP service market place
  • The R 3 load on the source system exports the data for selected tables in the source system data base and directly transfers this data via sockets to the R 3 load component in SAP HANA without any intermediates files
  • The R3 load on the target system imports the data into the SAP HANA database
  • The loin authentication between the Source system and the target system is handled by the SAP host Agent, which is usually part of the source system

 

In parallel to the initial load, the Sybase Replication Agent in the source system is started and details any data changes that accuse while the initial load already running to core every single change. This detection is performed by reading the logs for committed transactions of the source system database

The Replication Agent uses the table metadata from the database to connect the row log information with the existing table names.

In addition, the replication Agent transfers all relevant row log information vie TCP/IP connection to the Sybase replication server on the SAP HANA side . The Replication server creator SQL statements from the row log information received and sends these  statements to the Sybase enterprise connect DATA access (ECDA)

 

The ECDA connects to the SAP HANA database via open database connectivity (ODBC) driver and replicates the data changes  from the source database by executing the SQL statements in the SAP – HANA database. The multi – version concurrency control (MVCC) of the SAP HANA database prevents locks.

 

Continuous Delta Replication After initial load;-

The continuous delta replication captures  the on going data changes in the source system in real time once the initial load and the simultaneous delta replication have been completed all further data changes are captured and continuously replicated from the source systems  to  SAP HANA using the same process as the simultaneous delta replication described above.

 

Required software components:-

This replication method requires the following components:

  • SAP HANA load controller : Controls the entire replication process by triggering the initial load and coordinating the delta replication.
  • Sybase replication agent: performs the log mining on the source data source and relays all relevant information to the replication server
  • Sybase enterprise connect Data Access (ECDA): connects to the target SAP HANA database via ODBC
  • Sybase replication server: Main component to accept data from the replication agent, distribute and apply this data to the target database using ECDA/ODBC for connectivity
  • SAP host agent: Handles the login authentication between source system and target system

 

LT – Replication:-

  • It allows read time (and scheduled) data replication, replacing only relevant data into HANA from SAP and NON – SAP scores
  • Ability to trans form data into HANA format while replicating data in real – time.
  • Unlimited coverage of SAP releases (SAP R/3 4.6 C on wards) for SAP ERP and ABAP – based AAP applications)

 

Sciences:

1) configure LT Replication server:

Source system    Untitled LT Replication     Untitled   HANA system

(LDH)                                   server (DH2)                                                    (N62)

  • Provide T-code, LTR (in a SLT system)
  • Provide Table Space Assignment
  1. Schema name: Data Class 1
  2. NO. of Replay Jobs: Data Class 2

Data Class 3

Connection to sources system                   Replication

  1. SAP O legacy 1. Real time

RFC destination                                                 2.              Schedule by interval

  1. Schedule by time

 

Connection to HANA system

System user name:

Password :

Host Name

Instance Name

2.

  • Start initial load and relocation for tables OK M check states where Green color or

GO to HANA-STUDIO                                                                                                                    2. Red color

  • Click on data – provisioning
  • Select source system and click on start Untitled start replicate
  • Select table click on add and refresh till status becomes ‘Green’
  • So table & data will updated in HANA DB
  1. Create document is source system and replicate delta of table BSEG into HANA system
  • Make changes in tables

Again click on data – provisioning

  • Select source system and click on start Untitledstart replicate

NOTE: we can suspend  & resume the replication job

 

 

 

 

 

 

 

 

 

 

 

 

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at info@tekslate.com, we will update the article in 24 hours.”

0 Responses on Multiple –sheet extraction in SAP Hana"

    Leave a Message

    Your email address will not be published. Required fields are marked *

    Support


    Please Enter Your Details and Query.
    Three + 6