Hello and welcome to the SAP HANA Academy.
You are watching the video tutorial series: Building Solutions - Live 5.
The topic of this video tutorial is Initial Setup - File Transfer.
Hi, I am Denys van Kempen.
In this video, we are going to setup file transfer between the SAP HANA server and
a client computer and transfer the Text Analysis additional language files
that we have downloaded together with HANA express
to the HANA server.
Now, if you are already familiar with how you can transfer files to the HANA server,
you skip this video.
However, please note that the path where you need to copy the language files to is not
same as documented in the Getting Started Guide.
We are going to transfer the files to /usr/sap/HXE/SYS/global/hdb/custom/config/lexicon/lang
and not to the /hana/shared path as documented.
OK
Multiple ways how you can transfer files to the HANA server.
I will be using FileZilla here.
Free FTP client.
There is one for Windows, one Linux, one for the Mac.
All works the same.
Just google “filezilla” and download the client, not the server, the client, and install.
Simple installation process: next, next, next.
Start FileZilla.
For the host, enter either the IP or the host name
Username: hxeadm Password: well, the one you defined and
the port is 22, that’s the port for secure FTP.
So, if there is a firewall between your client and the HANA server, you need to make sure that this port is open.
I have defined the IP address in the hosts file on my Windows client.
That’s in windows\system32\drivers\etc on WIndows and in /etc/hosts on the Mac
This way you can connect just using the hostname alias here and not the IP.
Here we have our file "additional_lang.TGZ".
It is a zipped tar ball in Linux vocabulary
and it is in the Downloads folder on my Windows client
and here I will just copy the path into the directory on the HANA server
and then you can just drag and drop the file
There is one condition, however.
You need to be able to access the file.
You need to be able to access the directory and the directory need to have write permissions.
If those conditions are not met, you will get an error.
Here we have our error.
for those that like errors.
So let’s switch to PuTTY first.
We have already looked at this in a previous video but should you have missed it, again,
very easy, just google “putty” and download this free SSH, secure shell, and telnet client for Windows.
Connect as "hxeadm" and go to the "lexicon\lang" directory.
You can just copy and paste in PuTTY, very easy.
Now if we go one level up: "cd .."
and do an "ls -l" we can see that hxeadm has
access to the lang directory - it is the owner - but the directory does not have the "w" set for write permissions.
So let’s change that.
Command "chmod u+w lang"
and now we can copy our file over.
Alternatively, you can also use WinSCP, windows secure copy.
Again, just google it.
It is a small download and simple install.
Only for Windows, this time.
Here we have WinSCP.
Integrates with PuTTY.
So you can use the same configurations and the UI is a bit more Windows like.
So you may prefer this if you are a hardcore Windows user.
Then we need to extract our file.
So let’s go back to PuTTY.
The command is "tar xzvf filename" x for extract
z for zipped, v - verbose, will give us a bit of output,
so we can catch any errors, should they occur.
and f for file, tar also works with pipes and tapes and then the file name.
Don't forget to change directories into the "lang" directory
and if you just type "ad" and then use the Tab key for command completion
it saves you some keystrokes.
Here is a reminder for the correct path.
That's it for Initial Setup - File Transfer
You can find more video tutorials on our YouTube channel,
If you would like to be informed about new video tutorials, please subscribe to our channel.
You can connect with us on LinkedIn or follow us on Twitter, as well for updates.
And we also have a page on Facebook and Google+.
If you are watching this video on YouTube, do not hesitate to leave your comments to the video page and,
if you like, give us your vote on his video.
Thank you for watching.