How to Create a SAP HANA Database Instance in SAP BTP

This guide will walk you through the process of creating a SAP HANA Database instance in the SAP Business Technology Platform (BTP). Follow the steps below along with the provided screenshots.

Requirements : SAP BTP Trial Account

Step 1: Access SAP BTP Cockpit

1. Log in to your SAP BTP account.
2. Navigate to the Global Account view where you can see all the directories and subaccounts.
3. Select the trial subaccount (or your specific subaccount) to proceed.

Select sap hana cloud

Create — Sap HANA Database

Step 2: Choose Instance Type

1. Select SAP HANA Database

• In the “Type” section, select SAP HANA Cloud, SAP HANA Database.

Step 3: Configure General Settings

1. Fill in General Details

• Organization: fc89ec26trial
• Space: dev
• Instance Name: HANADB
• Administrator: DBADMIN
• Administrator Password: Set and confirm your desired password.

Step 4: Specify Database Configuration

1. Configure the SAP HANA Database

• Memory: Set to 16 GB
• Storage: Set to 80 GB
• Compute: Set to 1 vCPU

Step 5: Configure Advanced Settings

1. Set IP Address Restrictions

• Select Allow all IP addresses for both the SAP HANA database and the Cloud Connector.

Step 6: Create a Data Lake Instance (Optional)

1. Data Lake Setup

• Name your Data Lake instance (e.g., Testdata).
• The associated SAP HANA Database instance will be displayed.

Step 7: Configure the Data Lake Relational Engine

1. Set Data Lake Relational Engine Parameters

• Coordinator: 2 vCPUs
• Workers: 2 vCPUs
• Storage: 256 GB

Step 8: Finalize Data Lake Advanced Settings

1. Advanced Data Lake Settings

• Set IP address access rules (allow all IP addresses).
• Optionally, configure automatic backups.

Step 9: Review and Create Instances

1. Review Configuration

• Review all your settings in the summary page.
• If everything looks good, click on Create Now.

Step 10: Monitor Instance Creation

1. Monitor the Creation Process

• The instance creation process will start, and you can monitor its progress in the Instances section.

To monitor Hana db;

Open In SAP HANA Cocpit

Here you can review all the details about the DB. Running queries, CPU usage status, etc.

Thanks for reading..