SAP HANA Cloud Graph

philip.mugglestone recently added four new video tutorials about SAP HANA Graph to the SAP HANA Cloud YouTube playlist of the SAP HANA Academy. In this post, you will find the videos embedded with some additional information and resources.

What You Learn

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

How to create a Graph Workspace

How to work with the SAP HANA database explorer Graph Workspace viewer

How to create GraphScript procedures

How to use GraphScript for neighborhood search

How to traverse graphs and perform graph analysis

How to query data using openCypher

How to work with Graph and HDI containers and MTA

Documentation

For the documentation, visit the SAP Help Portal for SAP HANA Cloud. The Reference includes a GraphScript Cheat Sheet.

SAP HANA Cloud Graph Reference

Appendix C - GraphScript Cheat Sheet

www.opencypher.org

SAP Developer Center Tutorial

For a scripted demo tutorial, see SAP Developers.

Get Started with SAP HANA Graph

Code Samples on GitHub

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

travel_graph.sql | videos 1-3

github.com/saphanaacademy/scpapps | video 4

Additional Resources

Follow the tag for the latest blogs on the topic.

SAP HANA Graph | SAP Community

Video Tutorials

Graph - Create Graph Workspace

In the first tutorial we learn how to use the graph capabilities native to SAP HANA Cloud. Philip provides and introduction to graph in SAP HANA before setting up some example data and showing how to create a graph workspace.

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

0:00 - Introduction, vertices, edges, and attributes

2:35 - SAP HANA Graph Reference

3:10 - Code snippets from GitHub

3:30 - Access the SQL Console of the SAP HANA database explorer for SAP HANA Cloud

4:15 - Execute sample code and review

5:25 - Create Graph Workspace

6:30 - System views

7:40 - View Graph

9:15 - Recap

Graph - GraphScript

In the second tutorial we learn how to use GraphScript to perform graph analysis.

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

0:00 - Introduction and sample scenario

1:20 - GraphScript language and cheat sheet

2:30 - Create GraphScript stored procedure IS_REACHABLE

3:55 - SHORTEST_PATH

6:30 - SHORTEST_PATH Weighted

8:30 - NEIGHBORS

10:00 - Traversing graphs

10:45 - Recap

Graph - openCypher

In the third tutorial we continue our exploration and use openCypher to perform graph analysis against a graph workspace.

https://youtu.be/9uLnNWuB4qY?list=PLkzo92owKnVzONfsNdQNmpPQvUT54UUAL

0:00 - Introduction and support for openCypher

2:00 - Code sample using OPENCYPHER_TABLE

4:55 - Code sample using fuzzy search

5:20 - Code sample using multiple matching

6:45 - Recap

Graph - Multitarget Application

In video tutorial number four, Philip shows the end-to-end process for how to use graph in a multi-target application based on an HDI container for database persistence rather than a classical schema. Setting up example data and creating the graph workspace are explained along with how to adapt the GraphScript and openCypher examples already covered in the previous graph tutorials.

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

0:00 - Introduction

1:00 - Using SAP Business Application Studio and GitHub code sample myappgraph

1:45 - Code walkthrough

8:00 - Build and deploy

8:30 - SAP Cloud Platform cockpit

8:35 - My App Graph

10:50 - Recap

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

yogananda · ‎2020 Dec 29

Interesting to explore denys.kempen

dvankempen · ‎2020 Dec 29

Your feedback is always welcome, Yogananda!

SuhasKoul · ‎2022 Aug 11

Hi denys.kempen ,

I was trying to find some help documentation to connect sap hana graph data to SAC.

Is there any ?

Best Regards

Suhas Koul

dvankempen · ‎2022 Aug 11

Hi Suhas,

Could you elaborate your question?

SAP HANA Graph requires data stored in a database.

We can connect to Analytics Cloud to HANA for reporting and dashboarding (upstream). Using Analytics Cloud as data source for HANA (downstream) would be less typical (if possible).

Are we maybe confusing SAP Graph with SAP HANA Graph here?

For Graph, see

https://blogs.sap.com/2022/02/08/sap-graph-hands-on-video-tutorials/

==

Consider to post your question(s) to the SAP Community forum. The community is monitored 24/7 by the topic area experts both from SAP, its partners, and customers, which also allows for knowledge sharing.

I monitor several tags and try to respond when I can.

Thanks for contributing!

https://answers.sap.com

SuhasKoul · ‎2022 Aug 11

Hi denys.kempen ,

So i was talking about SAP HANA Graph that requires data to be stored in a database.

And what I wish to do is then based on this graph as source some reporting on SAC.

I tried to connect Graph as source to SAP Analytics on cloud with HANA live connection but i could not view this graph.

So my question was Does SAC support HANA graph models?

That is where i was coming from.

Best Regards

Suhas Koul

dvankempen · ‎2022 Aug 12

Response from product management >

SAC can not connect HANA graph models (“Graph Workspaces”) and does not provide viewing/analysis of network data in a generic way.

You can, however, run SAC analysis on vertex and edges tables “underneath” a Graph Workspace and you can run graph processing steps within scripted calculation views.