Help

Connect to SAP HANA from ArcGIS

Install and configure the SAP HANA ODBC driver on the ArcGIS client machines that will connect to the SAP HANA database.

SAP HANA ODBC drivers are available to existing SAP HANA users as part of the HTTP client access package, or from the SAP Service Marketplace under Support Packages and Patches.

Follow these steps to configure the SAP HANA ODBC driver used by an ArcGIS client:

  1. Install a supported SAP HANA clienton the ArcGIS client machine.

    There are separate installations for 32-bit and 64-bit ODBC drivers. Install the 32-bit client to connect from a 32-bit application such as ArcMap. Install the 64-bit client to connect from a 64-bit application such as ArcGIS for Server.

  2. If connecting from an ArcGIS client on Windows, specify the following key value in the Special property settings section of the ODBC Advanced Setup when creating the ODBC data source entry: SPATIALTYPES=1.

    This key value enables spatial type support through the ODBC connection.

  3. If connecting from an ArcGIS client on Linux, be sure a Linux ODBC driver manager is installed on the client machine.
  4. To connect from ArcGIS for Server on Linux, do the following:
    1. Edit the SAP HANA ODBC connection files. The files must be named .odbc.ini and .odbcinst.ini.

      Be sure there are no spaces around the equal signs (=) in the .odbc.ini file. For example, this entry does not have spaces around the equal signs: Driver=HDBODBC Description=SAP Hana ODBC ServerNode=10.20.30.400:50115 UID=myuser Password=Mein00sr SPATIALTYPES=1 [ODBC] IANAAppCodePage=4 InstallDir=/usr/sap/hdbclient Trace=0 TraceDll=/opt/odbc64v51/lib/odbctrac.so TraceFile=/tmp/odbctrace.out UseCursorLib=0.

    2. Open the init_user_param.sh script found in the /arcgis/server/usr directory of the ArcGIS Server installation directory.
    3. Uncomment and set the LIB_ODBC_DRIVER_MANAGER variable to the location of the libodbc.so.2.0.0 file.

      For example, export LIB_ODBC_DRIVER_MANAGER=$HOME/bin/libodbc.so.2.0.0

    4. If ArcGIS Server was running before you set up the SAP HANA connection, restart ArcGIS Server.
  5. After the ODBC driver is installed, set up an ODBC data source name. Use this name when you connect from ArcGIS to the database.

    If you set an ODBC data source name for the database, use the same name when configuring all SAP HANA ODBC clients to that same database. For example, if you configure a data source name on your ArcMap machine, set the same data source name for the SAP HANA ODBC driver on your ArcGIS for Server machine. If you do not use the same name, you will encounter problems when publishing to ArcGIS Server, because ArcGIS compares the connection strings of the data being published and the database that is registered.

  6. On Windows, set the PATH environment variable to the directory where the SAP HANA client is installed.

Now you can create a database connection file.