Skip to Content
Previous

Select a SQL query tool for SAP HANA, express edition

By Abdel DADOUCHE

Provide details on the installation and configuration of SQL query tools and connect to SAP HANA, express edition.

Details

You will learn

In this how-to guide, you will find references to the various options available to execute SQL on SAP HANA, express edition.

These options either embeds or leverage one of the available connector/driver from the SAP HANA client.

You can use one of the links that match your preference and proceed with the installation and configuration.

Step 1: SAP HANA Tools for Eclipse

SAP HANA Tools for Eclipse is an Eclipse Add-On that enables any Eclipse installation for querying any SAP HANA database.

It embeds the connectivity which means that you don’t need to install the SAP HANA client package.

Use the following link for detailed instruction regarding the installation and configuration of the SAP HANA Tools for Eclipse.

Provide an answer to the question below then click on Validate.

From the linked tutorial, which version of Eclipse are NOT supported for the SAP HANA Tools? (All versions of Eclipse are listed at: https://wiki.eclipse.org/Older_Versions_Of_Eclipse)
×
Step 2: SAP HANA HDBSQL tool

The SAP HANA HDBSQL is a command line tool for executing commands on SAP HANA databases.

Using SAP HANA HDBSQL, you can execute SQL statements and database procedures, as well as query information about the database and database objects.

SAP HANA HDBSQL is installed with the SAP HANA client package software.

Use the following link for detailed instruction regarding the installation and configuration of the SAP HANA HDBSQL tool

Provide an answer to the question below then click on Validate.

Can you connect using HDBSQL without the specifying the SQL service port number?
×
Step 3: JDBC based querying tools

The SAP HANA client package provides a driver that enables Java applications to connect to SAP HANA databases using the JDBC application programming interface (API).

JDBC (Java Database Connectivity) is an application programming interface (API) for the Java programming language.

Use the following link for detailed instruction regarding the installation and configuration of JDBC based querying tools

Provide an answer to the question below then click on Validate.

Within the following list, which JDBC URL format will allow you to connect the SAP HANA, express edition?
×
Step 4: ODBC based querying tools

The SAP HANA client package provides a driver for connecting applications to SAP HANA databases with ODBC.

ODBC (Open Database Connectivity) is a standard application programming interface (API) for accessing database management systems.

Initially build for Windows platforms, it is also available for Linux environments too.

Use the following link for detailed instruction regarding the installation and configuration of ODBC based querying tools

What utility is available with unixODBC to test your ODBC connectivity?
×

Updated 09/10/2018

Time to Complete

10 Min.

Beginner
Next
Back to top