Register Login

Exporting Data from SAP HANA Database

Updated May 18, 2018

How to export the data from HANA Database?

We want to export the data from our HANA Database, how can we do the same?

To archive this first you have to connect your HANA Database via SAP HANA Studio and the user needs the system privilege "EXPORT" and the SQL Privilege "SELECT"

Following are the options to export the data:

You can use SQL statements:

  • EXPORT . AS BINARY INTO '/'
  • EXPORT . AS CSV INTO '/'

 Can be also replaced by to export a view. The export of a view includes all underlyling views and tables.  

It is recommended to export "AS BINARY" to keep the size of exported data small.

You can export tables and views using the GUI of the Studio. Please see the attached document for a step by step instruction.

Zip the exported data and if the zip file is larger than 2GB split it with the following command:"split -b 2000000000 index.zip index__Part_" Please request sapmats containers to upload your data. One for each 2GB part.


Comments

  • 26 Jul 2017 6:01 pm Rakesh Samal

    CAN YOU PROVIDE THE DETAIL QUERY WITH A EXAMPLE

     


×