Skip to Content

Load ESRI files via Eclipse

Load ESRI files via Eclipse
You will learn
  • How to load ESRI shape files into SAP HANA using Eclipse
fath-markusMarkus FathFebruary 7, 2023
Created by
September 13, 2018


  • Eclipse is setup for CodeJam exercises

Add additional information: Background information, longer prerequisites

  • Step 1

    Download two zip files from to your computer.

    Uncompress them.

    Log in to complete tutorial
  • Step 2

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

    Log in to complete tutorial
  • Step 3

    Create a schema GEOTECH using SQL.

    Log in to complete tutorial
  • Step 4

    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.

    Find location

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

    Select shapes

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

    Select options

    Click Finish

    Log in to complete tutorial
  • Step 5

    Check there are 8 records loaded using SQL:

    SELECT COUNT(*) FROM "GEOTECH"."continent";
    Log in to complete tutorial
  • Step 6

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

    Log in to complete tutorial
Back to top