Flat File data load vs. BODS Flat File load

[Former Member]

Hello Experts,

From a performance point of view which option is better for a high volume data load? Are there any white papers available on this topic?

Thanks,
Das E

[Former Member]

SP4 introduced the feature of flat file data load through File Import Wizard of HANA management studio.

In my personal opinion, if file does not require complex transformations, then file import wizard is best option. I haven't came across such white papers.

[Former Member]

This is my opinion working with BODS AND HANA.

Hana does not have any scheduling mechanisum to load the data if this flat file is more frequent. You may need bods etc to get working.

HANA does not offers an intutive way of transformation BODS has ETL capability to do anything on the data

File Import Wizard can be  risky since every time the file has to be loaded you will need to map with all the fields anything not right in the mapping would lead into situation.