Create a geodatabase in SAP HANA

Available with Standard or Advanced license.

To create a geodatabase in SAP HANA, read the prerequisites, then follow the steps to install and configure SAP HANA and use the Enable Enterprise Geodatabase geoprocessing tool or a Python script to create a geodatabase in the database.

When you create a geodatabase from ArcGIS Pro 3.4, the geodatabase version is 11.4.0.x.

Complete the prerequisites

Before you create a geodatabase in SAP HANA, do the following:

1. Confirm the ArcGIS, SAP HANA, and operating system combinations you want to use are compatible.
2. Download the SAP HANA client required to connect to the version of SAP HANA you'll use to store your geodatabase.
3. Obtain an ArcGIS Server keycodes file—which is created when you authorize ArcGIS Server—and place it in a location you can access from the ArcGIS client you'll use to create the geodatabase.
4. Install and configure SAP HANA.

   Before you can run the Enable Enterprise Geodatabase tool or script to create a geodatabase in SAP HANA, you (or your IT department or database administrator) must install and configure the SAP HANA database management system. Follow the instructions provided by SAP to install and configure SAP HANA.

5. Install and configure ArcGIS clients.

   Before you create a geodatabase, you must configure your ArcGIS client to connect to SAP HANA. The ArcGIS clients you can use to create a geodatabase in SAP HANA are ArcGIS Pro Standard, ArcGIS Pro Advanced, or ArcGIS Server (enterprise edition). You can run a Python script from any of these clients, or you can run the Enable Enterprise Geodatabase geoprocessing tool from ArcGIS Pro. The minimum software versions supported are ArcGIS Pro 2.1 and ArcGIS Server 10.6.

   Note:

   You need an ArcGIS Server (enterprise) keycodes file to authorize your geodatabase in the next section. Even if you do not run a Python script from an ArcGIS Server machine to create the geodatabase, you must install and authorize ArcGIS Server to get the keycodes file. You may need to copy the file from the ArcGIS Server machine to a location the geoprocessing tool or Python script can access.

   Follow these steps to install and configure the client you need to create the geodatabase. If you do not have permissions to install software, have your IT department perform these steps.

   1. Install ArcGIS Pro or ArcGIS Server.

      Follow the instructions provided in the software installation guides.

   2. Install and configure the SAP HANA ODBC driver on the ArcGIS client computer.

      Follow the client configuration steps applicable to your ArcGIS client:

   • Install the SAP HANA client for use with ArcGIS Pro.
   • Install and configure the SAP HANA client for use with ArcGIS Server (Linux).
   • Install the SAP HANA client the ODBC driver for use with ArcGIS Server (Microsoft Windows).
6. Create an sde user in the database.

   Using SAP HANA tools or SQL, create a standard database user named sde. If you don't create a standard user, you must grant the sde user at least the minimum privileges required for the geodatabase administrator.

   If you are not the SAP HANA administrator, ask the administrator to create the sde user and grant required privileges.

7. Connect to the database as the sde user.

   You can use the Create Database Connection geoprocessing tool or the New Database Connection option in ArcGIS Pro to connect to the SAP HANA database.

   You must save the password with the connection to use the connection file to create a geodatabase.

   Tip:

   The sample Python script provided in the next section includes the creation of the database connection. If you alter and run the sample script, you can skip this manual step.

Create a geodatabase

Use one of the methods described in the following sections to create a geodatabase in the SAP HANA database.

Use the Enable Enterprise Geodatabase tool

If you installed and configured ArcGIS Pro to connect to SAP HANA, you can run the Enable Enterprise Geodatabase tool. This tool uses the database connection file (.sde) you created in section 4 to connect to the database and create the geodatabase system tables, views, functions, and procedures.

Use a Python script

Follow these steps to run a Python script from an ArcGIS Pro or ArcGIS Server machine:

1. Create a text file on the ArcGIS client machine and copy the following script into the file. Change the location on the local machine where your ArcGIS Server keycodes file is stored.

   import arcpy, os, sys, tempfile
   
   if len(sys.argv) != 3:
   	print ("usage: enable_gdb.py  database_dsn  sde_pwd")
   	sys.exit(3)
   
   path = tempfile.gettempdir()
   if os.path.exists(path + r'\enable_gdb.sde'):
       os.remove(path + r'\enable_gdb.sde')
       
   
   arcpy.management.CreateDatabaseConnection(path ,r'enable_gdb.sde', 'SAP HANA',sys.argv[1], 'DATABASE_AUTH','sde',sys.argv[2], 'SAVE_USERNAME')
   
   arcpy.management.EnableEnterpriseGeodatabase(path + r'\enable_gdb.sde', r"\\mykeycodes\Server_Ent_Adv")
   
   if os.path.exists(path + r'\enable_gdb.sde'):
       os.remove(path + r'\enable_gdb.sde')
       
   sys.exit(0)

2. Save the file with a .py extension.
3. Run the script, providing options and information specific to your site.

   In the following example, the file enable_gdb.py is run against the SAP HANA data source named hana1. The connection is made as the sde login with password M@kagdb4me.

   enable_gdb.py hana1 M@kagdb4me

   You can find messages related to geodatabase creation in the sde_setup.log file, which is created in the directory specified for your TEMP or TMP variable on the computer where the Python script is run. If you have any problem creating a geodatabase, check this file to troubleshoot the problem.

A geodatabase is created in the SAP HANA database.

Next, create users and user groups, and grant the privileges users require to do their work.

Tip:

You can use the Create Database User geoprocessing tool to create a standard SAP HANA database user that has privileges to create objects in the database.