Обновить hana client linux

Install the SAP HANA Client

You will learn

• How to install the SAP HANA client
• The two locations where SAP HANA client installs can be downloaded from

Prerequisites

• A Microsoft Windows, Mac, or Linux machine

This tutorial will demonstrate how to install the SAP HANA client. The next tutorial in this mission will demonstrate how to use HDBSQL, which is a command line utility included with the client’s installation, to connect to SAP HANA. The tutorials cover Microsoft Windows, Linux and Mac. If there are commands that are different depending on the platform, multiple sets of commands will be provided and the title will say Shell (Microsoft Windows) or Shell (Linux or Mac). Note that on Microsoft Windows, the shell used is the Command Prompt.

The SAP HANA client provides a set of utilities and drivers to connect to and query a SAP HANA database from multiple programming APIs, such as Node.js, Python or Java as shown below.

The SAP HANA client can be used to connect to different versions of SAP HANA. For example, a 2.10.x client can connect to SAP HANA Cloud, SAP HANA Service, SAP HANA 2.0 or an SAP HANA 1.0 SPS 09 or higher server. For more information, see SAP HANA client and server cross-version compatibility.

Download the client installer for your platform (Microsoft Windows, Linux, or Mac) from the SAP Development Tools website under the HANA tab and the SAP HANA Client 2.0 section.

An alternate location to download the client installer (SAP Software Downloads) is described in step 3 which includes the SAP Common Crypto library and additional platforms such as Windows 32-bit and AIX.

On Microsoft Windows, unzip the downloaded file in a temporary location.

On Linux or a Mac, use the following:

Start the graphical installer hdbsetup or use the command line installer hdbinst .

Set the install directory to C:\sap\hdbclient on Microsoft Windows or to users/your_user/sap/hdbclient on Linux or macOS and complete the installation.

If an older version is already installed, it can be upgraded or it can be uninstalled by running hdbuninst from the folder where the client is installed. For example c:\sap\hdbclient\install\hdbuninst

After the installation process is completed, update your path environment variable so that the SAP HANA client programs such as hdbsql can be found on your path. On Microsoft Windows, click the Start icon and search for environment variables.

For details on how to configure your path on a Mac see this blog post.

To configure your path on Linux:

Open an editor to edit the file .bash_profile , .profile , or .zshrc (macOS with zsh).

Replace pico with your preferred text editor.

Add the following line to it after changing it to match the location of where the SAP HANA client was installed.

Run the source command to immediately apply all the changes made to the .bash_profile file

In the hdbclient folder, notice that files such as hdbsql and the client database drivers are available.

Run the following command in a newly opened shell to verify the installation succeeded and the path is correct.

The install from SAP Development Tools does not contain the SAP Cryptographic Library. This can be seen by examining the C:\SAP\hdbclient\manifest.mf file.

The SAP Cryptographic Library is only required when client-side data encryption is used, for LDAP Authentication or for cases where a preference is to use the SAP Common Crypto Library over the libraries provided by the OS. For more information, see the following:

Источник

SAP HANA 2.0 Client Installation and Update – by the SAP HANA Academy

Installing or updating the SAP HANA client takes 20 seconds, if that, and is very easy to do.

When using the Windows installer hdbsetup, you will have to decide whether to install or update, click Next and then click Install or Update corresponding to your first selection.

When using the command line installer hdbinst, you can reduce installation anxiety even more by running the command with the -b for batch parameter and the tool will make any decision for you using the (documented) default selections. This makes it very easy, of course, to fully script the update of the SAP HANA client so this can be performed at midnight during a maintenance window on all 20, 50 or 400 client systems in your landscape.

Although the task is easy, it is still important to properly prepare yourself before performing the activity. What ODBC, JDBC, ADO.NET or Python client versions are included exactly in the SAP HANA client? Which SAP HANA server releases exactly are compatible with the latest SAP HANA client?

