English

How To: Configure an ODBC driver to connect to a SAP HANA database

Summary

To make a database connection from ArcGIS to SAP HANA, an Open Database Connectivity (ODBC) driver must be configured. The following article describes making the connection to a SAP HANA database, but configuring the ODBC is very similar for any other database that supports this method of connection. This article assumes the database client files have already been installed.

Procedure

  1. Open the 32-bit ODBC administrator by navigating to the following path: C:\Windows\SysWOW64\odbcad32.exe.

    User-added image
     
  2. Under the System DSN tab, click the Add button.

    User-added image
     
  3. Select the driver to be configured. In this example, HDBODBC32 is selected from the list of drivers. Click Finish.

    User-added image
     
  4. A dialog box appears. Fill out the Data Source Name, Description and Server:Port fields.

    User-added image
     
  5. Click the Settings ... button, and click Add.

    User-added image
     
  6. Enter the following:
    Property: SPATIALTYPES
    Value: 1

    Click OK.

    User-added image
     
  7. Click OK to complete the driver configuration. Additionally, click the Connect button to verify that a successful ODBC connection can be established with the server.
     
  8. From the system's Environment Variables, update the Path variable to include the SAP Client location, which contains the .exe and .dll files
    (The default location is C:\Program Files (x86)\sap\hdbclient;). Place it at the beginning of the Path variable's value, as seen below.
    User-added image
     
  9. Use the Data Source name created in Step 4 to connect from ArcCatalog.

    User-added image

Related Information