To connect to an SAP HANA database from ArcGIS clients, install and configure the SAP HANA client ODBC driver on the ArcGIS client machines.
Note:
SAP HANA clients are available to existing SAP users from the SAP Support Portal under Software Downloads.
After the ODBC driver is configured on all ArcGIS client machines, create a database connection file. To publish ArcGIS Server web services that reference the data in the SAP HANA database, register the database connection file with your ArcGIS Server sites.
Install and configure the SAP HANA client
Download a supported 64-bit SAP HANA client from the SAP Support Portal under Software Downloads, and install it on all ArcGIS AllSource machines and machines in ArcGIS Server sites with which you will register a connection to an SAP HANA database.
Follow instructions provided by SAP HANA to install and configure the ODBC client.
Connect from ArcGIS AllSource
To connect from an ArcGIS AllSource project to SAP HANA, install the SAP HANA client ODBC driver on the ArcGIS AllSource machine and create a database connection.
Create a database connection using the Database Connection dialog box or the Create Database Connection geoprocessing tool.
You can use the SAP HANA server name and the SQL port number to connect to the database if all of the following are true for your site:
- You're connecting to an on-premises installation of SAP HANA.
- You're connecting from a general release version of ArcGIS AllSource.
- The number of characters in the SAP HANA server name and SQL port number of your SAP HANA server is fewer than 31.
If any of the above conditions are not true, you must configure a system data source name (DSN) for the SAP HANA client ODBC driver before you complete the following steps to connect to the database. See SAP HANA documentation for instructions to configure a data source name.
Follow the steps below to connect to SAP HANA using the Database Connection dialog box.
- Open the Catalog pane in ArcGIS AllSource.
- Right-click Databases and click New Database Connection.
- Choose SAP HANA from the Database Platform drop-down list.
- In the Data source text box, type one of the following:
- The SAP HANA server name and the SQL port number used to communicate with the database separated by a colon (:). For example, if the fully qualified name of your SAP HANA server is myserver.network.com and SAP HANA communicates through port 98765, type myserver.network.com:98765. Alternatively, you can set a port number under Additional Properties. (See step 9 below.)
- The data source name you configured for the ODBC driver.
- Use database authentication for the authentication type.
Operating system authentication is not supported.
- Provide a valid database username and password in the User name and Password text boxes, respectively.
- If you prefer not to save your login information as part of the connection, uncheck Save user name and password.
Doing this can help maintain the security of the database. However, if you do this, you will be prompted to provide a username and password every time you connect from ArcGIS AllSource.
Note:
Save user name and password must be checked for connection files that you register with an ArcGIS Server site or if you want to search to locate data accessed through this connection file.
- Type a name for the connection file in the Connection File Name field.
As you provide connection information, a default name is created. You can use the default, or type a more descriptive file name.
This is the name that will appear in the Catalog pane and view, and the name of the .sde file stored on disk.
- Optionally, expand the Additional Properties section to type a connection parameter and value.
Read the SAP HANA documentation for information about additional and optional connection parameters.
- Click Validate to confirm that the connection information is valid and the database is accessible.
If the database contains a geodatabase and the connection is valid, the Geodatabase Properties tab is now active.
- Click OK to create the connection file.
A database connection appears under Databases in the Catalog pane, and a connection file (.sde) is created in the ArcGIS AllSource project directory.
Connect from ArcGIS Server
To publish SAP HANA data to a federated or stand-alone ArcGIS Server site and keep the data in SAP HANA, install a 64-bit SAP HANA client ODBC driver on each machine in the ArcGIS Server site and register a database connection file with the site.
Once you configure the machines in the ArcGIS Server site, create a database connection to the SAP HANA database and register the connection file with your ArcGIS Server site.
Connect to the database
You can use the Database Connection dialog box in ArcGIS AllSource to connect to the database, as described above.
Alternatively, you can run the Create Database Connection tool in ArcGIS AllSource or use Python to run the Create Database Connection command from an ArcGIS Server machine to create a database connection file (.sde) that connects to the database.
You must save user information with the connection file to use the database connection file with ArcGIS Server.
Register the database
To publish web services using data in SAP HANA, create a database connection and register it with your ArcGIS Server sites.
To allow ArcGIS Server sites to access the data, use the database connection file you created to add a registered data store in ArcGIS AllSource or add a data store item in the portal.