Getting Started

The SAP HANA Cloud Basic Trial is an introductory tutorial experience for all users. The aim of a Basic Trial is to showcase the functions and features of the application, through a mixture of theory overview and some high-level, practical examples.

Configure the Environment

Each of the modules within this Basic Trial use the same set of tables. These tables contain some generic transactional sales data including details of customers, products, employees as well as review and location data. This data currently resides in a separate, read-only, schema. Before beginning the first module, use the SAP HANA Cloud Database Explorer to copy data to your user’s database schema. Each user has full access to the objects in their own schema.

The hands-on topics are solely done via SAP HANA Cloud Database Explorer - referred to as DBX. The SAP HANA database explorer is a web-based tool for browsing and working with SAP HANA database objects such as tables, views, functions, stored procedures. In addition, DBX can be used to import and export data, execute SQL statements, create remote sources, work with multi-model data such as graph, spatial and JSON collections, debug SQLScript, view trace files, and any other SQL activity.

Logging into Database Explorer (DBX)

1. Open the SAP HANA Database Explorer URL

   Lobby

2. Select Sign into another account

3. Type as the IDP and then select Sign in with alternative identity provider.

4. Enter the following:

   User:

   Password: Provided by registration e-mail

Then press the Continue button.

5. Once logged into the SAP HANA Cloud Database Explorer, the application will prompt to enter credentials. For logging in to SAP HANA Cloud, use the same credentials as in the earlier step.

The SAP HANA Database Explorer is ready:

After successfully logging in to the SAP HANA Cloud Database Explorer, the next step is to copy the data for the exercises.

Create Tables

The tables and data for the exercises are available in a different read-only schema. The first step is to create copies of these tables in the local user schema (specified as ).

By the end of this section the following tables will be created under the schema :

• GX_CUSTOMERS
• GX_EMPLOYEES
• GX_PRODUCTS
• GX_SALES
• GX_WORLD_COUNTRIES
• GX_REVIEWS
• GX_EDGES
• GX_NODES
• GX_TRANSACTIONS

1. Click on the SQL icon in the top left corner of Database Explorer to open a new SQL Console.

2. Copy and paste the following SQL statements and execute them by clicking on the green Run icon or by pressing the F8 function key.

123456789101112131415161718
-- Transactional Tables
CREATE TABLE GX_WORLD_COUNTRIES AS (SELECT * FROM HC_DEV.GX_WORLD_COUNTRIES);
CREATE TABLE GX_CUSTOMERS AS (SELECT * FROM HC_DEV.GX_CUSTOMERS);
CREATE TABLE GX_EMPLOYEES AS (SELECT * FROM HC_DEV.GX_EMPLOYEES);
CREATE TABLE GX_SALES AS (SELECT * FROM HC_DEV.GX_SALES);
CREATE TABLE GX_PRODUCTS AS (SELECT * FROM HC_DEV.GX_PRODUCTS);
CREATE TABLE GX_TRANSACTIONS AS (SELECT * FROM HC_DEV.ORIG_TRANSACTIONS);

-- Document Store Collection
CREATE COLLECTION TABLE GX_REVIEWS;
INSERT INTO GX_REVIEWS (SELECT * FROM HC_DEV.GX_REVIEWS);

-- Graph Nodes and Edges
CREATE TABLE GX_NODES AS (SELECT * FROM HC_DEV.GX_NODES);
CREATE TABLE GX_EDGES AS (SELECT * FROM HC_DEV.GX_EDGES);

ALTER TABLE GX_NODES ADD CONSTRAINT GX_NODES_prim_key PRIMARY KEY ("node_id");
ALTER TABLE GX_EDGES ADD CONSTRAINT GX_EDGES_prim_key PRIMARY KEY ("edge_id");

Now, confirm the details of the tables by selecting them in the Catalog. Navigate to the Catalog section and choose the tables to review.

3. Expand Catalog, navigate to Tables and find the newly created tables.

Congratulations! The data and tools for the exercises are now ready for use. Please keep the DB Explorer window open as you continue through the exercises.