Connecting to SAP HANA via ODBC on macOS

Data Access Drivers & Connectors Open Database Connectivity (ODBC)
, , ,
1

Prerequisites

  • Installation of the SAP HANA client and a working JDBC connection to your SAP HANA instance. This can be confirmed using various Workbench tools such as SQLWorkbenchJ and DBeaver
  • Knowledge of your SAP HANA instance’s default SQL listener port. The default port is 39013.
  • A Working Installation of OpenLink Software’s Lite Edition ODBC-JDBC Bridge Driver with an Evaluation or Commercial License (Instructions).

Instructions

  1. Add the SAP HANA ngdbc.jar document included in the SAP HANA client package to /Library/Java/Extentsions .

1263×681

  1. Open iODBC Administrator, and click on add . Select OpenLink JDBC Lite Driver or OpenLink JDBC Lite Driver (Unicode) , then click Finish .

1236×868

  1. Select a name for your Data Source Name (DSN), add a description if needed, and click Continue.

1068×734

  1. Enter the JDBC Driver Classname , and JDBC String for your SAP HANA instance.
    The Classname is:

com.sap.db.jdbc.Driver

The URL scheme is:

jdbc:sap://<server host>:<port>[/?<options>]

1070×732

  1. Check the Connect now to verify that all settings are correct checkbox, enter your SAP HANA username/password, and Click on the Test tab.

If a successful connection is made, a confirmation message will appear. Click OK

1074×736

  1. Click Test Data source. A successful test connection will result in another confirmation message. Click OK , followed by Finish .

1072×732

Running a Test Query

  1. Open the iODBC Demo ANSI or iODBC Demo Unicode applications that are automatically installed with OpenLink’s Data Access Drivers for macOS for testing ODBC connections; and navigate to Environment -> Open Connection

1263×789

  1. Select your newly created DSN, and click OK

1234×870

  1. Enter your SAP HANA user credentials and click connect

878×326

  1. A successful connection will return to the empty user interface. Navigate to SQL -> Execute SQL… and enter your SQL query into the resulting text box. Once completed, click OK

53%20AM
53%20AM1318×694 31.7 KB

  1. On successful execution, the previously empty UI will be populated with the query results returned from our SAP HANA database.

58%20AM
58%20AM2874×1752 690 KB

Following a successful test query, you can now use the ODBC driver with other ODBC-compliant applications on macOS such as: Excel, FilemakerPro, and others.