Create an SAP HANA Database Project

This project will combine artifacts from an HDI container and a classic, replicated schema.

You will first create a table to hold data from performance evaluations received by employees and the rating they give the company in terms of satisfaction.

These are sample records that will be stored in this table:

1. Right-click on the src folder, choose New File

   

2. Use the following name

   data/performance.hdbtable
   

   

3. This will create both a folder and a file. Paste the following content into the hdbtable file to define a new table:

   column table "PERFORMANCE" (
       "ID" INTEGER  unique not null COMMENT 'Employee ID',
       "EVALUATION_RATING" DOUBLE COMMENT 'Evaluation results',
       "REPORTS_TO" INTEGER not null COMMENT 'Reports to Manager',
       "FEEDBACK_COMMENT" NVARCHAR(512) COMMENT 'Feedback comment',
       "SATISFACTION_INDEX" DOUBLE COMMENT 'Employee given rating',
       PRIMARY KEY ("ID")
   )
   COMMENT 'Performance evaluation record'
   

4. Save the file.

   

What is going on?
 
You have created a database module and a design time artifact representing a table. When this module is deployed, SAP Business Application Studio will automatically create the runtime object (a physical table) in the schema associated to the HDI container.
 
This approach allows you to modify the structure of the table without worrying about underlying adaptation operations.

The table you have just defined will have a large text field with comments from the employees. You want to enable an index to enhance text search.

1. Create a new database artifact under the data folder

   

2. Use the following name

   comment_text
   

   And choose Artifact Type of hdbindex

   

3. Paste the following code into it:

   INDEX "COMMENT_TEXT"
   on "PERFORMANCE"("FEEDBACK_COMMENT")
   

4. Save the file.

For testing and development purposes, you can use a local file to load data into an HDI container.

1. Create the configuration for the upload first. In the data folder, create a file called:

   loads/dataload.hdbtabledata
   

   

2. Paste the following content into it:

   {
       "format_version": 1,
       "imports": [{
   	    "target_table": "PERFORMANCE",
   	    "source_data": {
   		    "data_type": "CSV",
   		    "file_name": "performance.csv",
   		    "has_header": true,
   		    "dialect": "HANA",
   		    "type_config": {
   			    "delimiter": ","
   		    }
   	    }
   	    }]
   }		
   

3. Download this csv file – https://github.com/SAPDocuments/Tutorials/blob/master/tutorials/hana-cloud-create-db-project/performance.csv into your computer. Upload it into the loads folder using the Upload Files option

   

4. Deploy the loads folder

   

1. Press the Open HDI Container icon

   

2. The Database Explorer will open in a new browser tab with your HDI container already selected. Select Tables

   

3. Right-click on the table PERFORMANCE and choose Open Data

   

4. Open the SQL editor for this query

   

5. Execute the following SQL statement to complete the validation below:

   SELECT ROUND(AVG("SATISFACTION_INDEX"),1)
   FROM "PERFORMANCE";