Skip to content

Commit 320303a

Browse files
danielvadanielva
committed
Merge branch 'master' of github.com:danielva/Tutorials
2 parents ad56886 + bd7cc0c commit 320303a

1 file changed

Lines changed: 18 additions & 18 deletions

File tree

‎tutorials/hana-dbx-hcc/hana-dbx-hcc.md‎

Lines changed: 18 additions & 18 deletions
Original file line numberDiff line numberDiff line change
@@ -6,36 +6,36 @@ tags: [tutorial>beginner, software-product-function>sap-hana-cloud--sap-hana-dat
66
primary_tag: software-product>sap-hana-cloud
77
---
88

9-
# Query Databases Using the SQL Console in SAP HANA Cloud Central
10-
<!-- description --> Learn how the SQL console can be used within SAP HANA Cloud Central to quickly query a selected database.
9+
# Query databases using the SQL Console in SAP HANA Cloud Central
10+
<!-- description --> Learn how the SQL Console can be used within SAP HANA Cloud Central to quickly query a selected database.
1111

1212
## Prerequisites
1313
- An SAP HANA Cloud database
1414
- You have completed [this](hana-dbx-create-schema) tutorial which creates a database schema for an SAP HANA Cloud, SAP HANA database.
1515
- You have completed [this](hana-cloud-dl-clients-overview) tutorial which creates a database schema for an SAP HANA Cloud, data lake Relational Engine
1616

1717
## You will learn
18-
- How to open a SQL console, specify the credentials, and set the current schema
19-
- An overview of the functionality provided in the SQL console
18+
- How to open a SQL Console, specify the credentials, and set the current schema
19+
- An overview of the functionality provided in the SQL Console
2020

2121
---
2222

23-
### Open a SQL console
24-
This step demonstrates how a SQL console can quickly be opened from within SAP HANA Cloud Central and how to change the SQL console's credentials and schema.
23+
### Open a SQL Console
24+
This step demonstrates how a SQL Console can quickly be opened from within SAP HANA Cloud Central and how to change the SQL Console's credentials and schema.
2525

26-
1. In **SAP HANA Cloud Central**, open a SQL console by selecting **SQL Console** in the left pane. Notice that the SQL console is not associated with a database when opened in this way.
26+
1. In **SAP HANA Cloud Central**, open a SQL Console by selecting **SQL Console** in the left pane. Notice that the SQL Console is not associated with a database when opened in this way.
2727

28-
![open SQL console](open-sql-console.png)
28+
![open SQL Console](open-sql-console.png)
2929

30-
>Additional SQL consoles can also be opened by selecting the **+** icon.
30+
>Additional SQL Consoles can also be opened by selecting the **+** icon.
3131
3232
2. This time select **Instances**, select a database, and choose **Open SQL Console** from the actions menu.
3333

34-
![open SQL console from an instance](open-sql-console-instance.png)
34+
![open SQL Console from an instance](open-sql-console-instance.png)
3535

3636
Notice that it is now connected to the instance named `HC_HDB`.
3737

38-
![SQL console connected to HC_HDB](sql-console-connected.png)
38+
![SQL Console connected to HC_HDB](sql-console-connected.png)
3939

4040
>The currently connected user can be seen by executing the SQL statement below.
4141
@@ -80,7 +80,7 @@ This step demonstrates how a SQL console can quickly be opened from within SAP H
8080
8181
8282
### Execute SQL
83-
This step demonstrates how to execute a SQL query and view query results, messages, and history within a SQL console.
83+
This step demonstrates how to execute a SQL query and view query results, messages, and history within a SQL Console.
8484
8585
1. Execute the following SQL statements.
8686
@@ -110,16 +110,16 @@ This step demonstrates how to execute a SQL query and view query results, messag
110110
111111
![history view](history.png)
112112
113-
Notice that the statements can be located using a search and that a selected item can be inserted back into the SQL console or copied.
113+
Notice that the statements can be located using a search and that a selected item can be inserted back into the SQL Console or copied.
114114
115115
>The history is not persisted across browser reloads.
116116
117117
### A few things to note
118-
The SQL console within SAP HANA Cloud Central appears similar to the one within the SAP HANA database explorer but there are some differences.
118+
The SQL Console within SAP HANA Cloud Central appears similar to the one within the SAP HANA database explorer but there are some differences.
119119
120-
* Opening the SQL console within the SAP HANA Cloud Central can be done much quicker than opening the full SAP HANA database explorer.
120+
* Opening the SQL Console within the SAP HANA Cloud Central can be done much quicker than opening the full SAP HANA database explorer.
121121
122-
* The SQL console that you access from within SAP HANA Cloud Central can only connect to databases that are within the same BTP subaccount as SAP HANA Cloud Central.
122+
* The SQL Console that you access from within SAP HANA Cloud Central can only connect to databases that are within the same BTP subaccount as SAP HANA Cloud Central.
123123
124124
* The SAP HANA database explorer has some additional functionality
125125
@@ -134,8 +134,8 @@ The SQL console within SAP HANA Cloud Central appears similar to the one within
134134
* Ability to run statements against multiple instances
135135
* Generate SQL Analyzer file or explain plan
136136
* Statement library
137-
* SQL console settings
137+
* SQL Console settings
138138
139139
### Knowledge check
140140
141-
Congratulations! You have now used the SQL console in SAP HANA Cloud Central and have become familiar with some of the features it provides.
141+
Congratulations! You have now used the SQL Console in SAP HANA Cloud Central and have become familiar with some of the features it provides.

0 commit comments

Comments
 (0)