Skip to Content

Explore Data in SAP Vora in SAP Data Hub, Trial Edition

test
0 %
Explore Data in SAP Vora in SAP Data Hub, Trial Edition
Details
// Explore More Tutorials

Explore Data in SAP Vora in SAP Data Hub, Trial Edition

09/23/2019

Explore data in SAP Vora (including profiling) by using SAP Data Hub, trial edition.

You will learn

During this tutorial, you will learn that Metadata Explorer cannot only be used on files (for example stored in AWS S3, Google Cloud Storage or Azure Storage Blob). Metadata Explorer also works on other data stores, in particular SAP Vora.
Please note here in this tutorial GCP refers to Google Cloud platform, AWS refers to Amazon Web Services and Azure refers to Microsoft Azure.


Step 1: Load data into SAP Vora

To be able to profile data in SAP Vora, you first need to load data into SAP Vora. Thereto open the SAP Data Hub App Launchpad via a web browser. To access the SAP Data Hub App Launchpad in AWS or GCP or Azure you need go to the chapters 3.3 and 3.4 as described in the Getting Started with SAP Data Hub, trial edition guide.

Enter DEFAULT as the Tenant, DATAHUB as Username and the password which you have selected during system setup as Password to logon to the Launchpad. The system displays the Application Launchpad page.

picture_01

Navigate to the SAP Vora Tools by clicking on the icon from the launchpad. The system then displays the SAP Vora Tools.

picture_02

Create a new On Disk Relational Table by clicking Create New button. If you don’t see the welcome screen like the one in the above screenshot, click on the + button (highlighted in the screenshot, in upper left corner) and navigate to Create Relational Table on Disk.

picture_03

Enter the following information to create the relational table and then click Next :

Field Value
Name CUSTOMERS
Schema default
Engine Relational Disk
Table Type Data Source
File System GCS (when using Google Cloud Platform) or S3 (when using Amazon Web Services) or WASB (when using Microsoft Azure)
Connection Type Connection Manager
Connection ID CLOUD_STORAGE
File Path file path via Browse button, in our case /Customers.csv

Finally click Finish to create the table.

picture_04

After the table is created, click on the Data Preview button to display the preview of the loaded table data.

picture_05
Log on to answer question
Step 2: Profile table

Go back to the SAP Data Hub Application Launchpad and navigate to Metadata Explorer.

picture_06

From the Metadata Explorer, click on Browse Connections

picture_07

From the connections page, click on VORA and then click on default to display the tables in SAP Vora in schema default.
Based on our example, we select the table CUSTOMERS, which you have created during the previous step.

picture_08

Click on the More Actions(1) button for CUSTOMERS and from the context menu, click on Start Profiling(2). The system indicates that profiling has started. It can take several minutes for profiling to complete.

As soon as the profiling completes, you will see a notification in the top right corner and you will see more details after you click on the icon.

Log on to answer question
Step 3: Display metadata and fact sheet

You can take a look at metadata and fact sheet of the CUSTOMERS table just like you did during the previous tutorial for the files.

Open the fact sheet for CUSTOMERS that you have profiled just now and answer the following questions with the help of the below screenshot :

picture_09
What is the average length of the column FIRST_NAME?
×

Next Steps

Back to top