Skip to Content
Technical Articles

Getting Started with SAP HANA Cloud | Basics

With this blog series we provide an update with the latest information on getting started with SAP HANA Cloud on the SAP Cloud Platform.

  1. About SAP HANA Cloud
  2. SAP HANA Cloud Getting Started
  3. Connecting SAP Analytics Cloud using the HANA Analytics Adapter (HAA)
  4. Cloud Foundry Advanced (space travel, multiple instances, defining schema names)
  5. Data masking and data anonymization
  6. Predictive Analysis Library (PAL) and Automated Predictive Library (APL)
  7. Remote data sources and virtual tables
  8. SAP Web IDE for HANA Development, SAP Cloud Platform Cloud Foundry environment
  9. SAP HANA Cloud and Smart Data Integration
  10. OData with SAP HANA Cloud
  11. HDI with SAP HANA Cloud

For the latest features blog (Oct 2020), see

For more information about the free trial, see

Questions? Post as comment.

Useful? Give a like and share on social media. Thanks!

/wp-content/uploads/2016/02/sapnwabline_885687.png

Hands-On Video Tutorials 1-7

Philip MUGGLESTONE just published a video tutorial series about getting started with SAP HANA Cloud. In this blog, you will find the videos embedded with some additional information and resources. Following along you will learn how to create an instance of SAP HANA Cloud, how to configure and do some basic administration, and more specifically, how to develop with SAP HANA in the cloud.

You can watch the six video tutorials in a little under an hour. What you get back is

  • how to use the SAP Cloud Platform Cockpit to create an SAP HANA Cloud instance
  • how to enable, restrict, or prevent client access
  • how to start and stop an instance
  • how to administer the instance using the SAP HANA Cockpit
  • how to use the Database Explorer and its SQL Console for development and modeling
  • how to access the instance using different client tools like Node.js, Python, Java, ODBC
  • how to join data in-memory (hot store) with data in the data lake (cold store)
  • how to build a calculation view using the SAP Web IDE Full Stack using SAP HANA schemas and HDI containers

To bookmark the playlist on YouTube, go to > SAP HANA Cloud

Because we know your time is precious, we have included code snippets so you can easily and merrily code along. For the GitHub repository with sample code, visit > github.com/saphanaacademy/SAPHANACloud

Ready? Let’s jump right in.

/wp-content/uploads/2016/02/sapnwabline_885687.png

Overview

The first video shows where to find the documentation, the most important guides, the high level architecture and what’s covered in subsequent videos in this series.

Tutorial 1

For some additional reading, see

As mentioned in the previous blog, SAP HANA Cloud provides the most significant update of SAP HANA since its initial release in 2010 and we will address this topic in more detail in a future blog.

SAP HANA Cloud provides a single place to access, store, and process all enterprise data in real time. It is a cloud-native platform that offers the power and performance of SAP HANA with full capabilities to manage data storage, virtualization, and run powerful applications.

SAP HANA Cloud high-level architecture

/wp-content/uploads/2016/02/sapnwabline_885687.png

Create an Instance

In the second tutorial, we learn how we can create an instance of SAP HANA Cloud and include an instance for the relational data lake service. For this we need entitlements for SAP HANA Cloud with service assignments for hana, hana-cloud-connections, and relational data lake.

Creating a new SAP HANA Cloud instance is simple:

  1. Provide instance name with the credentials of the super user account DBADMIN
  2. Specify memory, compute, and storage for the instance
  3. Optional: provide the specs for the Data Lake
  4. FIrewall settings: whitelist IPs to keep your environment secure

From the SAP Cloud Platform cockpit we can start and stop the instance and make configuration changes (memory, compute, storage, firewall).

For the documentation, see

If you are new to the SAP Cloud Platform or need a refresher on global accounts, subaccounts, entitlements, service plans, etc., see the playlist

Updated July 14

SAP Cloud Platform Service: SAP HANA Cloud

SAP Cloud Platform Subaccount Entitlements – SAP HANA Cloud

SAP HANA Cloud – Create Instance

/wp-content/uploads/2016/02/sapnwabline_885687.png

Service Plans

In this video tutorial, Philip explains the service plans, the basic concepts of HDI (HANA Deployment Infrastructure), and how we can use this in SAP HANA Cloud. The Develop Apps tutorial video below provides the hands-on.

Tutorial 3 – Service Plans

For the documentation, see

/wp-content/uploads/2016/02/sapnwabline_885687.png

Create Objects and Load Data

In this video tutorial, we learn how we can set up a sample development environment, with a development user, a database schema and how to create and load data into tables in both hot (in-memory) and cold (data lake) storage. Philip also shows how to combine data from different storage areas into a single view. 

For the sample code, go to

For the documentation, see

Tutorial 4

SAP HANA Database Explorer – System Views

SAP HANA Database Explorer – Create Virtual Object(s)

SAP HANA Database Explorer – View combining hot and cold store

/wp-content/uploads/2016/02/sapnwabline_885687.png

Connect Database Clients

In this video tutorial, Philip shows how to connect database clients to SAP HANA Cloud. 

  • For Node.js, we can use npm (npm install @sap/hana-client) and for Python pip (pip install hdbcli)
  • For JDBC you can download the JDBC JAR file from SAP Development Tools (tools.hana.ondemand.com)
  • For all the other supported database clients like ODBC or to use the SAP HANA interactive terminal hdbsql, you need to install  the SAP HANA client. This is also available from the SAP Development Tools website. 

If you need encryption with the SAP CommonCryptoLib (CCL) library, download the SAP HANA client from Downloads on the SAP ONE Support Portal, as this library comes with export restrictions.

For SAP Development Tools, go to 

For the sample code, go to

For the documentation, see

The sample code is similar to the SAP HANA Cloud tutorial on the SAP Developer Center

Connect strings samples
java -jar ngdbc.jar -u <user>,<password> -n <endpoint> -o encrypt=true 
-c "SELECT * FROM travel.budgetrooms";
hdbsql -u <user> -p <password> -n <endpoint> -e 
"SELECT * FROM travel.budgetrooms"

 

 

Tutorial 5

Connecting with Node.js

Download SAP Development Tools – JDBC

Query.java

Python

/wp-content/uploads/2016/02/sapnwabline_885687.png

Bind Apps

In this video tutorial, Philip shows how to create SAP HANA schemas, HDI containers and their service keys using the SAP Cloud Platform Cockpit. This is a requirement for the next video tutorial but not unique to SAP HANA cloud. We will bind the schema and HDI container to an application in the next video. 

Tutorial 6

SAP Cloud Platform Cockpit – Create SAP HANA Schema and HDI Container with Service Keys

/wp-content/uploads/2016/02/sapnwabline_885687.png

7. Develop Apps

In this last video tutorial of this series, we learn how to develop database applications based on HDI containers using SAP Web IDE Full-Stack, including how to perform database modeling with the creation of a simple calculation view. 

Like the previous video, this is not unique to SAP HANA Cloud as such but it is nice to see that everything works. 😉

For the documentation, see

Tutorial 7

SAP Web IDE Full Stack – Create Project for HANA Cloud

SAP Web IDE Full Stack – Calculation View: Design

SAP Web IDE Full Stack – Calculation View: Analysis (runtime)
/wp-content/uploads/2016/02/sapnwabline_885687.png

Learned Something New?  

Post a comment, share on social media, and/or give a like. That’s how the community works. Thanks.

If you would like to receive updates, connect with me on

Best,

Denys van Kempen

/wp-content/uploads/2016/02/sapnwabline_885687.png

 

1 Comment
You must be Logged on to comment or reply to a post.