SAP HANA and ArcGIS Pro – Enable Enterprise Geodatabase

As announced on my previous blog, I am keen to share my experience exploring SAP HANA Spatial. As a start point, I followed the steps described in Tom Turchioe’s Blog: The new ArcGIS Enterprise Geodatabase for HANA – First Impressions to set up and configure SAP HANA as an ArcGIS Enterprise Geodatabase.

In the video below, I am using HANA 2.0 SPS 02 and ArcGIS Pro 2.1. You will also need ArcGIS Enterprise 10.6 which will provide you with the necessary keycode we use in Step 05, Enable SAP HANA as an Enterprise Geodatabase.

The video below is divided in 06 parts, each containing important configurations which cannot be missed. Here a list of the most important ones:

• Step 01 – Creating the ODBC connection:
  • Don’t forget to configure the Special Property section, with:

property:value = SPATIALTYPES:1

• Step 02 – Connecting ArcGIS to SAP HANA:
  • Here you need to input the data source with the ODBC connection name created in Step 01.
  • To make it easier to find the connections later, rename it by adding the user name to the end of the path.

• Step 03 – Creating SAP HANA SDE user:
  • Make sure you grant system privilege CATALOG READ to the SDE user.

• Step 04 – Connecting ArcGIS to SAP HANA – User: SDE:
  • Similar to step 02 above, however SDE user is required as it will be the geodatabase owner.

• Step 05 – Enable SAP HANA as an Enterprise Geodatabase:
  • You will need a keycode, generated in your Enterprise instance, in order to proceed.
  • This keycode is usually found in the following path:

C:\Program Files (x86)\ESRI\License10.6\sysgen​

• Step 06 – Exploring SDE User’s Content:
  • Here you can see the catalog items created in step 05 above, including indexes, procedures, tables, triggers.

Click on the image below to start watching and let me know your thoughts:

If you need more details, check our Esri help page Create a geodatabase in SAP HANA which includes alternatives to the steps suggested above.

Next, I will be exploring this new feature to create and publish a map in ArcGIS. Stay tuned!

Cheers!