Loading data from SAP ERP: (Delta)

Create data store for HANA DB

Create a data store for R3  

Steps as SAP ECC6 level:

Log on to ECC6

Go to provide 7 – Code RSA file

Select Required Extractor

Activate

Again go to RSA6 T-Code

Select Recently activated extractor

EDIT and make any changes based on requirement and save it  

Inclined to build a profession as SAP HANA Developer? Then here is the blog post on, explore "SAP HANA Training"

Steps at Data Services:

Import our extractor into SAP Application Datastore (Enable CDC Option)

Import our HANA DB table into the HANA DB store

Create a project

Create a job

Create workflow

Create data flow

Drag extractor

Take query transformation

Drag our HANA DB Table

Connect extractor of query transformation

Connect HANA DB table & Query transformation

MAP the fields of extractions & table

RUN the job

Execute the job

 

Check Out SAP HANA Tutorials

Screenshot_60  

Loading data from dynamic files to SAP HANA

Create data store for HANA DB

Import out Required our Target area

Bulk loading from source table by using data services  

Design Data services first load the data into a staging table and then it applies the operation codes (INSERT, UPDATE, and DELETE) to update the target table. With the Bulk – load option selected in the table editor, any one of the following conditions triggers the staging mechanism The data flow contains a Map – CDC operation transform Y the data flow contains a map – operation transform that outputs update or DELETE rows Y the data flow contains a table – comparison trans for Y the auto-correct load option in the target table editor is set to yes  

Settings Template tables For template tables, select the appropriate table type for your SAP HANA target Y column store (default) Y Row store

Target options bulk loader options load pre-load post – load  Triggers pre-load commands post –load commands Rows per commit: Delete data from the table before loading: Drop and re-create table :   Screenshot_61  

Advanced Generate column comparison No.of loaders compare by name 1 Error handling use overview flow NO Filename Not Applicable File format Not Applicable Update control use input keys NO Update key columns NO Update auto-correct load NO  

All Table When bulk loading in enabled, you have the following options:- Models specify the mode for loading data to the target table Append :adds new records to table (default) Truncate : deletes all existing records in table then adds new records Commit size – the maximize no. of rows loaded to the staying and target tables before saving the date Column store (default commit size is 10,000) Y Row store (default commit size is   1,000) Y update Method – specify how the input rows are applied to the target table Y update issues an UPDATE to the target table (default for column store tables) Y DELETE – INSERT : issues a delete to the largest table for date that matches the old data in the staying table, then issues an INSERT with the new data (default for Row store tables) Do not delete –insert if the update rows do not contain data for all columns in the target table been at a  services will replace missing data with NuLLS Target options bulk loader load triggers pre – load commands post load commands co Bulk loader Mode : Appeared Commit side: Update method:  

Dynamic flat (FF) file selection Using valuable:-  We can extract the file dynamically we can use the variable go-to workbook    Untitled   new  Untitled   Format name : Directory: It is used mostly enter the File Name: File name so it cant import data then we will enter the fields name and data type and size

Field name                          Data type                           Size

Cost-contce-id                  voucher                                     4

Pres                                                                                     15

A variable is a job-specific (Group of WF and DF) Select JobUntitled go-to tools  Untitled  create variables We select global variable Now we can use the “script writing “ the load script is using in the DF & WF Script in always inside a job (or) data flow, WF is a group of DF We can place the script inside DF and corner DF Script is not a reposing object “it is a reusable object”

For in-depth knowledge on SAP HANA, click on below: