SAP HANA with Vaadin 8 & Spring Boot

Simple demo-app for using SAP HANA with Vaadin 8 & Spring Boot

This is actually a mash-up from different projects: https://github.com/SAP/cloud-spring-boot-sample - how to use Spring boot with SAP HANA Cloud Platform

https://github.com/spring-guides/gs-crud-with-vaadin - Building a crud with Spring + Vaadin

(+ some eye candy css, for sake of fun)

Prerequisites

1. Create developer account at sap cloudplatform page
2. 
3. After successful registration, login
4. In SAP Cloud Platform Cockpit, create a new database:
   • 
   • Choose: Persistence/Databases & Schemas
   • Click new
   • 
   • Choose db system: HANA MDC, configure User for Shine true
   • Fill out rest to your liking (just remember those passwords :) )
   • Save
   • (Database creation takes quite some time, don't worry)
5. Once database is up, navigate to that db and from that view, click "SAP HANA Web-based Development Workbench"
6. 
7. If you're prompted for username-password use the ones you set in your shine -user
8. Choose "Catalog" (There should be a screen with options: Editor, Catalog, Security, Traces)
9. 
10. Expand Catalog and from under that you should have database (okay, not a db but catalog or schema or whatever) named as the user you made (default user was "shine", I changed that as "test", so my db is named "TEST")
11. 
12. Open SQL -console and create customer table*
13. Get SAP JVM 8, see see https://tools.hana.ondemand.com/#cloud
14. Set your project to use that JVM

You actually don't have to create or use SHINE user. It's just easier to tag that, for it creates a user for database. Plus you get different SHINE test/learning stuff

Customer table

CREATE COLUMN TABLE "TEST"."CUSTOMER"
    ("CUST_UUID" NVARCHAR(36) NOT NULL ,
	 "FIRSTNAME" NVARCHAR(50),
	 "LASTNAME" NVARCHAR(50),
	 "IMG_URL" NVARCHAR(255),
	 PRIMARY KEY ("CUST_UUID"))

Note that the "TEST" must changed with your own shine-user name. It defaulted as "shine", so if it was left as is use "SHINE"....

Running the app

To run local

mvn spring-boot:run -Drun.profiles=dev,standalone

Run in SAP cloud

Build deployable war:

mvn -P neo clean package install

In SAP Cloud Platform Cockpit:

First time:

1. Choose Applications / Java Applications / Deploy Application
2. Choose war-file (in target folder, named sapvaadinspring.war)
3. Run-time Name: Java Web Tomcat 8
4. JVM Version: JRE 8
5. JVM Arguments: -Dspring.profiles.active=neo
6. Deploy (But do not start the application)
7. 
8. Choose you database
9. Choose "Data Source Bindings"
10. 
11. Fill in username and password and save
12. Start your application

If you're only updating (meaning you've done the first time already), then just update your applications by giving a new war-file and restart application.

The application screenshot