Adding a Data Lake to your SAP HANA Cloud Database

In this lesson, you will learn how to attach a SAP HANA data lake instance to the SAP HANA database in your SAP BTP account.

See the following video to know the Business Case for adding an integrated Data Lake.

Use the following path to navigate from the 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 (3) button.
• To manage your SAP HANA databases and data lakes instances select the Manage SAP HANA Cloud (3) button.

The SAP HANA Cloud Central app gives you an overview of all your databases. You are able to see the status of all databases, and can also perform database administration tasks like e.g. start/stop, upgrade, or adding a integrated data lake. The security settings allow you only to see the databases where you have the permissions to access them.

The SAP HANA Cloud Central opens in a new browser tab. This makes it easier to navigate between the SAP HANA Cloud Central and SAP BTP Cockpit.

Press the °°° (2) button to open the Actions Menu for the selected cloud database. From the Actions Menu select the Add Data Lake (3) option.

In the Create Data Lake Instance wizard, you need to specify the Data Lake instance name and Description in the Basics area. You also need to enter and confirm a strong password.

Note

The user HDLADMIN is automatically created and assigned to you for data lake administration tasks.

In the Sizearea of the input screen, you can specify the number of vCPUs for the Compute and Storage nodes. The minimal required number of vCPUs is calculated from the storage size. In the trial and free tier accounts the storage size is fixed, so you have to accept the given number of vCPUs.

Note

In an enterprise SAP BTP account, you can also select the Storage Service Type. You can choose between SAP Native Data Lake files and AWS Elastic File System (EFS). In the trial and free tier account this is fixed to the AWS Elastic File System (EFS) and cannot be changed.

In the Connectionsarea you specify which IP addresses are allowed to connect to your data lake instance. Depending on your need you keep the connections local to the SAP BTP, or only specific IP addresses and ranges of your company or all IP addresses.

Caution

The option Allowing all IP addresses means that your data lake exposes to the whole internet!!