SAP HANA - CTL Method

Open SAP HANA Studio → Create Schema under Catalog tab. <Start here>

Prepare the data and save it to csv format. Now create file with “ctl” extension with following syntax −

---------------------------------------
import data into table Schema."Table name"
from  file.csv 
records depmited by  
 
fields depmited by  , 
Optionally enclosed by  " 
error log  table.err 
-----------------------------------------

Transfer this “ctl” file to the FTP and execute this file to import the data −

import from ‘table.ctl’

Check data in table by going to HANA Studio → Catalog → Schema → Tables → View Content