I learned about SAP SQL Data Warehousing. This topic was even more exciting to me, because I’m an SAP BW Consultant, and I don’t knew before about possibility to build your own SAP Warehouse directly on HANA database. So why I can’t just install this add-on on my private Hana DB, to check this out by myself? This is so simple, and this article shows you how to do this, starting from fresh SAP HANA XSA installation.
◈ S-USER for DWF download,
◈ 4 cores of CPU (in my case), and 12 GB RAM for VM,
◈ SAP Hana Server + Applications (XSA),
◈ two hours of free time.
First of all, you have to download SAP HANA Express, there are many possible variants to achieve this. My recommended way is just to download and run the full official VM image, which you can run on most popular operating systems
The most important thing is that you have to download option with applications, because of DWF is a plugin.
The second thing is registering your SLES machine to get the registration code. This code is necessary to register our copy of SUSE Linux Enterprise server. I propose to perform this step to avoid issues with the installation of your virtual machine tools responsible for access to host machine disc. You can skip this step if you don’t need to install any packages in SLES, and if you are able to move downloaded DWF plugin in another way ( i.e. you can download it using CURL, from local machine HTTP server ).
1. Check your system version by run:
cat /etc/os-release
Requirements:
◈ S-USER for DWF download,
◈ 4 cores of CPU (in my case), and 12 GB RAM for VM,
◈ SAP Hana Server + Applications (XSA),
◈ two hours of free time.
SAP HANA XSA INSTALLATION
First of all, you have to download SAP HANA Express, there are many possible variants to achieve this. My recommended way is just to download and run the full official VM image, which you can run on most popular operating systems
The most important thing is that you have to download option with applications, because of DWF is a plugin.
SAP HANA Express SLES registration
The second thing is registering your SLES machine to get the registration code. This code is necessary to register our copy of SUSE Linux Enterprise server. I propose to perform this step to avoid issues with the installation of your virtual machine tools responsible for access to host machine disc. You can skip this step if you don’t need to install any packages in SLES, and if you are able to move downloaded DWF plugin in another way ( i.e. you can download it using CURL, from local machine HTTP server ).
1. Check your system version by run:
cat /etc/os-release
2. Go to SLES download page, and select your version of OS
3. Register yourself
4. When your registration code is ready, you will be able to log in at https://scc.suse.com/subscriptions?family=sles. There you should see something similar to:
5. Now you need to provide this code into Yast tool. To do this by copy/paste you can simply login by ssh into the machine, and run:
sudo yast
then go to Software -> Product registration
6. Here provide your e-mail and registration code
7. Repositories should be refreshed. After this, you should be able to install your VM tools or any additional software.
Data warehouse foundation download
If you have any troubles, please refer to this.
1. Please check your Hana version. Execute
HDB version
2. Go to SAP Launchpad software download,and next please folow:
3. Add to basket and download you version of DWF using SAP Download manager from official SAP site
4. In your Hana VM Machine, please start jobscheduler-broker
xs start jobscheduler-broker
5. Mount your external catalog, with downloaded plugin and run command dependend of your version:
xs install SAPDW<version>.ZIP
6. After succesfull instalation you should see similar confirmation:
7. For now you only need to enable plugin in SAP WEB IDE, go to
https://hxehost:53075/
Login as XSA_DEV, with your master password.
8. Click on rack icon on the left panel (3 icon from the top), and go to Features. Find SAP Hana Data Warehousing foundation, click “ON” and then “Save”.
Voilla ! Eveything is ready for now. You can test DWF by yourself, I recomend offical tutorials like:
No comments:
Post a Comment