To address these questions, we have recently updated two SAP HANA Academy tutorial videos about the SAP HANA client included in the SPS 02 Installation and Update playlist:

In this blog, I will provide some references and background information for the client installation and update videos of the series.

SAP HANA Academy – SAP HANA Installation and Update (YouTube Playlist)

SAP HANA Client Supported Platforms

The SAP HANA client is supported on a wide range of platforms from desktop computers to enterprise-class hardware and operating systems:

• Microsoft Windows Server 2008 R2 and later
• Linux (32 and 64-bit, Intel any distribution) *
• Linux (IBM Power Systems LE/BE)
• IBM AIX, HP-UX (Itanium), Oracle Solaris (x64, SPARC)
• IBM i (IBM Power Systems)
• Microsoft Windows 7 and later (32 and 64-bit Intel)
• Mac OS X Yosemite (10.10) and later

For SAP HANA 1.0, it was very common to install the SAP HANA client on a workstation (Desktop) as the regi.exe executable was required to perform repository synchronizations for native development using the SAP HANA XS classic model and SAP HANA studio. This explains the support for both the rather old-fashioned 32-bit platforms and the more fashionable, but a-typical for SAP, Mac OS X platform.

For SAP HANA 2.0, XS classic, the repository (regi.exe), and the SAP HANA studio are no longer in development as this platform now offers the SAP Web IDE for SAP HANA and the SAP HANA cockpit as development and administration tools, respectively.

As the SAP HANA client is also frequently found on SAP Netweaver AS ABAP application servers and as this AS runs on many enterprise-class systems we also find support for IBM Power System, Oracle SPARC, and HP Itanium architectures with its corresponding operating systems.

Normally, you would find technical release information about supported platforms listed in the Product Availability Matrix (PAM) on the SAP Support Portal. However, according to SAP Note 2499500, even the matrix does not have enough fields for the full range of client platforms and requirements.

* For the fine print about supported platforms (particularly on Linux the kernel version and glibc version), see

Unboxing the SAP HANA Client

The SAP HANA client bundles a number of clients, some of which have been included since day one, like the ODBC, ODBO and JDBC clients for C/C++, OLAP/XMLA, and Java database connectivity, respectively, with the SQLDBC libraries, included for good measure.

SQLDBC, originally, are MaxDB client libraries. Why MaxDB? Take a look at the MaxDB SQLCLI client commands and call options and compare this to ones for the SAP HANA Interactive Database Terminal (hdbsql) and you will see the origin of the species. Same for hdbuserstore and XUSER and, on the server-side, much of the persistence infrastructure of SAP HANA.

In an entertaining blog from the very early days of SAP HANA (2011), Lars Breddemann teaches us, HANA novices (pretty much everybody at the time), as a MaxDB veteran, some backup best-practices:

The Python DB API has been included as well from the very early days, not as supported database client – this was only introduced in the latest SAP HANA 2.0 SPS 02 release – but for internal housekeeping. Python was the lingua franca of the TREX Search Engine, which technology made its way into HANA as well.

Apart from Python support, SAP HANA 2.0 SPS 02 also introduced support for the Go language. Support for the Node.js client was introduced a couple of months earlier in SPS 01.

For more information, see the blogs by Tom Slee (SAP HANA product management for client interfaces) on the topic:

Support for Microsoft ADO.NET was added in SAP HANA 1.0 SPS 08. In the SAP HANA Client Interface Programming Reference and on the SAP Community wiki, you can find some tutorials to get started with .NET programming for SAP HANA.

For more information, see

For the exact versions of the supported clients, see

Please Note

The SAP HANA Client Installation and Update Guide documents the installation and update process, which, as mentioned, is a quick and easy one. However, there are a number of SAP Notes that add additional and important information you might want to take note about.

The most frequently asked questions (real or imagined) are the subject of SAP Note:

In case you would like to know, which SAP HANA server release corresponds to client 2.2.33.1510080117 and whether that’s cross-version compatible with your server, see SAP Notes:

