Connecting to SAP HANA via ODBC from macOS

OpenLink Software’s Lite Edition ODBC-JDBC Bridge driver lets macOS users access their SAP HANA databases from ODBC-compliant applications such as Excel for Mac; using the JDBC driver provided by SAP.

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 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 .

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

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

4. 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>]

5. 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

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

Running a Test Query

7. 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

8. Select your newly created DSN, and click OK

9. Enter your SAP HANA user credentials and click connect

10. 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

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

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.

Related

• Free ODBC-JDBC Bridge Evaluation License Generation & Installer Archive Download Page
• 32- and 64-Bit ODBC SDK and Runtime for macOS
• macOS aspect of iODBC Project
• JDBC-to-ODBC Bridge options — for the Latest Release of Java Virtual Machine, and Beyond
• What are Multi-Tier ODBC-JDBC Bridge Drivers?
• New 32- and 64-Bit ODBC SDK & Runtime for Mac OS X
• OpenLink Data Access Drivers — Secure & High-Performance ODBC, JDBC, ADO.NET, OLE DB Drivers for a wide range of database management systems
• OpenLink Virtuoso — Multi-Model RDBMS & Middleware Platform