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 delimited by '\n' fields delimited 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
0 Comments:
Post a Comment