Follow the steps appropriate for your ArcGIS Server operating system, either Windows or Linux. You can connect to an SAP HANA database by using ODBC This article explains how to configure an OBDC. Microsoft ODBC for Oracle, Microsoft ODBC Driver for Oracle. Install the SAP HANA client and configure the ODBC driverÄownload the SAP HANA client ODBC driver, install it, and configure a data source name. The data source in the ODBC Data Sources key must also be listed in ODBC. If you want to publish SAP HANA data to an ArcGIS Server site and want the resultant services to use the data in SAP HANA, install and configure a 64-bit SAP HANA client ODBC driver on each machine in the ArcGIS Server site and register the database with the site.
See Make your data accessible to ArcGIS Server for more information about sharing a connection file. Download CData JDBC Driver for SAP HANA - SQL-based Access to SAP HANA from JDBC Driver.
but since ODBC Driver is missing and HDBODBC32 is not appearing in the ODBC Datasources Administation, I am unable to make a ODBC data source for SAP HANA. now i want to connect my SAP HANA Server to BODS 4.0. If you use the data from this connection as the source for a service, such as a geoprocessing or geocoding service, you may need to place the connection file in a shared location on your network. I have installed SAP HANA Studio Revision 26 (32 bit Windows) on my desktop. You can move the connection to another location just be sure users and applications that need to make a connection have read access to the directory where you place the connection file. Save user name and password must be checked for connection files that you register with an ArcGIS Server site 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.