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.

Note:
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.
   
   
    
2. Under the System DSN tab, click the Add button.
   
   
    
3. Select the driver to be configured. In this example, HDBODBC32 is selected from the list of drivers. Click Finish.
   
   
    
4. A dialog box appears. Fill out the Data Source Name, Description and Server:Port fields.
   
   
    
5. Click the Settings ... button, and click Add.
   
   
    
6. Enter the following:
   Property: SPATIALTYPES
   Value: 1
   
   Click OK.
   
   
    
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.
   
    
9. Use the Data Source name created in Step 4 to connect from ArcCatalog.