You can now create your own SAP HANA, developer edition environment on Amazon Web Services (AWS).
SAP won't charge you anything for the license, but you will be responsible for operating your own AWS account. Together with our friends at Amazon, we have made three different sizes available for you. To get an idea about associated cost, use the AWS pricing calculator here (pre-configured for 4 hours of daily usage on the smallest available size).
These are the image sizes we made available for you:
|Size||Virtual CPU's||Memory (GB)||Storage (GB)|
How to create your own SAP HANA, developer edition environment
- An SCN user - if you don't have one yet, you can register free of charge here.
- An AWS account - if you don't have one yet, you can register here (click "Sign Up Now"). Have your credit card handy.
- A key pair (what is a key pair?) to secure the access to your instance. Find documentation on how to create a key pair here. Remember the provided key name an store the *.pem file on your local hard disk.
- [Note: Make sure to store your *.pem file on your hard drive when prompted. Without the key pair, you will not be able to connect to the OS of your instance via SSH.]
- [Note: key pairs are region-specific. Make sure you create the key pair in the same AWS region you later create your instance in. If you get a ROLLBACK_COMPLETE status after instance creation, it is most likely that your key pair region doesn't match your instance region. In that case, simply create a key pair in the correct region and start the instance creation again]
Watch Yusuf Bashir as he walks you through the key pair creation:
Part 1 - Accept the SAP Developer License Agreement on SCN
Checked all the prerequisites? Then you're ready to create you own SAP HANA, developer edition server on Amazon Web Services. The whole process should not take longer than about 15 minutes.
- Start here. Complete the required profile data and click the "Next" button.
- Enter your AWS User Id and click the "Next" button
- Confirm your data by clicking the "Confirm" button
- Read the license agreement carefully and, if you agree, click the "Accept" button.
- You will be handed over to the AWS cloud provisioning wizard for the next step
Watch Yusuf Bashir (again) walking you through the sign-up procedure:
Part 2 - Create your own SAP HANA, developer edition instance on AWS
- Once you have completed Part 1, the installation process will jump to the AWS website. You will see the next screen. It provides the default stack name and template URL. You can change the name and click the “Continue” button. Don't change the template URL, though.
- Configure instance size which is bundled choice. The bundle choices are listed in the table at the beginning of this document. The recommended option is m2.xlarge which should be sufficient for most. Please note, you can change this later in the AWS console if desired.
- You must provide the name of an existing key pair, or you will not be able to create an ssh connection to your instance. If you have not checked the prerequisites and still need to create a key pair, you can do so in the AWS console. [Note: keypairs are region specific]
- Check your HANA stack information summary, and then click on “Continue”.
- The stack creation takes several minutes. This might be a good time to go back to the SAP HANA Developer Center on SCN to download and install HANA Studio and the HANA Client libraries to your local computer (see Part 3).
- You can monitor progress by selecting the stack name and choosing the events tab in the AWS Management Console. You can refresh the status by clicking the refresh button. Once the stack creation has finished, your screen should look somewhat like this:
- Once the stack has been created and you have CREATE_COMPLETE status, check the output tab for details on AWS instance name, host name and IP address which you will use to connect to your new HANA developer instance.
- If your stack creation fails, check the events tab to get more information on which step failed. Specific information for each step can be seen in the status and reason columns. This should give you an idea about what went wrong and how to correct it.
- Congratulations! You're done with creating your own HANA developer edition image on AWS.
You know and love him by now - Yusuf Bashir shows you how to create your HANA image on AWS:
Part 3 - Download and install SAP HANA Studio and SAP HANA Client
- Again, make sure you are logged in.
- Accept the License Agreement (again, make sure to read it carefully, even though you already know it) and start the download by selecting the archive you want to download and clicking the "I Agree - Download selected file" button.
- Once the archive is completely downloaded, unpack it and run hdbsetup.exe installers.
Part 4 - Connect to your SAP HANA, developer edition server on AWS
- Log on to Amazon EC2 and start your SAP HANA, developer edition instance. In the “Navigation” frame, navigate to “INSTANCES>Instances”. This should show all your instances in Amazon EC2. Make sure the HANA instance you want to connect to is in “running” state. If not, choose the instance, then click on “Instance Actions” menu, and click on “Start” in the pull down menu.
- Associate your Elastic IP with SAP HANA instance and note down the Elastic IP (What is an Elastic IP?). After each restart of our AWS instance, this procedure of mapping elastic IP to HANA instance must be repeated. During the first time the IP address is automatically associated. [Note: The Elastic IP makes sure you can connect to your instance with the same host name / IP address every time it's restarted.]
- To associate your Elastic IP with your SAP HANA Instance
In the “Navigation” frame, navigate to “NETWORK & SECURITY > Elastic IPs”. Check if the IP address is mapped to the HANA Instance, by looking at the “Instance ID” field. If it is already mapped you don’t have to perform any additional steps. Otherwise...
Choose the Elastic IP address that you want to associate to HANA instance.
Click "Associate Address" and in the popup box choose your SAP HANA instance as shown.
Click “Yes, Associate” to confirm association of Elastic IP to HANA instance.
- Note down your Elastic IP address. You will need it to connect to this HANA instance in AWS from HANA Studio.
- Create an entry in your local hosts file (for Windows: C:\Windows\System32\drivers\etc\hosts, for Linux: /etc/hosts), mapping your elastic IP address to the hosts name imdbhdb. You may need to change the folder permissions or use a tool like Notepad++ to be able to edit and save the hosts file.
- [Note: If you do not create this hosts file entry, you will see a yellow status icon in your HANA Studio and a warning message "sapstartsrv not started". Your database will work just fine, but you will be unable to stop/start the instance from HANA Studio.]
- Open SAP HANA Studio and choose either the Administration Console or Modeler perspective.
- In the Navigator Panel, right-click the empty space and choose "Add System..." from the context menu
- In the popup, enter:
- Your Elastic IP or imdbhdb as host name [Note: don't use the Public DNS of your instance, i.e. ec2-xxx-xxx-xxx-xxx.compute-1.amazonaws.com]
- 00 as the Instance Number
- A name for your HANA server as Description
- Click "Next". On the next screen, enter
- SYSTEM as User Name
- manager as Password. You can change the default password later from HANA Studio.
- Click "Finish", wait to the system connection to appear in you Navigator panel with a green status icon and you are officially done!
Part 5 - Set-up SAP HANA Cloud Integration
SAP HANA Cloud Integration enables you to efficiently and securely create and run ETL tasks that move data between on-premise systems and the cloud.
Before beginning, make sure that your HANA database is configured.
- Open SAP HANA Cloud Integration by appending /DSoD to the address of your AWS image. (http://<<fully_qualified_hostname_of_your_instance>>:8080/DSoD)
- Use the pre-defined password and the user name to log in as Organization Administrator (HCI_ADMIN)
- Username - HCI_ADMIN
- Password - Password1
Install and configure the SAP Data Services Agent.
The on-premise SAP Data Services Agent enables you to move data between your on-premise systems and the cloud without opening your firewall to inbound traffic or needing to set up a virtual private network (VPN).
Complete the following steps:
- From the Agents page, click Download Agent Package. The Agent Package contains agents for Windows and Linux operating systems as well as the SAP Data Services Agent Guide. Refer to the Agent Guide for the most up-to-date version.
- Extract the installation package and start the installation program.
- On Windows, run DataServices-Agent-Installer.exe
- On Linux, run DataServices-Agent-Installer.bin
Note: You must run the installation program from a user account that has administrative privileges. On Windows platforms that have User Account Control enabled, you can also choose the Run as administrator option.
For more information, see "Installation" in the SAP Data Services Agent Guide.
- Click New Agent.
- Enter a name and, optionally, a description for the agent and then click Next.
- In step 2 of the wizard, download the Config file.The configuration file is required to finalize the configuration of the SAP Data Services agent.
For more information, see "Configuring the SAP Data Services Agent" in the SAP Data Services Agent Guide.
4. To get started using SAP HANA Cloud Integration, review the information and videos in the Get Started page.
Part 6 - Logon to the Linux OS of your AWS instance
Sometimes you may want to connect to your AWS box on the OS level. For example to change the default password of the hdbadm OS user (see below) or to start/stop your SAP HANA, developer edition server.
The following blog has step by step instructions to connect to Linux Box in Amazon EC2 using the popular ssh client for Window puTTY: http://www.techrepublic.com/blog/datacenter/connect-to-amazon-ec2-with-a-private-key-using-putty-and-pageant/5085
Overview of steps contained in the blog:
- Download putty.exe and puttygen.exe
- From the Key pair (*.pem) file downloaded from Amazon EC2, create a private key file for putty using puttygen.exe
After setting up PuTTY and Pageant:
- Open PuTTY on your computer, and enter the Elastic IP Address for your instance in the Host Name (or IP address) field. Click the 'Open' button.
- When the connection is opened, enter ‘root’ as the user. You can now change the default password for the hdbadm OS user with the command passwd hdbadm. Your new password must be entered twice, and it will be checked to ensure it is sufficiently secure. Once you have entered an appropriate password twice, then you are finished!
From Linux or Mac OS-X, you simply need to run ssh -i hanakey.pem externalIP -l root from a terminal window (with hanakey.pem being your downloaded key pair *.pem file and externalIP being the Elastic IP address or hostname of your instance)
- Some corporate firewalls may not allow SSH to Amazon cloud. You may have to work with your IT organization to resolve this.
- User hdbadm owns sap software in the Linux instance. To restart the database without restarting the entire Linux instance, switch to user hdbadm and perform stop and start operations using the following commands
- su – hdbadm: To switch user
- ./HDB stop: Command to stop HANA DB
- ./HDB start: Command to start HANA DB
- The default password of user hdbadm is HANAabcd1234. You should change this password using the Linux command passwd hdbadm after creating your instance. Enter your new password (described above) when HANA Studio prompts you for the <SID>adm logon to perform administrative tasks.
You will be responsible for operating your AWS account and you will have to pay for the hosting costs. In order to control your costs, we suggest you stop our instance when you are not using it. Starting your instance just takes a few minutes, so you can fire it up when you need it. To stop your instance, find it in the AWS console, right click the instance and choose "Stop" from the context menu. To start it again, choose "Start" from the same context menu.
Be aware that AWS also charges you very little money for stopped instances - if you want to stop using your HANA instance on AWS, and you don't want to pay any more monthly bills, make sure to terminate your instance. It will then be permanently deleted. To terminate your instance, choose "Terminate" from the context menu.
AWS also provides tools to monitor your usage, so there are no surprises when you get your monthly bill - from your "My Account / Console" menu on the top right corner of the screen on http://aws.amazon.com, choose "Account Activity" and you will see your activity for the current month.
Where to get help
If you read your license agreement carefully, you know that the SAP HANA Developer License is free of charge (except your hosting cost on AWS), but comes without SAP product support. In case you any questions, please (1) check our FAQ, (2) seek help on our discussion forum
and should all other options fail, (3) send us an email at firstname.lastname@example.org