Loading data from HANA view via BODS

[Former Member]

Hi ,

We have a requirement to load data from HANA view to Oracle via BODS.

I am aware of mapping when the source is a table or a flat file. Please help me on how to load data to target via BODS when the source is a HANA view.

Thanks,

Deepa

[Former Member · Accepted solution]

Hello

Yes, this is possible.  .You can import the metadata for a view, or use the SQL transform.  See this similar post - http://scn.sap.com/thread/3429037

Michael

[Former Member · Accepted solution]

Thank you very much Michael.

It looks this solution works for our requirement.I will try out this out.

Thanks,

Deepa

[Former Member]

You may want to have a look at these existing SCN discussions - http://scn.sap.com/docs/DOC-26311 & http://scn.sap.com/docs/DOC-57790 -  which might be helpful.

We encourage our users in this forum to do searches within relevant SAP SCN forums to see if there are existing entries that might help.

Thanks. 

[Former Member]

Thanks for the reply Mike.

In our scenario we have HANA virtual table(view) as the source of data.

So please suggest me the method in BODS to fetch data from HANA virtual table(view) and load it into target table.

I am worked on loading data from physical table or file but I have no idea how can we load data from a View or a Virtual table.

Thanks,

Deepa