SAP HANA Client Installation

How to install the SAP HANA client is the topic of this first video. As mentioned, it only takes a couple of seconds, but in this video, we discuss what you need to know and where to find that information.

We show you the easiest way to download the software, how to install using the graphical installer and how to install on the command line for batch installations (scripted).

Tutorial video

SAP HANA Academy – SAP HANA client installation

SAP HANA Client Update

Once you have installed the SAP HANA client, you will need to update it from time to time to enjoy the latest features. In this second video tutorial, we cover downloads, scripted batch updates on Linux and one/off updates on Windows using the graphical installer. We also show you how you can unbox the client SAR file using the SAPCAR swiss army knife included for free.

Tutorial video

SAP HANA Academy – SAP HANA client update

Developer Trials and Downloads

Currently, the only version of the SAP HANA client available for download outside of the SAP Software Download Center (requiring an SAP account) is version SAP HANA 1.0 SPS 12. It is listed on the SAP Developer Community Trials and Downloads page. This will redirect you the SAP HANA Store where the actual download is available.

SAP HANA 1.0 SPS 12 Client Installation and Update

For your convenience, in case you also still need to perform SAP HANA 1.0 SPS 12 client installations and updates, below the corresponding tutorial video.

SAP HANA Academy – SAP HANA 1.0 SPS 12 Installation and Update

References

For more information see:

SAP HANA Academy Playlists

SAP Downloads

SAP Documentation

SAP Blogs

SAP Notes

• 2460914 – SAP HANA Platform 2.0 SPS 02 Release Note
• 2499500 – SAP HANA Client Supported HAN-DB-CLI
• 1577128 – Supported clients for SAP HANA (SAP HANA 1.0, does not apply to HANA 2.0)
• 2393013 – FAQ: SAP HANA Clients
• 2339267 – HANA client version and installation manifest file doesn’t match currently available HANA server version information
• 1906576 – HANA client and server cross-version compatibility

Thank you for watching

The SAP HANA Academy provides technical enablement, implementation and adoption support for customers and partners with 1000’s of free tutorial videos.

Источник

Install HANA client on Ubuntu

In my last post of Hana with odbc on Ubuntu 12.04,I mentioned I will write another post about how to install HANA client on Linux, well, here it is. Install HANA client on Linux is a little bit tricky. Several things need to bring out just in case someone else run into the same issues.

1, Download HANA client

Download HANA client installation zip file from here, make sure you select the appreciate version.

2, Unzip the downloaded file

Navigate to the unzip folder and go into SAP_HANA_CLIENT

3, Execute following Command

chmod +x hdbinst

chmod +x hdbsetup

chmod +x hdbuninst

chmod +x instruntime/sdbrun

The last execution command is very important, otherwise hdbinst, hdbsetup and hdbuninst couldn’t execute due to missing sdbrun.

4, Install

In order to install hana client on Ubuntu, type following command in your terminal.

sudo ./hdbinst -a client

If everything run smoothly, you will get following response.

/Downloads/SAP_HANA_CLIENT$ sudo ./hdbinst -a client

SAP HANA Database Client kit detected.

Select a SAP HANA Database Client installation:

No | Installation Path | Version | Mode
——————————————————————-
[0] | /opt/sap/hdbclient | 1.00.32.363548 | 64bit
| | |
1 | Install new SAP HANA Database Client | 1.00.32.363548 | 64bit

You can install HANA client into your favorite folder, as you can see, mine was installed under /ops/sap/hdbclient

5, Last Step

It’s not finished, now if you run ./hdbsql, you probably will get error “hdbsql error while loading shared libraries: libaio.so”.

what you need to do is install libaio-dev package by running following command.

sudo apt-get install libaio-dev

6, Test your connection

Congratulations if you see this

Welcome to the SAP HANA Database interactive terminal.

Type: \h for help with commands

Congratulations, now you can play around HANA on Ubuntu. you can run test script and anything allowed.

Источник