Skip to Content
Previous

Getting started with SAP HANA Vora Tools

By Vitaliy Rudnytskiy

Getting started with SAP HANA Vora Tools using SQL Editor and Data Browser

You will learn

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

Details


  1. The SAP HANA 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.

  2. SAP HANA Vora, developer edition, on CAL comes with SAP HANA Vora Tools pre-installed. To open the Tools web UI click on Connect in your SAP HANA 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 HANA 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.

    Opening SAP HANA Vora Tools from CAL cockpit

  3. 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.

    Opening SAP HANA Vora Tools from CAL cockpit

  4. 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.

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

    DROP TABLE CUSTOMER_TEXT;
    

    Then create the table and check its content.

    CREATE TABLE CUSTOMER_TEXT
    (LANGU string, CUSTOMER_ID string, TEXT string)
    USING com.sap.spark.vora
    OPTIONS (tableName "CUSTOMER_TEXT", paths "/user/vora/customer_text_data.csv");
    
    SELECT * FROM CUSTOMER_TEXT;
    

    Running statements in SQL Editor

  6. Now open Data Browser tool. You should see all available tables and clicking on CUSTOMER table will open its content. You can explore the data now.

    Browsing data

Next Steps

Updated 09/18/2016

Time to Complete

10 Min.

Beginner

Tags

Prerequisites

Next Steps

Next
Back to top