This repository contains the material for the SAP TechEd 2023 session called DA262 - SAP HANA Cloud from an administrator's perspective.
This session introduces attendees to the end-to-end picture of operations required for running the SAP HANA Cloud database, using the Web-based tools SAP HANA Cloud Central and SAP HANA database explorer.
To complete this workshop, you need access to an SAP Business Technology Platform (SAP BTP) account and the SAP HANA Cloud service. You can use an account provided for this session or a trial, free tier, or productive version of SAP BTP.
The SAP BTP brings together data and analytics, artificial intelligence, application development, automation, and integration in one, unified environment.
Choose a method to access the SAP BTP by following Exercise 1 or Exercise 2 below:
-
Exercise 1: Access the SAP BTP Shared Subaccount for DA262 is available for the attendees of this hands-on workshop using credentials provided during the session.
-
Exercise 2: Register for a Trial SAP BTP Account can be used if you are not in attendance at the session or if you would prefer to set up and use your own SAP BTP account.
-
Exercise 3 - Overview of the SAP Business Technology Platform
SAP HANA Cloud Central provides database administrators (DBAs) with a unified tool to administer and monitor SAP HANA Cloud database and SAP HANA Cloud data lake instances.
- Exercise 1 - Overview of SAP HANA Cloud Central
- Exercise 2 - Refresh and Auto-Refresh
- Exercise 3 - Create Instances
- Exercise 4 - Actions Menu
- Exercise 5 - Command Palette
- Exercise 6 - SQL Console
- Exercise 7 - Alerts
- Exercise 8 - The Database Overview Page
- Exercise 9 - Monitoring Memory Usage
- Exercise 10 - Security Basics
- Exercise 11 - Managing Workload Classes
- Exercise 12 - Analyzing SQL Performance
- Exercise 13 - Plan Trace
The SAP HANA database explorer is a web-based tool for browsing and working with database schema objects such as tables, views, and stored procedures and executing SQL.
- Exercise 1 - SAP HANA Database Explorer Connections
- Exercise 2 - Catalog Browser and Object Search
- Exercise 3 - Using the SQL Console
Additional HANA Cloud Central Exercises:
- Appendix 1 - Searching and Filtering
- Appendix 2 - Toolbar
- Appendix 3 - Views
- Appendix 4 - Migration
- Appendix 5 - Data Replication
- Appendix 6 - Admission Control
- Appendix 7 - Native Storage Extension
- Appendix 8 - Table Partition
- Appendix 9 - HDI Administration
Please read the CONTRIBUTING.md to understand the contribution guidelines.
Please read the SAP Open Source Code of Conduct.
Support for the content in this repository is available during the actual time of the online session for which this content has been designed. Otherwise, you may request support via the Issues tab.
Copyright (c) 2023 SAP SE or an SAP affiliate company. All rights reserved. This project is licensed under the Apache Software License, version 2.0 except as noted otherwise in the LICENSE file.