Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 
Former Member
0 Kudos
2,314

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.

Go to Hana and preview your data

Thanks & best regards,

Vikas G

Labels in this area