[SAP BTP] – HOW TO CREATE SAP HANA DATABASE IN CLOUD FOUNDRY

Hi guys, in this article I want to discuss about How to create SAP HANA Instance in cloud foundry

Prerequisites

Account trial on SAP BTP cockpit

A. Create SAP HANA Database Instances and Data Lake Instances
  • Go to Spaces of Cloud Foundry Environment.
  • Choose SAP HANA Cloud and Click Create => SAP HANA Database
  • Input user and password for database administrator
  • Create Data Lake
  • Create instances processing…
  • All, It’s done.
B. Working with HANA Database
  • Stop/Start database

Because you use trial account, so instances will be automatically stopped overnight. So you need restart before working.

  • Create users and roles and manage privileges

This is dashboard of HANA Database

Go to Security And User Management

Go to Role Management

  • Import Data to Catalog and Query database using SQL Statement

Go to here to download Data Example SFLIGHT for this demo

Go to Database Explorer

  • Choose Browse
  • Choose file which downloaded.

After import done, choose Schema SFLIGHT we have

Open data of table SBOOK, we have

Write some SQL Statement by :

Summary

In this article, I shared How to create instance of SAP HANA Database in CF environment. I also overview about working with objects in HANA database as schema, table, SQL query. Thanks for your reading and any question, kindly leave your comment on below this.

Thanks

Joseph.

2 comments

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.