Exercise: loading data from ECC to hana using BODS(data services)

[Former Member]

Hi, today we will try to load/transfer data from one of the ecc table to hana using bo data services.

Steps:

Step1: Create two datastore system in bods related to hana and ecc.

step2: search for your table

step3: create project,job and dataflow.

step4: In dataflow: we will use and map our table to  query transform and template table.

the template table will correspond to setting in hana

step5: validate, execute the job

step6: check in hana system

Step1: datastore related to hana system

create your target links on the bottom 6^th tab: datastore: which will be your mapping for hana system,where it will update the data.

Call it vikg_hana1 and give necessary details:

Datastore name: vikg_hana1

Datastore type: database

Database type: SAP hana

Database version: HANAv1.x

Database server name: saphan

Port:30015

Username Hana1,give pwd.

Click checkbox enable automatic data transfer

Step2: Create a datastore w.r.to ECC source system

You can find these details from SAP logon pad:

Create a datastore with below details:

Datastore name: vikg_ecc

Datastore type: SAP application

Database server name: ECCEHP6

User-id (in my case ’Hana1’)n password for ecc system:

Click advanced button: give system Id as 10.

Step3: search for your table

Double-click vik_ecc datastore just created.

Click Repository Metadata radio-button and search for VBAP in the external metadata.

When search result gives vbap ,rt. Click and import.

Similarly do for vbak or any other table.

As you can see, we have sales order header and item  tables: Vbak ,Vbap in display.

Right Click on tables > properties> tab view data > check whether it is displaying data.

If it is displaying data means your connection is ok.

This data we will try to transfer to HANA.

Step4: create project, job and dataflow.

Create a new project in the project area (from the new button on applicaton bar: ecc_vikg01)>

rt. Click and create a  batch job ecc_job2.

Double click job ecc_job2 > drag n drop the dataflow button from the rt. Side button bar.

Call it df02. doube click df02.

Step5: In dataflow: we will use and map our table to  query transform and template table.

the template table will correspond to setting in hana

>doube click df02.>

1. Drag-n-drop your vbap table icon you just create in the ecc datastore 'vikg_ecc'.

2. Then drop query and template table from the rt. side menu.

3. On template table: give your table name ECC_BODS_VBAP, give your hana datastore 'vikg_hana1'

   we earlier created in the datastore area., give owner as your hana schema name: vikasg.

the table will be created in this schema

4.Link table to query and query to hana

5. double click query icon:Select some of the required fields in table and bring on the rt. To-be output side query.

    the query to hana field mapping will happen automatically. If not then you need to do it.

6.Your screen will look like this.

If you click the magnifier button on table VBAP,it will preview or display table data at bottom

As you can see, Query and fields with primary key fields: vbeln and posnr

5. double click query icon:Select some of the required fields in table and bring on the rt. To-be output side query.

    the query to hana field mapping will happen automatically. If not then you need to do it.

If you click the template table: it will show the fields you selected in query.

Step6: validate, execute the job

Then rt. Click on batch job ecc_job2 > execute and select your dataflow df02 (on the pop-up).

After 1 or 2 mins. The job will finish.

From the job log : The job has completed susccessfully.

Second tab says: 17032 records were transferred.

Step7: check in hana system

Now we will check in Hana System:

As you can see 'ECC_BODS_VBAP' table is created in the schema 'vikasg'.

This is the same table name and schema we had given in template table setting in bods.schema was there in hana before hand,

but the table is created at run-time after the job has completed successfully.

check for fields and data type of fields

how vbeln,posr and netwr  had the data type varchar, numeric and decimals in the query transformation

and it is nvarchar and decimal in the Hana system

Now,we will preview data:

On the runtime information tab , it says when the table was created and updated and how many records were transferred.

Similarly,you can upload for sales header: vbak data by creating new dataflow(df01) and new batch job(ecc_job) in the same project.

In hana system you can see we created ECC_DS_HANA_VBAK table below the ECC_BODS_VBAP table.

Note: when you run your particular job, you have to select the dependent dataflow

hope, you find it useful.

Best regards,

Vikas