How to Create a Database Instance in SAP HANA Cloud

In this SAB HANA cloud tutorial, we are going to learn about how to create a database instance in SAP HANA cloud. This is going to be a step-by-step tutorial on creating a database instance in SAP Hana Cloud.

Prerequisite for creating a database instance in SAP Hana Cloud

To create an instance in SAP HANA Cloud, make sure that a subaccount is created in the global account and that subaccount has space. if not done, then you can follow the tutorial “What is SAP BTP cockpit”.

You can create different instances according to plans or services available in SAB HANA Cloud. So for example, we will create a database instance in SAB HANA Cloud.

Step to Create a Database Instance in SAP HANA Cloud

To create SAB HANA database instances, first, we need to entitle the SAB HANA database services to that subaccount. To entitle the service or plans follow the below steps:

• Click on Entitlements from the navigation bar, and after that click on Configure Entitlements.

After that, click a button appears Add Service Plans, then an Entitlements window launched for adding services to the subaccount.

• From the window click in the search box to search the entitlement SAP HANA Cloud, then on the right side, it shows all the available plans in the SAP HANA Cloud. Make sure to mark all the plans such as hana-cloud-connection, hana, and relational-data-lake.

Also, select the entitlement SAP HANA Schemas & HDI containers, and mark the plans under this entitlement such as hdi-shared, schema.

After adding the plans, save the entitlements by clicking on Save button.

Now navigate to the Cloud Foundry and click on Spaces and select the created space such as hana_space shown in the below picture.

Then select the SAP HANA cloud from the navigation, click on Create at the upper right corner button, and select the SAP HANA database.

When you click on the SAP HANA database, an SAP HANA Cloud Central home page opens. Then select type as SAP HANA Cloud, SAP HANA Database and click on Next Step at the bottom right corner of the page.

Then the next step appears, and you can see that Organization and Space you want have already been chosen. You can choose different options from the drop-down menu if you belong to several different spaces.

• Provide the name for the instance in the Instance Name field under the basics part.
• The Description field allows you to add a description for the instance.
• Then specify the password in the Administrator Password field, and after that again type the password for the Administrator Password Confirmation.
• Click on the Next Step to proceed further setup of the database instance.

Then, you can specify the size of your SAP HANA database on the SAP HANA Cloud in this step of the provisioning wizard.

You would be able to choose the instance starting size here in the production environment. You can decide how much memory this instance will take.

Your SAP HANA database’s in-memory data size is:

• You can choose from 32 GB to 5600 GB of memory on Microsoft Azure. Only 3776 GB might be available in some areas.
• You can choose from 30 GB to 5970 GB of memory on Amazon Web Services. Just 3600 GB might be accessible in some areas.
• The Compute and Storage numbers will automatically change as your memory requirements rise.

You can also increase or decrease the size of memory based on your requirements by clicking on the – and + signs. After setting up the data size, click on the Next Step button at the bottom right corner of the page.

A new page opens for providing the availability zone and replicas for the database. Depending on whether you are using a trial account or free tier model or a production environment, you have access to different instructions.

So click on Next Step because the use of replicas and availability zones is not supported in the trial environment or free tier model.

• Remember that after an instance has been built, the availability zone cannot be changed. Replicas must be deleted and then created again in order to be updated.

Next, the SAP HANA Database Advanced Settings page appears, again this setting will be different for the production environment and free trial, so we will set it up for the trial.

You can now manage the connections that are permitted for the SAP HANA database instance when configuring the Advance setting.

• You can decide whether to permit users from outside the SAB BTP to access your SAP HANA database instance.
• By blocking all IP addresses, you can either restrict access to the SAP BTP or grant access to particular applications by entering one or more IP addresses. Allowing connection from all IP addresses is the last option.

The SAP Cloud Connector, which makes it simpler to connect to SAP HANA database instance to an SAP HANA on-premises database is another option you have. Under Authorized Connections, you can also modify your cloud connector’s connection preferences.

Click on the Next Step button, and a step appears for the managing data lake, where you can choose to enable the data lake but it is optional.

• The data lake will be fully compatible with SAP HANA if you activate it in this step, and provisioning will automatically establish a remote link data lake and the SAP HANA database.
• By clicking on Review and Create, you can bypass this step if you do not want to enable a data lake.

The next step appears for reviewing the creating the instance, so after verifying all the details of the instance click on Create Instance.

You can check their stats to see when your first SAP HANA database is prepared for use. Typically, this procedure takes time. You have finished the step of creating the SAB HANA database instance.

After this, you will see the running instance as shown in the below picture, where you can also manage to start, stop and delete the instance by clicking on the three-dot.

Conclusion

In this SAB HANA cloud tutorial, we learned how to create an SAP HANA database instance, and also learned about the setting or parameters for setting up the instance.

You may also like:

• SAP S/4HANA [Features, Advantages & Disadvantages]