

If connecting from ArcGIS Server on Windows, do the following:.
#Hdbodbc driver download install
#Hdbodbc driver download password
Also note that Save user name and password must be checked for connection files that provide ArcGIS services with access to the database, or if you want to use the Catalog search to locate data accessed through this connection file.Ī file is created in \\\Users\\AppData\Roaming\ESRI\Desktop\ArcCatalog. However, if you do this, you will be prompted to provide a user name and password every time you connect. Uncheck Save user name and password if you prefer not to save your login information as part of the connection doing this can help maintain the security of the database.Provide a valid user name and password in the User name and Password text boxes, respectively.Choose Database authentication for the Authentication Type.In the Data source text box, type the data source name you configured for the ODBC driver.Choose SAP HANA from the Database Platform drop-down list.Expand Database Connections in the Catalog tree in ArcMap or ArcCatalog and double-click Add Database Connection.The following steps describe using the Database Connection dialog box. Set the PATH environment variable to the directory where the SAP HANA client is installed.Īdd a database connection using the Database Connection dialog box or Create Database Connection tool.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. For example, use the same data source name when you configure the SAP HANA ODBC driver on your ArcMap machine as you use when you configure the data source name for the ODBC driver on your ArcGIS for Server machine. Use the same name when configuring all SAP HANA ODBC clients to that same database. Use this name when you connect from ArcGIS to the database. After the ODBC driver is installed, set up an ODBC data source name.This key value enables spatial type support through the ODBC connection. 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.Install and configure SAP HANA ODBC driverįollow these steps to configure the SAP HANA ODBC driver used by ArcMap:ĭownload a supported 32-bit SAP HANA clientfrom the SAP Service Marketplace, and install it on the ArcMap machine. To connect from ArcMap to SAP HANA, install and configure the SAP HANA ODBC driver on the ArcMap machine and create a connection from ArcMap to the database.

When connecting from ArcGIS Server, register the database connection file with ArcGIS Server. Once the client is configured, create a connection file.

#Hdbodbc driver download drivers
It is recommended that you install 32- and 64-bit applications and, consequently, ODBC drivers on separate machines to avoid issues that arise when different versions of the same drivers are installed on the same machine.
