In this CodeLab we will launch a new instance of SAP HANA, express edition with XS Advanced, the application development platform for SAP HANA based on Cloud Foundry. We will also securely deploy the Open Source query tool, SQLPad, on Google App Engine, and connect it to SAP HANA.
SAP HANA, express edition with XS Advanced must be deployed into a Google Cloud Platform project.
Click the "Select a project" button in the Google Cloud Platform Console header:
Choose your project from the list:
Cloud Launcher allows us to launch software on automated infrastructure. We can use it to launch SAP HANA, express edition with XS Advanced. In Cloud Launcher this is known as SAP HANA, express edition (server + applications). The Launcher will create the appropriate virtual machine, disk, and network configuration.
Use the search bar in Google Cloud Platform Console to easily get started. Search for "SAP HANA Launcher" and choose "SAP HANA, express edition (server + applications)" from the list:
This will give us cost estimates and information about what we're going to launch. Choose SAP HANA, express edition (server + applications) and click "Launch on Compute Engine":
Fill in the form and make the right choices for your deployment model. The most important choices are:
Click "Deploy" and watch Cloud Launcher complete the SAP HANA, express edition (server + applications) deployment.
SSH into your new SAP HANA, express edition (server + applications) instance by clicking the SSH button when the launcher is complete:
A new window will open with an SSH connection to your new SAP HANA, express edition (server + applications) virtual machine. Once you're connected, use the following command to get the installation script started:
sudo su - hxeadm
You will be prompted to create a new master password. For temporary instances to be used during events, use the following password:
This password will be applied to all of the default users created during installation, including the database administration users.
Follow the prompts to complete the setup process.
Wait until the command prompt is available again. You can follow its progress by running the following command in the terminal:
watch cat /usr/sap/HXE/home/xsa_config_status
Wait until the status switches from in progress to success:
Press Ctrl+C to return to the terminal.
The instance is now ready to be used. Several administration users have been created:
SYSTEMto perform database administration tasks
XSA_DEVto log in to SAP Web IDE for SAP HANA as a developer
XSA_ADMINto perform administration tasks in for Extended Application Services, advanced model (XS Advanced) platform
Navigate to your virtual machine instances in Google Cloud Compute Engine:
Note the External IP for your SAP HANA, express edition with XS Advanced instance:
We will use this IP address in future steps to connect to SAP HANA, express edition with XS Advanced.
You can perform administrative tasks on SAP HANA XS Advanced using the command line.
To log in directly as the admin, XSA_ADMIN, the following command is available only from the command line in the server:
While you are here, execute the following two command to enable XSA
xs enable-tenant-database HXE
Use the following command to map the development space to the tenant database
xs map-tenant-database -o HANAExpress -s development HXE
Make sure both commands are successful.
For example, to find out the URL for the SAP Web IDE for SAP HANA and the status of the application run the following command:
xs apps | grep webide
Here's example output:
You can use user XSA_DEV to connect to SAP Web IDE for SAP HANA. This will only work if you have renamed the hosts file. If you cannot or do not have permissions to rename the hosts file in the computer you are using to access the XS Advanced applications, you can complete the next step.
Open https://hxehost:53075 (or https://YOUR_IP_ADDRESS:53075, if you have renamed the XS Advanced domain) in a browser (preferably, Chrome in incognito mode). Log in as XSA_DEV and use the master password you set up during the configuration of the VM:
Click on the icon for Database explorer
Use the following parameters to connect to the tenant database:
Once the database is added, you can use the SQL console to perform the rest of the exercises. Use the + sign to connect as a new user