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.
Go to Hana and preview your data
Thanks & best regards,
Vikas G