To publish ArcGIS Server web services that access the data in your SAP HANA database (whether the database contains a geodatabase or not), your ArcGIS Server site must connect to the database. To configure that connection, you need to do the following:
- Install and configure SAP HANA client software on the ArcGIS Server machines and the ArcGIS Desktop client machines.
- Set variables on the ArcGIS Server machines.
- Grant privileges on the data to be published.
- Connect to the database.
- Register the connection file with your ArcGIS Server site.
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.
If you do not have the privileges to install software on the machines where ArcGIS Server is running, you'll need to have your IT department install and configure the SAP HANA client for you.
See Connect to SAP HANA from ArcGIS for instructions.
You must set the LIB_ODBC_DRIVER_MANAGER variable in the ArcGIS Server init_user_param.sh script to connect to SAP HANA from ArcGIS Server on a Linux machine. See Configure a database connection for ArcGIS Server for more information.
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 for a data viewer as described in Privileges for using ArcGIS with an SAP HANA database and Privileges for geodatabases in SAP HANA. For logins that will publish editable feature services, grant the privileges for a data editor.
If the data is in a geodatabase, the data owner must grant the required privileges to the data. If the data is in a database, the data owner can grant privileges from ArcGIS or the database administrator can use database tools to grant the privileges.
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 database.
- 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, the Manage registered data stores pane in ArcGIS Pro, or the Catalog tree in ArcMap. Beginning with 10.7.1, you can register the database to federated servers by adding a data store item in an ArcGIS Enterprise portal. In this case, both the ArcGIS Server site and portal must be running the 10.7.1 release.
See the following for an explanation of registration options and how to register the database: