Former Member

April 8, 2016 4 minute read

Exercise: How to Selective import of meta-data in Hana and table data

In this exercise, we will first import meta-data of the table i.e. the structure first and then the table data.

To selective import some required tables , we will be pulling data from ECC via BO data services.

it is like ECC(source) => BODS => HANA studio (target)

so, we would need details like host name, port no or server address and user-id, password of these three systems.

ECC details, you can get from your launch pad.

rt. click on your hanadb server of your user-id in HANA studio > properties and you will get hana host name info.

Steps involved:

Step 1: IN BODS system: We will create the connection from BODS to ECC and BODS to HANA, we call them datastore

Step 2: Import table on your ECC ref. datastore (e.g. <<vikg_ecc>>). and mention MARA, MAKT or reqd. table

Step 3: GO to Hana studio > Modeler tab > setup the configure import server link (w.r.to data services)

Step 4: In Hana: Selective import your table (MARA, MAKT) using <<vikg_ecc>> ref. BODS datastore in your reqd. schema.

Check your table has been created

Step 5: IN BODS system, Import your table in the hana ref. datastore( e.g. <<vikg_hana2>>)

Step 6: Create a project > job > dataflow

Step 1: IN BODs system: We will create the connection from BODS to ECC and BODS to HANA

1.a. (BODS_ECC):: Enter ECC connection details: go to datastore tab (from the bottom panel)> create new > give a name

> select datastore type as SAP applications

Give other details:

In my case :server name: STECCSLT, user-id, pwd and

And in the advanced tab, mention client-id e.g : 800 and system id (e.g. 74 in my case)

1.b. (BODS_hana):: Enter Connecton to hana details:

go to datastore tabe > create new > give a name < select datastore type as database > select database type as SAP Hana > select database version

Give other details:

In my case server name: sthana, port: 30015, give user-id,password

so, we created vikg_ecc and vikg_hana2 datstore.

Step 2: In BODS sys.: Import table on your ECC ref. datatore(vikg_ecc). Rt.click > import by name for e.g. MARA,MAKT table

Step 3: GO to Hana studio > Modeler tab > click on <<configure import server>> link

Give details:

Select your hana system > give your BODS server address (e.g. STBODSSRVR) > give your repository name > e.g.. (user5_repo)

> leave odbc datasource as blank > enter port as 8080

Step 4: Also notice, the other <<Import>> button ( you can find it below configure import server link) > click on it >

choose selective import of meta-data> choose your hanadbserver >

Now we are first importing metadata of tables from ECC via BOdataservices , (so choose your datastore <<vikg_ecc>>

(which will appear as option, this is the same datastore we just created in BODS).

Select type of objects as tables. Now search and select your table, which we imported in BODS, vikg_ecc datastore e.g. MARA or MAKT

Choose your schema, where you want to import your table.

And then click next and finish

The the table will appear in our schema,but it will not have any data in it.

Now we know, only the structure of tables are there in HANA. So now , we will transfer data to these tables via BODS

Step 5: IN BODS system, (rt. click &) Import your table in hana ref dastore( <<vikg_hana2>>),,

The owner is your schema, where you have just created the metadata in your Hana studio..

Step 6: Create a project > job > dataflow

In the dataflow, pull MARA table from <<vikg_ecc>> datastore(drag-n-drop),,

let it pass through query transformation> connect it to Mara from <<vikg_hana2>> datastore (drag-n-drop),,,

select vikg_hana2.MARA as target table

In the query transformation,,map all the fields to the output.

The dataflow would look like this..

Next >> execute the job >>select your dataflow >> once your job finishes successfully.

Exercise: How to Selective import of meta-data in Hana and table data

Assigned Tags