Download Data From HANA DB to CSV/Excel

[former_member228146]

Hi Experts,

I have a requirement where I need to take data dumps from my SAP System for Machine Learning Training.
The Database is HANA v2.00.033.xxx

I created a report to download it via a ABAP Report but it was unable to download since the number of records were in lakhs. (In some cases more than 2 million).

Is there any way in which I can download data of this volume directly through HANA DB or by using any third party consumers.

References will be highly appreciated.

Thanks,

Vijay

[deodutt_dwivedi · Accepted solution]

Hi Vijay,

Alternatively, If you are the only targeted audience, you can use Apache NIFI (open source) as well. Install it on your client machine, connect your HANA system and you can stream the data to CSV or other file types.

Regards,

Deo

[deodutt_dwivedi · Accepted solution]

Update - DBeaver also works fine for fetching records up to 1.5 millions (my requirement) which i have used earlier. 🙂

[michael_eaton3]

Hello

SAP HANA Smart Data Integration or SAP Data Services will allow you to write your data to a CSV file.

Michael