Skip to Content

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

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

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

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.


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


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.


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

Field Value
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
File Path file path via Browse button, in our case /Customers.csv

Finally click Finish to create the table.


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

Log on to answer question
Step 2: Profile table

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


From the Metadata Explorer, click on Browse Connections


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.


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 :

What is the average length of the column FIRST_NAME?

Next Steps

Back to top