Skip to Content

How to export data result from query to .dat file on HANA database?

Jul 04, 2017 at 12:15 AM


avatar image

Hello everyone,

I need easily export a query result to a .dat or .txt file, from HANA database; when using SQL, I use bcp utility to generate those files; ¿does HANA provide some utility in order to export data?

I've tried programmatically to do this task, but it's extremely slow when the result includes thousands of records

Thanks for your help

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Ralph Oliveira
Jul 05, 2017 at 10:44 AM

1 - Instead of a query, use one or many Graphical HANA Calculation view to retrieve the records

2 - Query the Calculation View with an XSJS

3 - Return the XSJS content as a txt (or do the formatting you want)

Never query the tables directly, always use the views (Graphical is the best)

10 |10000 characters needed characters left characters exceeded