Using Joule in SAP HANA Cloud Central

Objective

After completing this lesson, you will be able to use Joule to help you with your daily database administration tasks.

Using Joule to Change User Menu Settings

Introduction

In this lesson, we will show how Joule can assist database administrators in managing their daily administrative tasks within SAP HANA Cloud Central. The gives examples will show how Joule can help to reduce manual effort, minimize human error, and increase overall efficiency, allowing you to focus on more strategic aspects of database management.

Changing User Profile Settings using Joule

In your User Menu - Settings you can change the behavior of SAP HANA Cloud Central. For example you can change the Appearance, Preferred Region, or the App notification setting.

The image show the default user menu setting, the example prompts that are given in the below text will change highlighted settings.

Using the following prompts, you can instruct Joule to perform the changes in your user menu settings.

Change the Appearance

Depending on the time of day, you might want to use a light or dark color theme. Use the following prompt to instruct Joule to activate the default SAP Morning Horizon color theme.

Code Snippet
1
Change the theme to "SAP morning Horizon"

Joule will respond with a link that performs the color theme change.

Changing the Preferred Region

For high availability reasons you have distributed your SAP HANA Cloud database instances in several regions. Due to this you might need to change your Preferred Region several time a day. Using the following prompt you can let Joule perform the region change.

Code Snippet
1
Change the Preferred Region to "Americas"

Joule will respond with a link that performs the region change.

Activating the App Notifications

The App Notification feature in the User Menu Settings of SAP HANA Cloud Central allows users to manage their notification preferences for various applications within the platform. This feature is designed to enhance user experience by enabling users to receive timely updates and alerts related to their activities and system events. Using the following prompt you can ask Joule to activate the App Notifications

Code Snippet
1
Change the App Notifications to "On"

Joule will respond with a link that will enable the app notifications.

Demonstration: Changing User Menu Settings using Joule

The following demonstration shows the execution of the example prompts given in this lesson.

DemoStart Demo

Using Joule to Start Database Administration Tools

Starting Database Administration Tools Using Joule

During a normal workday, you might use several tools like:

  • Database Migration
  • SQL Console
  • Database Objects
  • Create Database Wizard

You can use Joule to open these tools using the following prompts:

Code Snippet
1
Open database migration

Will open the Self-Service Migration tool that allows you to migrate an SAP HANA database on Neo, Cloud Foundry, or on-premises to SAP HANA Cloud.

Code Snippet
1
Open SQL Console

Opens the SQL Console which you can use to execute SQL statements again the SAP HANA Cloud database.

Code Snippet
1
Open database objects

Joule opens the database objects tool, where you, as a database administrator, can view the details of the available database objects.

Code Snippet
1
Create a database instance

Joule opens the database provisioning wizard, where you, as a database administrator, can start creating new SAP HANA Cloud database instances.

Demonstration: Starting Database Administration Tools Using Joule

The following demonstration shows how you can use Joule to start the different database administration tools.

DemoStart Demo

Summary

Using Joule in SAP HANA Cloud Central can help you to quickly changing your user profile settings or starting one of the many SAP HANA Cloud a database administration tool. Joule will also provide a short explanation on how to use the tool.

Further reading

Learning

SAP FacebookSAP YoutubeSAP LinkedIn