Skip to Content
Author's profile photo Former Member

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

Picture3.png

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)

vikg_ecc.PNG

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.


vikg_hana2.PNG



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


import_bname01.PNG




tables_fromecc.PNG


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


hana_import_server.PNG

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

bods_server_detals__03.PNG

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 >

import_03.PNG

selective_import.PNG

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

selective_import02.PNG

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

hana_structure.PNG

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..

import_bods_01.PNG

bods_hana_tables.PNG

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..

dflow01.PNG

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

Go to Hana and preview your data

mara_data.PNG

Thanks & best regards,

Vikas G

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.