In earlier versions of SAP HANA 1.0 SP3 flat file upload  was done via BODS ( Business object Data Service Designer) and other methods. From SP4 we can upload flat file directly to SAP HANA. Kindly follow the steps to upload the data from the flat file to SAP HANA database.
1) Open SAP HANA Studio
2) Login to the SAP HANA system with credentials
11-26-2015 5-05-42 PM
3) Navigate to the file and then click import
11-26-2015 5-06-12 PM
4) Navigate to SAP HANA Content and then select Data from local file. Click next
11-26-2015 5-06-26 PM
5) Select the target system which is HANA DB. Click Next
11-26-2015 5-06-38 PM
6) Select the file to upload by clicking the browse button. Only three file formats are supported ( .CSV,.XLS,.XLSX) in flat file upload method. In the target table select the schema where the table will be   uploaded and give the table name. Click Next
11-26-2015 5-08-18 PM11-26-2015 5-07-22 PM
7)  You can define whether want to upload the table as Column Store or Row Store table from Store type.Define the required data type and primary key for the table
11-26-2015 5-08-52 PM11-26-2015 5-09-17 PM11-26-2015 5-09-54 PM
8) After definition and mappings done click finish.

11-26-2015 5-15-38 PM
9)  Check the job log on successful import of flat file
11-26-2015 5-16-04 PM
10) Navigate to Catalog > Select the schema > Tables. Right click and refresh so that the uploaded table will appear.
11-26-2015 5-16-50 PM
11) Right click the table. Click open definition and open content to display the data types and data from the table.
11-26-2015 5-18-44 PM
11-26-2015 5-18-54 PM11-26-2015 5-19-13 PM

Post a Comment