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 done either in SAP HANA Cloud Database Explorer - referred to as DBX, or Business Application Studio - referred to as BAS.

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.

SAP Business Application Studio (BAS) is a cloud-based professional developer tool for building applications and extending SAP solutions.

Logging into Database Explorer (DBX)

1. Open the SAP HANA Database Explorer URL

   Lobby

2. Select Sign in to another account

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

4. Enter the following:

   User ID:

   Password: Provided by registration e-mail

Then select Continue.

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 separate, 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. Select 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 selecting the green Run icon or by pressing the F8 function key.

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960
-- 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");

-- SDI Replication Target (RT_) table
CREATE COLUMN TABLE RT_CUSTOMERS(
	CUSTOMER_ID NVARCHAR(50),
	CUSTOMER_LASTNAME NVARCHAR(50),
	CUSTOMER_FIRSTNAME NVARCHAR(50),
	CUSTOMER_SEX NVARCHAR(50),
	CUSTOMER_BIRTHDAY NVARCHAR(50),
	CUSTOMER_COUNTRY NVARCHAR(50),
	CUSTOMER_REGION NVARCHAR(50),
	CUSTOMER_REGIONNAME NVARCHAR(50),
	CUSTOMER_POSTCODE NVARCHAR(50),
	CUSTOMER_CITY NVARCHAR(50),
	CUSTOMER_STREET NVARCHAR(50),
	CUSTOMER_HOUSENUMBER NVARCHAR(50),
	CUSTOMER_LATITUDE NVARCHAR(50),
	CUSTOMER_LONGITUDE NVARCHAR(50),
	CUSTOMER_EMAIL NVARCHAR(50),
	CUSTOMER_PHONE NVARCHAR(50)
)
UNLOAD PRIORITY 5 AUTO MERGE;

-- FlowGraph Data Transformation target table
CREATE COLUMN TABLE FGT_DE_HE_CUSTOMERS(
	CUSTOMER_ID NVARCHAR(50),
	CUSTOMER_LASTNAME NVARCHAR(50),
	CUSTOMER_FIRSTNAME NVARCHAR(50),
	CUSTOMER_SEX NVARCHAR(50),
	CUSTOMER_BIRTHDAY NVARCHAR(50),
	CUSTOMER_COUNTRY NVARCHAR(50),
	CUSTOMER_REGION NVARCHAR(50),
	CUSTOMER_REGIONNAME NVARCHAR(50),
	CUSTOMER_POSTCODE INTEGER,
	CUSTOMER_CITY NVARCHAR(50),
	CUSTOMER_STREET NVARCHAR(50),
	CUSTOMER_HOUSENUMBER NVARCHAR(50),
	CUSTOMER_LATITUDE REAL,
	CUSTOMER_LONGITUDE REAL,
	CUSTOMER_EMAIL NVARCHAR(50),
	CUSTOMER_PHONE NVARCHAR(50)
)
UNLOAD PRIORITY 5 AUTO MERGE;

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.