Is there a way to import large XML files into HANA efficiently are their any data services provided to do this?

[Former Member]

1. Is there a way to import large XML files into HANA efficiently?
2. Will it process it node by node or the entire file at a time?
3. Are there any data services provided to do this?

This for a project use case i also have an requirement to process bulk XML files, suggest me to accomplish this task

[Former Member]

Hi Shashi,

1. You can best use SAP Data Services as it is very effective in handling large files.

2. It will process the entire file at a time.

3. Please use the XML transformation within SAP Data Services for XML handling.

Hopefully this will help...

Regards,

Patrick Kok

[Former Member]

Hi Patrick,

     I am addressing the similar issue. "Getting data from huge XMLs into Hana."

Using Odata services can we handle huge data (i.e create schema/load into Hana) On-the-fly ?

In my scenario,

I get a folder of different complex XML files which are to be loaded into Hana database.
Then I gotta transform & cleanse the data.

Can I use oData services to transform and cleanse the data ?
If so, how can I create oData services dynamically ?

Any help is highly appreciated.

Thank you.

Regards,

Alekhya

[Former Member]

Could any one reply to this question This for a project use case i also have an requirement to process bulk XML files, and load into hana i.e. bulk insert into hana
suggest me to accomplish this task