Getting started with SAP Vora Tools

You will learn

You will learn how to start SAP Vora Tools and using two of them: SQL Editor and Data Browser.

The SAP Vora Tools provide a web UI for viewing and exporting data in tables and views, an SQL editor for creating and running SQL scripts, and a modeler for creating data models.

SAP Vora, developer edition, on CAL comes with SAP Vora Tools pre-installed. To open the Tools web UI click on Connect in your SAP Vora instance in CAL, and then Open a link for Application: Vora Web Tools.

The port of Vora Tools web UI has been preconfigured for you in the SAP Vora, developer edition, in CAL. As well its port has been opened as one of the default Access Points. As you might remember it translates into the appropriate inbound rule in the corresponding AWS’s security group.

Once Vora Tools opens up in a new browser window, check its Connection Status is OK before working with any of its tools.

Each tool can be opened from the Home screen, or - alternatively - from shortcut icons on the left.

First you will work with SQL Editor, so open it by clicking either on a tile SQL Editor or on a shortcut.

In order to work with your Vora tables, created using Zeppelin in the previous tutorial, you have to register those tables first:

REGISTER ALL TABLES using com.sap.spark.vora;

Spark SQL supports operating on a variety of data sources. Registering a table allows you to run SQL queries over its data.

Run the following command to make sure you don’t have the CUSTOMER_TEXT table already created on your Vora engine.