GUIDELINES TO LOAD DATA INTO TABLES IN SAP HANA DB- Yasmin Banu A

Steps on how to load into SAP HANA DB using the “Data From Local File Option” :

Say we want to upload a csv file with the following material data content into the table of SAP HANA,

Step 1 : Login to the SAP HANA StudioStep 2 : Click the ‘Import’ option from the right side

pane (highlighted in red)

Step 3 : On clicking the ‘import’, a pop up appears, from which we have to select “Data from Local File” & click on Next

Step 4 : Select the target system where you want to import the data and click Next

Step 5 : Specify the following required details in the dialog below

a) Source File : Specify the location of the source file by browsing

b) File Details : Select the Field Delimiter (Comma or Semi Colon or Colon) and select from which Worksheet of your file, you want to import the data. If the file has single sheet then this option would be disabled

Import all data: With this option, either you can import all the data from flat file or you can specify the lines needed (For Ex : Import the data from line number 3 to 7)

c) Target Table : New : If you would like to create a new table in HANA DB with the data from flat file, then opt this option. Specify the Schema name under which you would to create the table and the name of the table

Existing : If you would like to append the flat file data into an existing table, then opt this option

Step 6 : Click Next

Step 7 : Nextly, the screen shows the source and targets mapped by default. If the user wants to change, they can delete the join and remap with other columns or so

In order to change the fields (like move them up or down), or delete some existing field (s) or add some new field(s), this can be achieved by using the following button available in the mapping pop up window

We can set the Store Type to either Row Store or Column Store through the drop down option. If the Store Type is set to Column Store, then the Primary Key should have to be set by user by selecting the respective Key Column checkbox.

The user can enter the description for each target field, if they want to

The Preview of the File Data will be shown in the lower portion of the pop up screen

Click Next

Step 8 : The next screen will show the preview of how the data will be stored in the target table in HANA. Then, click next.

Step 9 : Click Finish of the previously shown pop up screen.

Step 10: Check the Job Log Entry to know the status of table creation

Step 11: Now we have to go to the Navigator Pane -> Catalog folder -> Schema you selected as target ->Tables and look for this newly created table

Step 12 : To view the contents of the loaded table, right click on the table created and choose the option ‘Open Data Preview’

Step 13 : The loaded data appears in the table created

THANK YOU