Failed to connect to database. Cannot connect to database because the database client software failed to load. Be sure the database client software...

Error Message

When attempting to establish a connection to a supported SAP HANA database in ArcCatalog on a Windows machine, the following error message may be returned:

Error:   
"Failed to connect to database.
Cannot connect to database because the database client software failed to load.
Be sure the database client software is installed and configured correctly."

Cause

The ArcGIS client requires the SAP HANA client directory to be set in the Windows PATH environment variable.

Solution or Workaround

Update the PATH environment variable by putting the SAP client directory path at the beginning. By default, the client file is located in:

C:\Program Files (x86)\sap\hdbclient