SAP HANA Cloud Onboarding Guide Module 03 - SAP HANA Cloud, data lake
This guide was created to give an overview of SAPHANA Cloud, data lake to database administrators and developers. Download the Document
This guide was created to give an overview of SAPHANA Cloud, data lake to database administrators and developers. SAP HANA Cloud, SAP HANA Datalake
SAP HANA Cloud
Onboarding Guide
Module 3
SAP HANA Cloud
Onboarding Guide
Module 3
Get Started
OVERVIEWOF SAPHANACLOUD,DATA LAKE 4
MANAGED OR STANDALONE 5
SIZING 6
DEMO 6
MOVING TO THE CLOUD 7
IMPORTANT RESOURCE 7
WRAP UP 7
SECURITY IN SAP HANA CLOUD, DATA LAKE 9
USER MANAGEMENT IN DATA LAKE RELATIONAL ENGINE 9
DATA CONFIDENTIALITY IN DATA LAKE RELATIONAL ENGINE 10
DATA SECURITY IN DATA LAKE RELATIONAL ENGINE 10
DATA PROTECTION AND PRIVACY IN DATA LAKE RELATIONAL ENGINE 10
COLUMN ENCRYPTION IN DATA LAKE RELATIONAL ENGINE 11
WRAP UP 12
THE DIFFERENCE BETWEEN SAP IQ ON-PREMISES AND THE DATA LAKE IN SAP HANA
CLOUD 13
WRAP UP 15
PROVISION A STANDALONE SAP HANA CLOUD, DATA LAKE 16
PROVISIONING WITH SAP HANA CLOUD CENTRAL 16
PROVISIONING WITH THE CLOUD FOUNDRY COMMAND LINE INTERFACE (CLI) TOOL 21
WRAP UP 21
ACCESSING SAP HANA CLOUD, DATA LAKE 22
CONNECTION TOOLS OVERVIEW 23
CONNECTING TO YOUR STANDALONE DATA LAKE USING SAP HANA DATABASE EXPLORER 23
ISQL 23
DBINFO 24
DBPING 26
IQDSN 26
ACCESS AN SAP HANA CLOUD , DATA LAKE USING DBISQL 28
CONNECT TO AN INSTANCE THROUGH INTERACTIVE SQL (DBISQL ) 30
CONNECTING FROM THE COMMAND LINE 34
WRAP UP 36
USERS, ROLES, AND PERMISSIONS IN SAP HANA CLOUD, DATA LAKE 37
ROLES AND PRIVILEGES 37
HDLADMIN 38
LOGIN MANAGEMENT 38
CREATING USERS AND GRANTING ROLES AND PRIVILEGES 38
WRAP UP 39
MONITORING OF SAP HANA CLOUD, DATA LAKE 40
OVERVIEWOF SAPHANACLOUD,DATA LAKE 4
MANAGED OR STANDALONE 5
SIZING 6
DEMO 6
MOVING TO THE CLOUD 7
IMPORTANT RESOURCE 7
WRAP UP 7
SECURITY IN SAP HANA CLOUD, DATA LAKE 9
USER MANAGEMENT IN DATA LAKE RELATIONAL ENGINE 9
DATA CONFIDENTIALITY IN DATA LAKE RELATIONAL ENGINE 10
DATA SECURITY IN DATA LAKE RELATIONAL ENGINE 10
DATA PROTECTION AND PRIVACY IN DATA LAKE RELATIONAL ENGINE 10
COLUMN ENCRYPTION IN DATA LAKE RELATIONAL ENGINE 11
WRAP UP 12
THE DIFFERENCE BETWEEN SAP IQ ON-PREMISES AND THE DATA LAKE IN SAP HANA
CLOUD 13
WRAP UP 15
PROVISION A STANDALONE SAP HANA CLOUD, DATA LAKE 16
PROVISIONING WITH SAP HANA CLOUD CENTRAL 16
PROVISIONING WITH THE CLOUD FOUNDRY COMMAND LINE INTERFACE (CLI) TOOL 21
WRAP UP 21
ACCESSING SAP HANA CLOUD, DATA LAKE 22
CONNECTION TOOLS OVERVIEW 23
CONNECTING TO YOUR STANDALONE DATA LAKE USING SAP HANA DATABASE EXPLORER 23
ISQL 23
DBINFO 24
DBPING 26
IQDSN 26
ACCESS AN SAP HANA CLOUD , DATA LAKE USING DBISQL 28
CONNECT TO AN INSTANCE THROUGH INTERACTIVE SQL (DBISQL ) 30
CONNECTING FROM THE COMMAND LINE 34
WRAP UP 36
USERS, ROLES, AND PERMISSIONS IN SAP HANA CLOUD, DATA LAKE 37
ROLES AND PRIVILEGES 37
HDLADMIN 38
LOGIN MANAGEMENT 38
CREATING USERS AND GRANTING ROLES AND PRIVILEGES 38
WRAP UP 39
MONITORING OF SAP HANA CLOUD, DATA LAKE 40
© 2025 SAP SE or an SAP affiliate company. All rights reserved. See Legal Notice on www.sap.com/legal-notice for use terms, disclaimers, disclosures, or restrictions related to this material. 3 / 52
MONITORING WITH SAP HANA CLOUD CENTRAL 40
MONITORING VIEWS 41
SECURITY 41
WORKLOAD MONITORING 42
S PACE C ONSUMPTION 43
MEMORY USAGE 45
STORAGE AT CAPACITY 45
MONITORING VIEWS VS . SP _IQSYSMON 45
MONITORING CHANGES IN PERFORMANCE 45
USE CASE EXAMPLES 46
MONITORING VIEWS USING INTERACTIVE SQL 46
WRAP UP 48
BACKUP AND RECOVERY OF SAP HANA CLOUD, DATA LAKE 49
DATABASE BACKUP 49
DATABASE BACKUP SCHEDULE 49
DATABASE RECOVERY 50
SERVICE REQUESTS 51
WRAP UP 51
THAT’S IT FOR MODULE 3! 52
MONITORING WITH SAP HANA CLOUD CENTRAL 40
MONITORING VIEWS 41
SECURITY 41
WORKLOAD MONITORING 42
S PACE C ONSUMPTION 43
MEMORY USAGE 45
STORAGE AT CAPACITY 45
MONITORING VIEWS VS . SP _IQSYSMON 45
MONITORING CHANGES IN PERFORMANCE 45
USE CASE EXAMPLES 46
MONITORING VIEWS USING INTERACTIVE SQL 46
WRAP UP 48
BACKUP AND RECOVERY OF SAP HANA CLOUD, DATA LAKE 49
DATABASE BACKUP 49
DATABASE BACKUP SCHEDULE 49
DATABASE RECOVERY 50
SERVICE REQUESTS 51
WRAP UP 51
THAT’S IT FOR MODULE 3! 52