Monday, 29 August 2016

Vora 1.2 Modeling Tool

SAP HANA Vora provides an in-memory processing engine which can scale up to thousands of nodes, both on premise and in cloud. Vora fits into the Hadoop Ecosystem and extends the Spark execution framework.

Following image shows you where Hadoop fits in the Hadoop ecosystem:

Vora 1.2 Modeling Tool

Recently, Vora 1.2 has been released with the following new features:
  • Support for MapR Hadoop distribution
  • Vora modeler – for building data models on top including OLAP
  • Added features to Hierarchies
  • Dlog, Discovery services using Consul tool
  • Enhanced performance through partitioning and co-located joins


Vora 1.2 Modeling Tool:


We also designed the Vora modeling tool (modeler) to facilitate the development across structured, unstructured and semi-structured data and has been released as a beta version with Vora 1.2 .With Vora modeler you have access to SQL editor and also the Modeler perspective which give you the option to code or drag and drop the artifacts to develop your data view.
By installing the Vora Tools as part of the Vora 1.2 installation, you will have access to Vora modeler through your browser and via the port 9225:

http://<DNS_NAME_OF_JUMPBOX_NODE>:9225

Here is how your modeling home page should look like. This page will give you access to the main perspectives, connection feature and help.

Vora 1.2 Modeling Tool

Vora Modeling has three main perspectives:
  • Data Browser
  • SQL Editor
  • Modeler

Data Browser allows you to view the available tables, views, dimensions and cubes in Vora engine. It also allows you to have a preview of the data, download the data as a CSV file, filter the columns and refresh them.

Here is a view of your Data Browser:

Vora 1.2 Modeling Tool

SQL Editor perspective allows you to run the queries on Vora engine using Vora SQL, it also shows you the compilation warnings, errors and outputs and the result of the query when you run the select.

Vora 1.2 Modeling Tool


The Modeler perspective could be used to create SQL views, Dimensions or Cubes. You could also use the subselect artifact to create the nested queries. Below you could see a view of the Modeler:

Vora 1.2 Modeling Tool

Source: scn.sap.com