Load ESRI files via Eclipse

Download two zip files from http://bit.ly/GeotechFiles to your computer.

Uncompress them.

Open Mapshaper web site and load Continents.zip file to check the content.

Create a schema GEOTECH using SQL.

CREATE SCHEMA "GEOTECH";

In Eclipse in SAP HANA Administration go to File -> Import.

Select an import wizard for SAP HANA -> ESRI Shapefiles. Click Next

Select you SAP HANA instance as a target, if asked by the wizard.

In Specify Location screen select the option to load from current client (i.e. from your laptop).

Click Browse and point to the directory Continets, where you uncompressed the zip file.

On Select ESRI Shapefiles to import you should see continent has been found in the directory and added to Selected Shapefiles.

On Options… screen type:
- Schema: GEOTECH
- Replace existing tables: checked
- Number of parallel threads: 4
- Spatial Reference Identifier: 1000004326

Click Finish

Check there are 8 records loaded using SQL:

SELECT COUNT(*) FROM "GEOTECH"."continent";

Repeat the same steps to load cntry00 data into "GEOTECH" schema as well.