Skip to Content

Hello Folks,

In this document I would like to explain on how to use “export” for tables in SAP HANA Studio.

To do export you can choose “Export” from “FILE” or “Quick Launch” as shown below:

/wp-content/uploads/2012/04/1_89783.jpg

OR

Go to the desired table and Select “Export” from the context menu as shown below:

/wp-content/uploads/2012/04/2_89752.jpg

It will lead you to the below screen:

/wp-content/uploads/2012/04/3_89784.jpg

Now choose “Next”.

Now Choose the format as “CSV” as shown below:

/wp-content/uploads/2012/04/4_89785.jpg

Now select the destination to which the files has to be exported as shown below:

/wp-content/uploads/2012/04/5_89786.jpg

Exporting of tables + data begins as shown below:

/wp-content/uploads/2012/04/6_89787.jpg

Well you guys (including me) would be thinking that I am succesfull  in exporting the data, but here SAP HANA has an limitation and raises the exception as shown below:

/wp-content/uploads/2012/04/7_89788.jpg

As you can see in the above screen, that max lob size is 4294967296

Now let us try to demonstrate the same example with another table with less data.

This time I choose table named “city” as shown below:

/wp-content/uploads/2012/04/8_89789.jpg

This time it was successful and I get the below data as a result shown below:

/wp-content/uploads/2012/04/9_89790.jpg

  1. I have now create.sql (gives necessary SQL statements to create the table) and data.csv & data.ctl and other files required for file loading. 🙂

Hope you understand this feature “export”. In the next document i will focus on “export” and “import” of landscapes.

Thank you for reading 🙂

To report this post you need to login first.

10 Comments

You must be Logged on to comment or reply to a post.

  1. Ted Wasserman

    Can you explain how to import the tables back into HANA using the Import option? When I choose File > Import > SAP HANA Studio > Tables, the first step asks me to specify a location, however, the Browse button is disabled. Does this have to be a Server path or can it be a client path like your example above? I’ve tried both… unsuccessfully. In the step after that, it asks you to specify which tables. I would assume that if you exported them using the Export option, it would automatically be able to detect what tables you can import, based on the location specified in step 1.

    (0) 
    1. Zeeshan Shah

      It is an instance of the SAP hana server- or a connection made to a server from the CMC ( control management console).The System you add in the administration is the default HANA instance which should be picked up.

      The system does not auto detect the tables to import to; you will have to specify the table along with making sure that the structure is same on both ends

      (0) 
      1. Ted Wasserman

        Hi Zeeshan – I was unable to get the HANA Studio Import wizard to pick up the files on the server or client. Further, the Export operation allows you to specify both the catalog and data. If you are importing these onto a different system, it will not have the table structures created – that is what you would expect the Import operation to take care of (create tables and load data). Are you suggesting that one would need to manually re-create every table from the export operation, before attempting to import?

        (0) 
        1. Zeeshan Shah

          I assumed something else by what you meant Ted. You are correct in that it should automatically create the table structure and load the data. I assumed a different operation was being undertaken.

          Do you have FTP access to the server where HANA is? If you have the ftp access, you can try finding the file there; 

          (0) 
          1. Ted Wasserman

            Hi Zeeshan – Yes, I have tried moving the files to the HANA server. From the HANA studio on my client, I have tried manually entering the path on the server (the “Browse” button is disabled) but it cannot seem to find the files. Has anybody tried this and got it working? Can you share what you did?

            (0) 
  2. Christian Happel

    Hi Krishna,

    you mention the size limitation. Is there any way to work around that?

    Or do I have to use BOBJ Data Services for such large files?

    Thanks, Christian

    (0) 
  3. Bhamini Jha

    Thanks for the post!!  What if I want to export the entire Scema or Backup log in csv ??

    Do we need any special previlages ? Is there a possibility ?

    (0) 

Leave a Reply