SAP HANA Cloud Provisioning, Administration and Monitoring

Identify the three SAP HANA Cloud access options: enterprise, free trial, and HANA Cloud trial. Learn how regional URLs differ and why the course uses the HANA Cloud trial URL.

Learn how to create a free SAP HANA Cloud trial account, including registering, activating via email, selecting a data center, and navigating the SAP BTP cockpit with Hana Cloud entitlements.

Explore SAP HANA cloud provisioning and administration tools in BTP, including Cloud Foundry and multi-environment toolsets, and learn to access the cockpit, Data Explorer, and SQL console.

Install the SAP Hana cloud tools in the trial environment, verify entitlements, assign the hana cloud administrator role, and access hana cloud central to provision the database and data lake.

Provision a SAP Hana database and data lake in a trial SAP Hana BTP account, configure memory and vCPUs, and access via SAP Hana cockpit and SAP Hana Database Explorer.

Add instance mapping and adjust the SAP HANA Cloud database configuration by binding the database instance to a specific org ID, enabling decoupling for development in the Business Application Studio.

Add a data lake to your SAP HANA Cloud database to manage files and relational data for analytics on historical or rarely used data.

Create a standalone Hana data lake, configure IP access options, select a relational engine, set resources and backup, then monitor provisioning until ready.

Explore the SAP Hana database explorer to manage a Hana cloud instance, navigate catalogs, run SQL queries, and access diagnostic files and HDI containers for administration.

Add a SAP HANA database instance to the database explorer, configure host and port, and authenticate with your BTP login, noting auto-reconnection and available instance types.

Add and configure a data lake in the Hana database explorer, supplying the relational engine host, port, and instance ID, and retrieving landscape details from the data lake cockpit.

Use the SQL console in SAP Hana Cloud Central to connect to the Hana cloud database or data lake and verify the schema. Check the user and auto commit settings.

Import catalog objects into the SAP HANA cloud database by uploading a tar.gz file exported from the database explorer, with attention to privileges, dependencies, replacement options, and parallel threads.

Import csv data into SAP HANA Cloud by right-clicking import data, enabling header rows, selecting delimiter, mapping columns, and creating a new table, then validating the import of 13 rows.

Learn how to subscribe to the multi-environment SAP Hana Cloud tools, upgrade from Cloud Foundry, and assign the SAP Hana Cloud Administrator role to access the new cockpit.

Start the SAP HANA database using SAP HANA Cloud Central, then verify it is up in about five to six minutes with the Database Explorer and refresh.

Stop the SAP HANA cloud database via Hana Cloud Central or the CLI, including the stop prompt and downtime expectations. Expect a minute of downtime and a connection error afterward.

Upgrade your SAP Hana Cloud database via SAP Hana Cloud Center, review version details and upgrade mode, and plan downtime with a communication plan as the provider handles the process.

Apply a patch to your Hana database via the SAP Hana Cloud Center, guided by a notification showing current and new versions, with a restart, bug fixes, and improvements.

Navigate the SAP HANA Cloud cockpit to monitor, administer, and manage users, exploring default filters, cards, and key KPIs for performance, security, and backups.

Monitor SAP HANA cloud database services to assess health and availability, check service status and alerts, and review memory metrics and CPU trends in the cockpit.

Monitor SAP Hana cockpit performance with the KPI across memory, CPU, and disk usage, using time ranges and presets to analyze present and historical data.

Explore how to monitor table usage in the SAP HANA cockpit, review memory and alert metrics, filter and prioritize top tables, and examine current table distribution and partitioning considerations.

Learn to monitor SQL statements in SAP HANA Cloud to identify performance and memory issues, and use the cockpit's analysis panel for overview, active statements, and plan cache.

Monitor SAP HANA Cloud database sessions to identify active and blocked queries, analyze current statements, and assess metrics like query count, average records fetched, and query time.

Learn to monitor SAP HANA Cloud database threads, identify long-running and blocked threads, and inspect thread status, connections, and statements to optimize performance.

Monitor SAP HANA cloud memory usage by table and component, identify top memory consuming tables, and manage in-memory data through unload and load operations.

Program your expensive statements to understand SQL query performance and resource usage, and configure trace thresholds on CPU time, memory, and duration to categorize and monitor expensive statements.

Use pre-installed sql statements for monitoring your sap hana database. Access the statement library in the hana database explorer, run scripts to view connections, and tailor queries for health checks.

Explore the SAP HANA cloud cockpit alerting framework to proactively monitor database health, manage thresholds, and respond to critical alerts with proposed solutions.

Define and customize alert thresholds in the Hana Cloud cockpit, monitor disk and memory alerts, edit and save thresholds, and use check now to verify against on-premise standards.

Access trace files and view trace and diagnostic files in the cloud cockpit, and generate a full system dump for SAP support.

Explore how SAP HANA Cloud on SAP BTP achieves high availability and disaster recovery. Learn region and availability zone concepts, subaccount associations, and synchronous and asynchronous replication strategies.

Open the SAP Hana cockpit and locate backups with the database backups card. Review complete, log, and catalog backups, noting sizes, destinations, and point-in-time recovery.

Explore recovery concepts in SAP Hana Cloud: perform point-in-time recovery within 15 days via cloud central, or recreate an instance in another availability zone to meet SLAs.

Execute a point-in-time recovery in SAP HANA cloud by restoring the database to a prior UTC timestamp, validating removal of the hotel schema and city table, then reconnecting.

Manage SAP HANA Cloud user security by defining roles, assigning privileges, and administering users and groups with cockpit or SQL.

Explore authentication methods in the SAP Hana Cloud database, including username/password, LDAP, SAML, JWT, X509, and SSL-based SSO, with internal database user mappings and access via ODBC/Jdbc.

Understand the authorization concept in SAP HANA Cloud, detailing system, object, and analytic privileges, and how roles grant access to schemas, objects, and information models through user assignments.

Learn how SAP HANA Cloud roles work, detailing catalog and design time roles, their privileges, ownership and transportability, and how role groups streamline access to schemas and data.

Administrators learn to create standard users and manage access in SAP HANA Cloud via the cockpit, assign default groups and roles, and enforce password changes on first login.

Create and manage user groups in SAP HANA Cloud cockpit, assign users to groups, and tailor password policy, lifetime, inactivity, and failed login limits for secure access.

Grant user access in SAP HANA Cloud by creating roles and privileges, then bind roles to users, controlling authorization to schemas and data with object privileges.

Explore auditing in SAP HANA Cloud to monitor database activities, enforce audit policies, and identify security vulnerabilities through audit trails.

Explore default and custom auditing policies in SAP HANA Cloud Central, configure actions like alter table, and understand the audit trail to monitor and protect audit data.