Creating SAP HANA as an ODBC Data Source on Windows

The ODBC Administrator provides a central place for creating and managing ODBC data sources on the Windows platform.

When using 32-bit ODBC drivers, use the 32-bit ODBC Administrator to manage data sources; for 64-bit clients, use the 64-bit ODBC Administrator.

  1. From the Windows Start window, select Settings > Control Panel > Administrative Tools > Data Sources (ODBC).
  2. Click Add.
  3. Select HDBODBC from the list of drivers.
  4. Click Finish.
  5. In the ODBC Configuration window, enter the Data Source Name and Server:Port . For example, to connect to a server named "HANA_DB" on host "hanaserver" with address 157.133.66.75 using TCP/IP protocol and port 1870, select TCP/IP and enter:
    host=hanaserver:1870
    To use a host network address, enter:
    host=157.133.66.75:1870
  6. Click Ok.