Technology Blogs by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
cancel
Showing results for 
Search instead for 
Did you mean: 
dvankempen
Product and Topic Expert
Product and Topic Expert






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. SAP HANA Cloud and SAP Business Application Studio

  4. HDI with SAP HANA Cloud

  5. SAP Analysis for Microsoft Office and SAP HANA Cloud

  6. Cloud Foundry Advanced (space travel, multiple instances, defining schema names)

  7. SAP HANA Cloud, JWT Provider, and Certificate Collection with Purpose JWT

  8. Data masking and data anonymization

  9. Predictive Analysis Library (PAL) and Automated Predictive Library (APL)

  10. Remote data sources and virtual tables

  11. OData with SAP HANA Cloud

  12. SAP HANA Cloud Graph

  13. Role Attributes

  14. SAP HANA Cloud and Smart Data Integration


For more information about the free trial, see

For the new features overview posts, see

For more partner-focused hands-on developer series, see

Questions? Post as comment.

Useful? Give us a like and share on social media.

Thanks!



Hands-On Video Tutorials 1-7


philip.mugglestone just published a video tutorial series about getting started with SAP HANA Cloud. In this post, 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 BTP 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 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.



Overview


In this video tutorial, Philip Mugglestone provides an overview of the video series for SAP HANA Cloud including documentation, high level architecture and what's covered in subsequent videos in this series.

https://youtu.be/iIY2PDVj-g4?list=PLkzo92owKnVzONfsNdQNmpPQvUT54UUAL

Markers


0:20 Documentation

0:45 Getting Started Guide

2:10 Migration Guide

3:06 Administration Guide

4:00 Roadmap Explorer

4:25 SAP HANA Cloud Central

4:55 Code snippets on GitHub


Provision Instance


In this video tutorial, Philip Mugglestone shows how to provision an instance of SAP HANA Cloud. Creation of a suitable subaccount, setting entitlements, use of SAP HANA Cloud Central, subsequent instance mapping and how to access the SAP HANA Cockpit and Database Explorer are also covered.

https://youtu.be/q8t6VR4h0r8?list=PLkzo92owKnVzONfsNdQNmpPQvUT54UUAL

Markers


0:20 Review Global Account Entitlements

1:00 SAP Discovery Center

1:35 Create subaccount

1:55 Assign Entitlements

2:45 Subscribe to SAP HANA Cloud Central

3:50 Create instance of SAP HANA Cloud

7:55 Actions

9:52 Configure instance mapping to Cloud Foundry runtime

11:20 SAP BTP CLI


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.

https://youtu.be/4y_R3Oyj9uM?list=PLkzo92owKnVzONfsNdQNmpPQvUT54UUAL
Tutorial 3 - Service Plans

For the documentation, see


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

https://youtu.be/waTp-Q0Xkdc?list=PLkzo92owKnVzONfsNdQNmpPQvUT54UUAL
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


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"

 

https://youtu.be/zm7n_0KxWcI?list=PLkzo92owKnVzONfsNdQNmpPQvUT54UUAL

 
Tutorial 5


Connecting with Node.js


Download SAP Development Tools - JDBC


Query.java


Python


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. 

https://youtu.be/viGVM672B7Q?list=PLkzo92owKnVzONfsNdQNmpPQvUT54UUAL
Tutorial 6


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


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

https://youtu.be/e2Kt2uKnTyM?list=PLkzo92owKnVzONfsNdQNmpPQvUT54UUAL
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)


Share and Connect


Questions? Please post as comment.

Useful? Give us a like and share on social media.

Thanks!

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

For the author page of SAP PRESS, visit







Over the years, for the SAP HANA Academy, SAP’s Partner Innovation Lab, and à titre personnel, I have written a little over 300 posts here for the SAP Community. Some articles only reached a few readers. Others attracted quite a few more.For your reading pleasure and convenience, here is a curated list of posts which somehow managed to pass the 10k-view mile stone and, as sign of current interest, still tickle the counters each month.


 
1 Comment