|
| 1 | +--- |
| 2 | +title: Getting started with SAP HANA Vora Tools |
| 3 | +description: Getting started with SAP HANA Vora Tools using SQL Editor and Data Browser |
| 4 | +tags: [ tutorial>beginner, topic>big-data, products>sap-hana-vora ] |
| 5 | +--- |
| 6 | +## Prerequisites |
| 7 | + - **Proficiency:** Beginner |
| 8 | + - **Tutorials:** [Loading sample data using Apache Zeppelin](http://go.sap.com/developer/tutorials/vora-zeppelin-load-sample-data.html) |
| 9 | + - Understanding basics of Spark |
| 10 | + |
| 11 | +## Next Steps |
| 12 | + - Getting started with SAP HANA Vora Modeler (coming soon), or |
| 13 | + - Select a tutorial from the [Tutorial Navigator](http://go.sap.com/developer/tutorial-navigator.html) or the [Tutorial Catalog](http://go.sap.com/developer/tutorials.html) |
| 14 | + |
| 15 | +## Details |
| 16 | +### You will learn |
| 17 | +You will learn how to start SAP HANA Vora Tools and using two of them: SQL Editor and Data Browser. |
| 18 | + |
| 19 | +### Time to Complete |
| 20 | +**10 Min**. |
| 21 | + |
| 22 | +--- |
| 23 | + |
| 24 | +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. |
| 25 | + |
| 26 | +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`. |
| 27 | + |
| 28 | + >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. |
| 29 | +
|
| 30 | +  |
| 31 | + |
| 32 | +3. Once Vora Tools opens up in a new browser window, check its **Connection Status** is OK before working with any of its tools. |
| 33 | + |
| 34 | + Each tool can be opened from the Home screen, or - alternatively - from shortcut icons on the left. |
| 35 | + |
| 36 | +  |
| 37 | + |
| 38 | +4. First you will work with SQL Editor, so open it by clicking either on a tile `SQL Editor` or on a shortcut. |
| 39 | + |
| 40 | + In order to work with your Vora tables, created using Zeppelin in the previous tutorial, you have to register those tables first: |
| 41 | + ```sql |
| 42 | + REGISTER ALL TABLES using com.sap.spark.vora; |
| 43 | + ``` |
| 44 | + > Spark SQL supports operating on a variety of data sources. Registering a table allows you to run SQL queries over its data. |
| 45 | + |
| 46 | +5. Run the following command to make sure you don’t have the `CUSTOMER_TEXT` table already created on your Vora engine. |
| 47 | + ```sql |
| 48 | + DROP TABLE CUSTOMER_TEXT; |
| 49 | + ``` |
| 50 | + |
| 51 | + Then create the table and check its content. |
| 52 | + ```sql |
| 53 | + CREATE TABLE CUSTOMER_TEXT |
| 54 | + (LANGU string, CUSTOMER_ID string, TEXT string) |
| 55 | + USING com.sap.spark.vora |
| 56 | + OPTIONS (tableName "CUSTOMER_TEXT", paths "/user/vora/customer_text_data.csv"); |
| 57 | +
|
| 58 | + SELECT * FROM CUSTOMER_TEXT; |
| 59 | + ``` |
| 60 | + |
| 61 | +  |
| 62 | + |
| 63 | +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. |
| 64 | + |
| 65 | +  |
| 66 | + |
| 67 | +## Next Steps |
| 68 | + - Getting started with SAP HANA Vora Modeler (coming soon), or |
| 69 | + - Select a tutorial from the [Tutorial Navigator](http://go.sap.com/developer/tutorial-navigator.html) or the [Tutorial Catalog](http://go.sap.com/developer/tutorials.html) |
0 commit comments