In this document, I would like to explain how the data can be uploaded into HANA DB through the “Data From Local File” option which is a new feature of HANA Studio Revision 28 (SPS04).
Pain in the past:
So far, uploading data into HANA from flat file is not a straight forward approach.
The user has to create some control (.ctl) files, have to place the flat file along with control file into server location, execute SQL scripts to import the data.
Or some users’ would have used SAP Information Composer to achieve this.
Instant Solution:
Now everything made so simple through “Data From Local File” import option. Through this option one can upload data from xls,xlsx and csv files.
Pain in the past:
So far, uploading data into HANA from flat file is not a straight forward approach.
The user has to create some control (.ctl) files, have to place the flat file along with control file into server location, execute SQL scripts to import the data.
Or some users’ would have used SAP Information Composer to achieve this.
Instant Solution:
Now everything made so simple through “Data From Local File” import option. Through this option one can upload data from xls,xlsx and csv files.
