Remember that if you are connecting ArcGIS Pro to HANA, you will need to install the 64 bit HANA client and include that directory in the path as well. If you don’t include the HANA client directory in the path, connecting to the source in a later step will fail. You should always attempt to connect to the data source to avoid these problems. The text in the red oval is the path to the 32 bit HANA client, the next entry is the path to the 64 bit HANA client. Assuming you have installed the HANA client on the C:\ drive, you would modify the path variable as shown below. First, you must include the HANA client directory in the PATH environment variable in Windows. The next step is to setup the ODBC driver. Once the item is unpacked, run the setup and follow the instructions shown here.
For instructions on how to use SAPCAR, read more here.
You can download SAPCAR from the software download center as shown below. Once the item is downloaded, unpack the archive using SAPCAR.exe. To access that, use the pulldown to select WINDOWS ON X64-64BIT Remember you’ll need the 64 bit Windows HANA Client for ArcGIS Pro. Click on SAP HANA CLIENT 1.00 and the following page will appear:īecause I want to connect ArcGIS Desktop to HANA Express, I selected “WINDOWS SERVER ON IA32 32BIT” in the pulldown in the middle of the page. To download the desired item, click on the file name as shown in the red oval above.
I chose to download 1.00 because I’m running HANA SPS 12. Type “hana client” in the search box in the upper right, and this page should appear: Next, click on Software Download and this page should appear: SAP HANA Client 120 for Windows – 64 bitĪfter you login to the SAP Support website, you will see a page that looks like this:.SAP HANA Client 120 for Windows – 32 bit.You should be running ArcGIS 10.3 Server or higher ArcGIS Enterprise 10.5 (includes ArcGIS Server and ArcGIS Portal).You should be running ArcGIS Desktop 10.3 or higher. The three VMs in the landscape that I’m using to write my blogs have the following components installed: You can download the HANA clients and SAPCAR from here. You will need SAPCAR.exe to unpack downloaded. For ArcGIS Server and ArcGIS Pro, you will need to install the 64 bit HANA Client ODBC driver. If you want to connect ArcGIS Desktop to HANA, you will need to install the 32 bit HANA Client ODBC driver. More information about the HANA ports can be found here. Since HANA Express is a multitenant system, instance 00 in this case, the port used in the ODBC Manager is 30013. In these screenshots, I’m running HANA Express. Hopefully, this blog post fills those gaps. I’ll write another blog post on configuring ODBC for ArcGIS Server/Enterprise.įor starters, the HANA client you install depends on which ArcGIS product you’re connecting to SAP HANA. Many of these pages don’t have screenshots and some leave out important details. There’s plenty of articles and instructions on how to setup a HANA ODBC connection for ArcGIS Pro and Desktop. Check out these links to the Esri website including this link for ArcGIS Pro and this link for ArcGIS Desktop. *now updated to reflect ArcGIS Enterprise 10.6.1 and ArcGIS Pro 2.2 – no need to configure the ODBC special property SPATIALTYPES*