So in order to load shape file into HANA you need to perform the 4 simple steps stated below:-
- Download Putty(http://www.putty.org/) and PSCP(http://www.nber.org/pscp.html)
- Copy the shape file(zip it first) from your local machine into HANA using PSCP
C:\<path to PSCP directory>>pscp.exe <source file> <OS_Username>@<HANA _server name>:<destination folder>
- You can login to you server using putty and unzip the files.
- You can import the shape files in HANA by running the below command
IMPORT “Schema_Name”.”Table_Name” AS SHAPEFILE FROM ‘path to shape file’
Note: Don’t give the extension of the shape file in the path. Just mention its name.