Tools to Manage and Access the SAP HANA Cloud, SAP HANA Database

SAP HANA Cloud Central is your main administration tool for all SAP HANA Cloud instances. Here you can provision, scale, perform migrations, deal with alerts and issues, and browse and query your instances.

How to open SAP HANA Cloud Central

• In SAP BTP cockpit, open SAP HANA Cloud Central by clicking on the subscription to SAP HANA Cloud in the Subscriptions tab.

  

• SAP HANA Cloud Central will open in a new tab, where you can manage this instance.

What you can do in SAP HANA Cloud Central

• Find an instance using using various filters such as the name, instance ID, state, or type
• Get an overview of all SAP HANA Cloud instances in a subaccount
• Create SAP HANA Cloud instances
• Check the status of an instance
• Review notifications
• Examine the memory, compute, and storage consumption
• Start and stop instances
• Manage and delete instances
• Perform SAP HANA database migrations
• View alerts in the Alerts app
• Run queries in the SQL console tab
• Explore the schema of the database using the database objects app

How to find your instances

• In SAP HANA Cloud Central you can see all your instances. If you want to manage and maintain multiple instances, you can use the filters and search options on the top center area of the screen. Use Adapt Filters to modify the types of filters displayed.

  

Manage your instances

• You can open many options by clicking on the three dots under the Actions column to each instance on the list. This includes options to manage configurations, start or stop the instance, or delete it.

• One important option is to obtain the SQL Endpoint of your instance. To do so, click Copy SQL Endpoint. You will need this when you wish to connect to this instance from another application.

  

  To learn about more options to create and manage instances with SAP HANA Cloud Central, you can refer to the SAP HANA Cloud Administration with SAP HANA Cloud Central Guide.

View details of an instance

• Click on an instance to see further details of an instance including:

  • Memory
  • Compute
  • Network
  • Storage
  • Consumption
  • User & Authorization Management
  • Workload Management
  • Data Replication
  • Auditing
  • Performance Details including expensive statements

  

  Based on this information, you can make important decisions on how to manage and optimize your instances.

Provide database authentication

• Initially, you are signed in with the DBADMIN database user and the password specified during the instance provisioning wizard. Should you wish to change this, you can do so using the Choose Authentication menu item.

  

Browse the database objects

• In the database objects app, you can:

  • Search for objects in the database
  • Browse the metadata for each object such as the number of rows in a table and the columns and column types
  • View the create statements for objects
  • Generate SQL select statements to view the data of tables or views
  • Generate SQL statements to call functions or procedures
  • Import and export data
  • Add, remove, or manage remote sources

  From the instances action menu, select Open Database Objects.

  

  Select Views, set the schema to be SYS, and search for M_.

  

  Above you can see the list of monitoring views in the SYS schema that contain M_ in their name.

  Open the monitoring view M_DATABASE and examine its metadata.

  

  Using the database objects app you can quickly locate and examine database objects.

Run queries in the SQL console

• The SQL console app can be used to write and run SQL queries.

  From the instances page action menu or from the database objects app, select Open SQL Console.

  

  Once the SQL Console app opens, notice that details can be seen about the current schema, the connected instance, and that further details can be seen in the instance information dialog such as the user being used, and the instance’s SQL endpoint.

  

  Execute the below SQL query to see the database details.

  SQL Copy

  SELECT * FROM SYS.M_DATABASE;

  

SAP Business Application Studio is a development environment available for users with SAP HANA Cloud, SAP HANA database. There, you can create your development projects and model your data, including calculation views. This is also the tool you can use to build custom applications that connect and make use of your SAP HANA Cloud databases.

Using SAP Business Application Studio is not strictly necessary to use your SAP HANA Cloud instance, but if you would like to use calculation views and create applications it is strongly recommended. In this mission, you will learn to use it.

What you can do in SAP Business Application Studio

The SAP Business Application Studio provides tools specific to building business applications within the SAP ecosystem, covering the end-to-end development cycle. You can:

• Create development spaces
• Clone an existing project
• Create a new project using a template
• Use editors for SAP-specific technologies
• Test your application while consuming services from remote sources
• Build and deploy you application as a multi-target application

To use SAP Business Application Studio, you need be subscribed to this service within the SAP BTP Cockpit. You must also have Cloud Foundry enabled to add the SAP Business Application Studio entitlement.

Select the option that applies to you by clicking on the options below the step title.

Well done!

You have completed the fourth tutorial of this mission! Now you know how to access the tools you need to make the best use of your SAP HANA Cloud, SAP HANA database instances. Learn in the next tutorial how to import data into your SAP HANA Cloud database.