SAP HANA HDBSQL is a command-line tool for entering and executing SQL statements, executing database procedures, and querying information about SAP HANA databases. Administrators can execute statements from a command line or schedule scripts that access the SAP HANA database.
SAP HANA provides client interfaces for connecting applications as part of the SAP HANA client software package. Whenever a client or application software connects to the SAP HANA database software, the SAP HANA client and its interfaces have to be used. The SAP HANA client provides a variety of application programming interfaces (APIs), which use SQLDBC and/or JDBC and connect via the SAP HANA database SQL command network protocol to the SAP HANA database server.
Overview of SAP HANA Client
The most popular use case of a tool in the fields of administration, is the command line based HDBSQL, which comes with the installation of the SAP HANA Client software together with other tools like the hdbuserstore. When HDBSQL is initialized with fully qualified connection information, it sends the request via the SQLDBC client interface to the target SAP HANA database server.
Further tools using the client interfaces of the SAP HANA Client software are the Database Explorer (integrated in the SAP HANA cockpit), ABAP-based SAP systems with an underlying SAP HANA database system, and web-based tools using ODATA protocol, XMLA, or Node.js.
The following client interfaces exist:
Further interfaces can be implemented by developers using the following reference guide: SAP HANA Client Interface Programming Reference
Installation and Update, Compatibility, and Platform Matrix
The SAP HANA client software can be installed on various platforms (UNIX, Linux, macOS, Microsoft Windows).
There is no need for the version number of an SAP HANA client driver to match the version number of the SAP HANA server to which it connects. The SAP HANA client maintains strict cross-version compatibility with all Service Pack Stack (SPS) releases of SAP HANA 2.0.
The following documents are useful concerning the compatibility of the SAP HANA client software, and Installation and update: