In this lesson, you will learn how to deploy a SAP HANA Cloud database instance in the SAP BTP.
As a database administrator, you want to deploy a SAP HANA Cloud database instance in the BTP trail to explore the SAP HANA Cloud capabilities. Your BI modeling colleagues will use this database to learn how they can build their analytic reports.
SAP HANA Cloud Database
Now that you have created a SAP.com account, and setup a SAP BTP instance most of your time will be spend in the SAP BTP Cockpit. The easiest way to get to the SAP BTP Cockpit is by using a direct link to the SAP BTP Cockpit. Depending if you use a SAP BTP trial or a SAP BTP enterprise account you can use one of the following links:
- Direct link to SAP BTP Cockpit for the trial account: https://account.hanatrial.ondemand.com/trial/#/home/trial/cockpit
- Direct link to SAP BTP Cockpit for the enterprise account: https://account.hana.ondemand.com/cockpit
Use the following path to navigate from the trial SAP BTP Cockpit to the SAP HANA Cloud area:
- On the SAP BTP Cockpit Global Account page, select the trial subaccount in the Subaccounts area. Next on the Subaccount: trial - Overview page, select the dev space in the Spaces area. The breadcrumbs area (1) shows your location in the SAP BTP.
- On the Space: dev - Applications page, in the menu panel select the SAP HANA Cloud (2) button.
On the SAP HANA Cloud overview page you get an overview of the status of all your SAP HANA Cloud, SAP HANA Database instances. In the trial SAP BTP account you can only create one SAP HANA Cloud, SAP HANA Database instance. In an enterprise SAP BTP account the number of database instances depends on your entitlements in the license agreement with SAP.
- To open the SAP HANA Cloud Central where you can create a new SAP HANA Cloud, SAP HANA Database instance select the Manage SAP HANA Cloud (3) button.
Selecting the Create → SAP HANA database option will start the create instance wizard.
The Create Instance Wizard
The Create Instance wizard is a guided procedure that will help you to setup a new SAP HANA Cloud instance. The guided procedure consists of the following 6 steps:
The SAP HANA Cloud Central is the place to provision and manage your SAP HANA Cloud instances. In a new SAP BTP account the SAP HANA Cloud Central is empty, but with the Create (1) button you can start the Create Instance Wizard and deploy your first SAP HANA Cloud instance.
In the step you need to provide the location, instance name, description and the administrator password.
In the (1) Location area you need to fill-in the location space, which is the Cloud Foundry Organization name and the Cloud Foundry Space name. If your company has multiple Organizations and Spaces created for different projects, then select the correct Organization and Space from the drop-down menus.NoteIn the SAP HANA Cloud Trial, the organization and the space were created during the automated setup procedure.
In the Basics area you need to specify the database instance name and description of the SAP HANA database instance you want to create. An instance in SAP HANA Cloud is like a tenant for a on-premise SAP HANA database and isn't restricted to 3 characters.
You also need to specify the password for the database administrator user account DBADMIN that will be created and assigned to your SAP BTP account. The password need to be at least 8 characters long, with one UPPER and two lower case letters and one number.
There is no SYSTEM user available, you need to use the DBADMIN user for the initial setup tasks. The DBAMIN is the "super" user for your SAP HANA Cloud, SAP HANA Database instance. This user shouldn't be used on a daily basis. Create new user accounts and roles for all users accessing the database.
Specify the required RAM and disk storage (1) for this SAP HANA Cloud database instance. The number of vCPUs depends on the amount of RAM you specify.
In the SAP BTP trial account you can't change the size of the memory and disk storage allocated to the database instance. This is limited to 30 GB RAM and 120 GB disk space.
A SAP HANA Cloud, SAP HANA Database instance in an enterprise SAP BTP account can allocate up to 5790 GB RAM, 16000 GB disk space and 440 vCPUs.
See the following video for Create Instance Wizard - Step 4.
Adding additional replicas to your instance incurs additional costs based on the size (CPU, memory, disk) of the replica database. You can use the SAP HANA Cloud Capacity Unit Estimator to estimate the number of capacity units per month required for your particular use case. Link to the SAP HANA Cloud Capacity Unit Estimator: https://hcsizingestimator.cfapps.eu10.hana.ondemand.com/
In the SAP HANA Database Advanced Settings step, you can setup some additional features. In the (1) Allowed Connections area, you can choose which IP addresses are allowed to connect to your SAP HANA Cloud database instance.
The Cloud Connector
You also need to decide whether you want your SAP HANA Cloud, SAP HANA Database to connect to your on-premise remote data sources through the cloud connector.
The Cloud Connector serves as a link between SAP Business Technology Platform (BTP) applications and your on-premise systems. It allows you use your existing on-premise assets without exposing the entire internal landscape to the outside world. It combines an easy setup with a clear configuration of the systems that are exposed to the SAP BTP.
The Cloud Connector runs as on-premise agent in a secured network and acts as a reverse invoke proxy between the on-premise network and SAP BTP. It provides fine-grained control over your On-premise systems and resources that can be accessed by cloud applications. It also allows you control over which cloud applications can use the Cloud Connector.
The Cloud Connector provides the following features for business-critical enterprise scenarios:
- Automatic recovery of broken connections.
- Audit logging of inbound traffic and configuration changes.
- High-availability setup.
In the enterprise SAP BTP account, you can also add a SAP HANA Script server and a SAP HANA Document Store as additional features to the SAP HANA database instance. When adding these features to a SAP HANA database instance may require more vCPUs (compute) and increase your licensing cost.
In the 6th and final step of the Create Instance Wizard you can decide to add an integrated data lake instance to your SAP HANA database instance. This integrated data lake allows you to ingest, store, and analyze high volumes of data, economically and securely. You can access and manage the integrated data lake from your SAP HANA database.
Integrated SAP HANA Data Lake
The Integrated SAP HANA Data Lake gives you the option to store the older and rarely used, but still important, cold data in a data lake controlled by the SAP HANA database instance. This database instance already stores your hot data in memory and the warm data in the SAP HANA Native Storage Extension (NSE). With the addition of a data lake to the SAP HANA Cloud database instance you have access to all your data from one single framework.
The SAP HANA Cloud database instance is being created. Refresh the screen after a few minutes to see the status. After a few minutes the SAP HANA Cloud database instance will be up and running.