Skip To Content

Register SAP HANA with ArcGIS Server

As an ArcGIS Server administrator or a publisher in your organization, you have the option to register your on-premises data stores and cloud stores. In doing so, you are registering data folders, databases, and geodatabases with the ArcGIS Server site so that services you publish can reference the data in those folders, databases, and geodatabases. Data registration provides ArcGIS Server a list of locations to access. Data registration also helps ArcGIS Server adjust data paths when publishing across machines.

The following sections describe how to prepare your ArcGIS client to connect to SAP HANA and register it with ArcGIS Server.

Install and configure the SAP HANA client

Install and configure the 64-bit SAP HANA client on each ArcGIS Server machine that will connect to SAP HANA. Be sure unixODBC is installed on all ArcGIS Server machines in the site.

If your ArcGIS Server site is composed of multiple server machines, you must install and configure the 64-bit SAP HANA client on each server.

See Connect to SAP HANA from ArcGIS for instructions.

Set variables

You must set the LIB_ODBC_DRIVER_MANAGER variable in the ArcGIS Server script to connect to SAP HANA from ArcGIS Server on a Linux machine. See Configure a database connection for ArcGIS Server for more information.

Grant privileges

The login used to connect to the database must have specific privileges granted to it. For logins that will only publish read-only services, grant the privileges necessary for a data viewer as described in Privileges for using ArcGIS with SAP HANA. For logins that will publish editable feature services, grant the privileges necessary for a data editor.

Connect to SAP HANA

You'll need the following information to register an SAP HANA database with an ArcGIS Server site:

  • The type of database platform to which you are connecting (in this case, SAP HANA)
  • The ODBC data source name for the SAP HANA data warehouse
  • Authentication type set to database authentication (operating system authentication is not supported)
  • A valid database user name and password, which must be saved with the connection

Register with ArcGIS Server

You can register the database from ArcGIS Server Manager or the Catalog tree in ArcMap. See the following topics for an explanation of registration options and how to register the database: