Create a Database Multi-Target Application with SAP HANA service for SAP BTP
Requires Customer/Partner License
January 27, 2021
Beginner
15 min.
Create an application with a database module.
You will learn
- How to create a multi-target application with a database module in SAP Web IDE Full-Stack
- How to create a columnar table using declarative SQL
- How to load data for testing into a columnar table from a CSV file
- How to access the database explorer to browse your tables, data and use SQL statements
Prerequisites
- This tutorial is designed for SAP HANA service for SAP Business Technology Platform. Consider newer tutorials designed for SAP HANA Cloud.
- You have created an instance of SAP HANA service for SAP BTP.
- You are logged in to SAP Web IDE Full Stack and have configured the access to the subaccount in SAP BTP, Cloud Foundry environment.
- You have enabled the
SAP HANA Database Development tools
andSAP HANA Database explorer
in theFeatures
section in the settings for SAP Web IDE. - Optionally, you have downloaded and setup the Command Line Interface for Cloud Foundry.
This tutorial cannot be completed with a trial account.
Step 1: Create a new project from template
Step 2: Create database artifacts
Step 3: Create a text index
Step 4: Build the database module
Step 5: Add data from a local file
Step 6: Check the data