Load data from Flat Files into the SAP Hana Database

Part 1

In the File Menu ,choose import. Expand the SAP HANA Content directory. Select Data from local File and choose Next .
The supported file types are: .csv , .xls and .xlsx

Part 2

In the Flat Upload screen, browse for file which should be upload into SAP HANA database. if a .xls or .xlsx file has been selected, choose the corresponding worksheet. if a header row exists in the flat file, select Header row exists and enter row number. if only a specific row range should be relevant for the import, remove check for Import all data and enter the start/end line.
Note: A delimiter is used to determine columns and pick correct data against them in a .csv file, the accepted delimiters are: , ; :

Two options are available:
NEW Schema: When selecting New, a new table with the name entered will be generated within the schema chosen.
Existing: When selecting Existing, data will be appended to an existing table.

Part 3

In the Manage Table Definition and Data Mapping screen it’s possible to map the source and target columns.
The application proposes a mapping structure automatically based on the naming.
Additionally it’s required to select a Key.
Note: Only 1:1 column mapping is supported. Additionally, it’s possible to edit the table definition by changing the store type, data type, renaming, adding or deleting columns.