SAP HANA VORA is a distributed computing engine which democratizes your data access from your enterprise relational data stored in your HANA machines or your scraped data collected from web and in hdfs format and bring them together in one platform, giving you the capability to work across them seamlessly.
In SAP HANA VORA 1.3 we have introduced you to different engines for different data models such as Graph engine, Time Series, Document Store, Disk Store and of course the relational engine. For more information on the new capabilities of Vora 1.3 and specifics on new engines please refer to the blogs written by my colleagues Balaji Krishna and Jason Hinsperger.
The focus of this blog is on various capabilities offered by SAP HANA Vora 1.3 Data Modeler, a web graphical user interface(Web GUI) which facilitates your communications with Vora engines.
To use Vora modeler, no extra installation is required. After the Vora installation, find the DNS of the jump-box where you have installed Vora Tools component. In the below picture, a view of my Vora Cluster Manager is shown, where I have accessed the node assignment perspective for my Vora Tools and the green arrow shows you the DNS address which you need to access the web GUI.
Now open your Google Chrome browser and type http://<DNS.OF.YOUR.VORATOOLS>:9225 in URL windows as it’s shown below and then press enter to navigate to Vora Modeler.
In 1.3 version you can define and limit the users that can access your modeler, using the “User Management” perspective where you can give access to a user by adding the user or editing the password or deleting the user:
Here you can see the Home Page of Vora modeler once you logged in:
As you can see in the above screen shot, Vora 1.3 has other perspectives such as Data Browser, SQL Editor and Modeler. You can reach any of these perspectives either by clicking on the views in the Home Page or the shortcuts on the left hand side of the Home Page.
Data Browser is a perspective which allows you to browse through the relations you have in the Vora engine such as your tables and views, getting an overview of the first 1000 rows of your data, filter the viewable columns, sort or even download your data as a CSV file. You can also search to find your aimed column or relation. A new feature which is added to 1.3 is that you can right-click on the name of your relation and register it to your current workspace (current sql context) or delete it from your Vora catalogue.
SQL Editor allows you to communicate with Vora engines using the Vora SQL. Please note, in order to code in SQL Editor you don’t need to wrap your code in Python, Scala or even Spark SQL and can directly code in Vora SQL. However, to communicate with Time Series, Document Store, Disk Store and Graph engines, you need to have your syntax wrapped in double backticks ( `, ascii 0x60 ).
This perspective, also gives you access to Token Tooltips and Interpreter’s results and complaints. In order to use the code completion feature click on CTRL+SPACEBAR.
A view of SQL Editor perspective and the usage of double back quotes is shown in the below picture:
Modeler perspective gives you access to new developed wizards to create tables and views not only in the relational engine but also in Vora Time Series, Vora Document Store and Disk Store (Disk-to-Memory accelerator) and from different types of data such as CSV, ORC and Parquet. It also connects to your HANA machine and allows your to get access to your HANA data in Vora catalogue.
Via the Modeler perspective you can also add annotations and aggregations to columns,Join and easily create unions between relations, use the new advanced Toolkit, build Hierarchies (both Parent-Child and Level types) and even develop your OLAP model by creating the dimensions and cubes.
Below you can see a view of the modeler perspective and a few of its new features such as using the new wizards to create different Tables and Views:
Preview data in Modeler perspective:
This is was a short introduction to the new Vora Data Modeler Tool. For more information please refer to Developer’s Guide, Chapter 12: Working With SAP HANA VORA Tools.
Please refer here, to access a webcast on Vora Modeler 1.3 where I show you how to use the new features with Modeler.