SAP HANA Cloud and SAP Business Application Studio

philip.mugglestone just added two new video tutorials to the SAP HANA Cloud series about developing SAP HANA database applications using SAP Business Application Studio for the SAP Cloud Platform Cloud Foundry environment..

In this post, you will find the video embedded with some additional information and resources.

What You Learn

You can watch the video tutorial in a little under 30 minutes. What you learn is

How to use the templates and wizards of the SAP Business Application Studio for native SAP HANA application development

How to create design-time artifacts and how to deploy and create database runtime objects

How to perform database modeling including the creation of a simple calculation view

how to configure access from a HDI Container to a standard schema

For an introduction to the SAP HANA Deployment Infrastructure (HDI), see our previous post

HDI with SAP HANA Cloud

Documentation

For the documentation, see

SAP HANA Cloud Developer Guide for Cloud Foundry Multitarget Applications (SAP Business App Studio)

SAP HANA Cloud Modeling Guide for SAP Business Application Studio

For more information about SAP Business Application Studio, see

SAP Business Application Studio | SAP Discovery Center

SAP Business Application Studio | SAP Community

SAP Business Application Studio (BAS) – the evolution of SAP Web IDE

Code Samples on GitHub

As we know your time is precious, you can find the code snippet on our GitHub repository

travel.txt

Video Tutorials

Develop Apps

In the first tutorial we learn how to develop database applications based on HDI containers using SAP Business Application Studio. How to perform database modeling including the creation of a simple calculation view is also covered.

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

0:00 - Introduction and SAP Business Application Studio subscriptions

1:00 - Create Dev Space, open Workspace, and target the Cloud Foundry Org and Space

2:00 - Create Project from the SAP HANA Database Project template

3:45 - SAP Cloud Platform cockpit | Service Instances: HDI

4:40 - SAP HANA Projects with database connections to SAP HANA database explorer

5:30 - Create SAP HANA database artifact hdbtable using code sample

7:00 - Deploy artifact(s)

8:00 - Insert data

8:15 - Create calculation view

10:15 - Deploy

11:15 - Build and deploy MTA project

Access Schema from HDI Container

In the second tutorial we learn how to configure access from a HDI Container to a standard schema. Doing this enables visual database modeling of objects in the standard schema and is a prerequisite for access from SAP Analytics Cloud via the HANA Analytics Adapter.

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

0:00 - Introduction, HDI, and user-defined service

1:30 - Create technical user SAP HANA database explorer using code sample

3:30 - Create user-provided service (UPS) using code sample

5:00 - Create new SAP HANA Database project with HDI container

6:15 - Add UPS to mta.yaml

7:30 - Bind UPS to schema

8:00 - Create database artifact Grant (hdbgrants) using code sample

9:00 - Create database artifact synonym (hdbsynonym) using code sample

10:00 - Create database artifact role (hdbrole) using code sample

11:00 - Deploy

12:00 - Create calculation view

15:15 - Deploy

16:15 - Build and deploy MTA project

SAP HANA Native Application Dev Space extensions

The following extensions are included in the SAP HANA Native Application Dev Space bundle

SAP HANA Calculation View Editor

SAP HANA Database Explorer

SAP HANA Tools

MTA Tools

SAP HANA Project Template

Project from template proposes to create a new HDI service instance using the default database instance of the CF space. Assumes an SAP HANA Cloud instance is created and running.

Create SAP HANA Database Artifact

Use a wizard to create a design-time artifact (code) which will be deployed a runtime database object in the associated HDI container.

Deploy Artifact(s)

Deploy your artifacts bundled or one at a time.

Create Calculation View

Using the same wizard we can create calculation views (hdbcalculationview).

GUI Editor

For several artifacts like synonyms and roles a UI is available in addition to the code editor.

SAP HANA Database Explorer

The SAP HANA database explorer is easily accessible from the SAP Business Application Studio to view the runtime objects with data inside the HDI container.

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

LinkedIn > linkedin.com/in/dvankempen

Twitter > @dvankempen

For the author page of SAP PRESS, visit

Denys van Kempen

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.

Good Reads (my two cents)

For the SAP HANA Cloud e-bite, see

Introducing SAP HANA Cloud