Technical Articles
SAP HANA Cloud Graph
With this blog series we provide an update with the latest information on getting started with SAP HANA Cloud on the SAP Cloud Platform.
For more information about the free trial, see For the new features overview posts, see Questions? Post as comment. Useful? Give us a like and share on social media. Thanks!
|
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 Developer Center Tutorial
For a scripted demo tutorial, see SAP Developers.
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.
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.
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.
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.
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
|
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. |
For the SAP HANA Cloud e-bite, see
Interesting to explore Denys van Kempen
Your feedback is always welcome, Yogananda!
Hi Denys van Kempen ,
I was trying to find some help documentation to connect sap hana graph data to SAC.
Is there any ?
Best Regards
Suhas Koul
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
==
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
Hi Denys van 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
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.