Skip to content

Commit 9d71f42

Browse files
Automatic commit: Move 'hana-cloud-hdl-getting-started-2', 'hana-cloud-hdl-getting-started-3', 'hana-cloud-hdl-getting-started-5', 'hana-cloud-mission-extend-02', 'hana-cloud-mission-extend-05', 'hana-cloud-mission-extend-06', 'hana-cloud-smart-multi-model-1', 'hana-cloud-smart-multi-model-10', 'hana-cloud-trial-qgis-1', 'hana-cloud-trial-qgis-3' from QA to Production (#6921)
1 parent 72a3468 commit 9d71f42

13 files changed

Lines changed: 39 additions & 21 deletions

File tree

32.5 KB
Loading

tutorials/hana-cloud-hdl-getting-started-2/hana-cloud-hdl-getting-started-2.md

Lines changed: 4 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -42,7 +42,7 @@ To learn more about users, roles and privileges in SAP HANA Cloud, data lake, pl
4242
[ACCORDION-BEGIN [Step 2: ](Confirm your data lake is running)]
4343
Ensure that your standalone data lake instance is currently running before trying to connect to it using SAP HANA Database Explorer.
4444

45-
1. To do this, navigate to the **SAP HANA Cloud Central** wizard from your data lake instance in the SAP BTP Cockpit.
45+
1. To do this, navigate to the **SAP HANA Cloud Central** wizard from your data lake instance in the SAP BTP cockpit.
4646

4747
2. Locate your standalone data lake instance details by selecting to view all instances.
4848

@@ -69,6 +69,9 @@ In the next steps, you can learn how to use each of these connection methods. On
6969

7070
[ACCORDION-BEGIN [Step 4: ](Connect to data lake)]
7171

72+
> **For this step, select your preferred connection method by clicking on the options under the step title.**
73+
> !![Options Screenshot](TabOptions-Screenshot.png)
74+
7275
[OPTION BEGIN [SAP HANA Database Explorer]]
7376
After confirming the status, click on the three dots again and select the option to **Open SQL Console** in the SAP HANA Database Explorer.
7477
>You can also navigate to the same destination by selecting the option to open SAP HANA Database Explorer.

tutorials/hana-cloud-hdl-getting-started-3/hana-cloud-hdl-getting-started-3.md

Lines changed: 23 additions & 10 deletions
Original file line numberDiff line numberDiff line change
@@ -18,18 +18,25 @@ primary_tag: products>sap-hana-cloud
1818
- How to load data hosted in an Amazon Web Services (AWS) S3 bucket into a standalone data lake
1919
- How to load data hosted in a Microsoft Azure container into a standalone data lake
2020

21-
You can download these supporting `csv` files that will be used throughout this tutorial.
2221

2322

24-
- [Customer](https://raw.githubusercontent.com/SAPDocuments/Tutorials/master/tutorials/hana-cloud-hdl-getting-started-3/customer.tbl?token=AUDXVMKBFVFSJ65COMHYJQTAYOOTQ)
23+
The supporting sample data and code files are available on a public GitHub repository. From the folder [Mission: Get Started with a Standalone Data lake](https://github.com/SAP-samples/hana-cloud-learning/tree/main/Mission:%20Get%20Started%20with%20a%20Standalone%20Datalake) download the zip file [Sample Data](https://github.com/SAP-samples/hana-cloud-learning/blob/main/Mission:%20Get%20Started%20with%20a%20Standalone%20Datalake/Sample%20Data.zip).
2524

26-
- [Nation](https://raw.githubusercontent.com/SAPDocuments/Tutorials/master/tutorials/hana-cloud-hdl-getting-started-3/nation.tbl?token=AUDXVMNYPET4FMW2UT4WAZLAYOOXO)
25+
In this zip file, you will find four tables:
2726

28-
- [Region](https://raw.githubusercontent.com/SAPDocuments/Tutorials/master/tutorials/hana-cloud-hdl-getting-started-3/region.tbl?token=AUDXVMKXKRPCMGNFKQKONTLAYOOZU)
27+
- Customer.tbl
28+
29+
- Nation.tbl
30+
31+
- Region.tbl
32+
33+
- Supplier.tbl
34+
35+
In the same GitHub folder, you can also find the SQL scripts used in this tutorial as a [zip file](https://github.com/SAP-samples/hana-cloud-learning/blob/main/Mission:%20Get%20Started%20with%20a%20Standalone%20Datalake/SQL%20Scripts.zip) or as individual files.
36+
37+
If you decide to use Interactive SQL instead of SAP HANA Database Explorer, please copy the SQL Scripts used in this tutorial onto the machine where you installed the Interactive SQL.
2938

30-
- [Supplier](https://raw.githubusercontent.com/SAPDocuments/Tutorials/master/tutorials/hana-cloud-hdl-getting-started-3/supplier.tbl?token=AUDXVMPJAOWQHEQ6ZC4AN7DAYOO3M)
3139

32-
If you decide to use Interactive SQL instead of SAP HANA Database Explorer, please copy the `SQL Scripts` used in this tutorial onto the machine where you installed the Interactive SQL.
3340

3441
[ACCORDION-BEGIN [Step 1: ](Create a new user)]
3542
Before you create tables, it is recommended that you also create a new user, so that your new tables are not owned by `HDLADMIN`. With a new user, your new tables will be created under a particular schema.
@@ -56,6 +63,8 @@ For more in-depth information about creating users in SAP HANA Cloud, data lake,
5663
[ACCORDION-END]
5764

5865
[ACCORDION-BEGIN [Step 2: ](Create tables in data lake)]
66+
> **For this step, select your preferred method by clicking on the options under the step title.**
67+
5968
Now it's time to create tables. In this example, you will create the following tables:
6069

6170
>* customer
@@ -69,7 +78,7 @@ Let's get started. Follow these steps:
6978

7079
1. In SAP HANA Database Explorer, make sure your SQL Console is open.
7180

72-
2. Copy the code given below into the SQL Console and execute the script after entering your password in the appropriate field.
81+
2. Copy the code given below into the SQL Console and execute the script after entering your password in the appropriate field. You can also find this code in `CreateTables.sql` file contained in the `SQL scripts.zip` [file](https://github.com/SAP-samples/hana-cloud-learning/blob/main/Mission:%20Get%20Started%20with%20a%20Standalone%20Datalake/SQL%20Scripts.zip).
7382

7483
```SQL
7584
/*==============================================================*/ */
@@ -166,7 +175,7 @@ You can create tables using Interactive SQL connected to your data lake instance
166175

167176
Let's get started. Follow these steps:
168177

169-
1. Within an Interactive SQL window, copy and paste the SQL script given below.
178+
1. Within an Interactive SQL window, copy and paste the SQL script given below. You can also find this code in `CreateTables.sql` file contained in the `SQL scripts.zip` [file](https://github.com/SAP-samples/hana-cloud-learning/blob/main/Mission:%20Get%20Started%20with%20a%20Standalone%20Datalake/SQL%20Scripts.zip).
170179

171180
```SQL
172181
/*==============================================================*/ */
@@ -263,6 +272,8 @@ Let's get started. Follow these steps:
263272
[ACCORDION-END]
264273
265274
[ACCORDION-BEGIN [Step 3: ](Upload sample data)]
275+
> **For this step, select your preferred method by clicking on the options under the step title.**
276+
266277
[OPTION BEGIN [AWS S3 bucket]]
267278
If you wish to work with an S3 bucket on Amazon Web Services (AWS), then you will need the following details about your S3 bucket to load the data into the data lake:
268279
@@ -320,10 +331,12 @@ After all the mentioned files are uploaded completely, you can exit the Azure po
320331
[ACCORDION-END]
321332
322333
[ACCORDION-BEGIN [Step 4: ](Load data into data lake tables)]
334+
> **For this step, select your preferred method by clicking on the options under the step title.**
335+
323336
[OPTION BEGIN [AWS S3 bucket]]
324337
Now it's time to load the data from the S3 bucket into your data lake.
325338

326-
Copy the SQL script given below into the SQL Console in the SAP HANA Database Explorer. **But before you execute it, make the following changes in the script**.
339+
Copy the SQL script given below into the SQL Console in the SAP HANA Database Explorer. You can also find this code in `LoadTables_AWS.sql` file contained in the `SQL scripts.zip` [file](https://github.com/SAP-samples/hana-cloud-learning/blob/main/Mission:%20Get%20Started%20with%20a%20Standalone%20Datalake/SQL%20Scripts.zip). **But before you execute it, make the following changes in the script**.
327340

328341
```SQL
329342
/* Create an S3 bucket in AWS */
@@ -459,7 +472,7 @@ Run the script after making the changes. For the data to be loaded, please make
459472

460473
Now it's time to load the data from the Azure container into your data lake.
461474
462-
Copy the SQL script given below into the SQL Console in the SAP HANA Database Explorer. **But before you execute it, make the following changes in the script**.
475+
Copy the SQL script given below into the SQL Console in the SAP HANA Database Explorer. You can also find this code in `LoadTables_Azure.sql` file contained in the `SQL scripts.zip` [file](https://github.com/SAP-samples/hana-cloud-learning/blob/main/Mission:%20Get%20Started%20with%20a%20Standalone%20Datalake/SQL%20Scripts.zip). **But before you execute it, make the following changes in the script**.
463476
464477
```SQL
465478
/* Create an S3 bucket in AWS */

tutorials/hana-cloud-hdl-getting-started-5/hana-cloud-hdl-getting-started-5.md

Lines changed: 2 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -87,6 +87,8 @@ When creating a service request for data lake recovery, be sure to complete the
8787

8888
>In this tutorial, you have learned about the backup and recovery process of your database using SAP HANA Cloud, data lake. Make sure to take note of the frequency of the backups, their time of occurrence and the process for recovery.
8989
90+
For more learning materials on **SAP HANA Cloud**, [click here](https://community.sap.com/topics/hana-cloud). Follow our tag in the [**SAP Community**](https://blogs.sap.com/tags/73554900100800002881/) to stay up-to-date on the latest updates and newest content!
91+
9092
[DONE]
9193
[ACCORDION-END]
9294

tutorials/hana-cloud-mission-extend-02/hana-cloud-mission-extend-02.md

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -20,7 +20,7 @@ primary_tag: products>sap-hana-cloud
2020

2121
The security of your organization's data is a big concern at SAP. This is why we pre-configure every SAP HANA Cloud, SAP HANA database instance to a secure standard. In this way, you can rely on the proven comprehensive **SAP HANA security framework**, now also in the cloud. You get complete control over who accesses your data and you can make full use of your data through advanced solutions like anonymization.
2222

23-
![Illustration Security circle](LT04_02_01 Illustration_Security cirlce only_resized.png)
23+
![Illustration Security circle](ss-01-illustration-security-circle-only.png)
2424

2525
This tutorial serves as a broad introduction with links to all important documentation regarding security and backup topics. Feel free to add them all to your SAP HANA Cloud, SAP HANA database bookmark collection but do not forget to come back here and continue learning. Our first recommendation for your collection is the comprehensive technical documentation, the [SAP HANA Cloud Security Guide](https://help.sap.com/viewer/c82f8d6a84c147f8b78bf6416dae7290/LATEST/en-US/c3d9889e3c9843bdb834e9eb56f1b041.html).
2626

tutorials/hana-cloud-mission-extend-02/LT04_02_01 Illustration_Security cirlce only_resized.png renamed to tutorials/hana-cloud-mission-extend-02/ss-01-illustration-security-circle-only.png

File renamed without changes.
Binary file not shown.

tutorials/hana-cloud-mission-extend-05/hana-cloud-mission-extend-05.md

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -1,7 +1,7 @@
11
---
22
author_name: Christopher Kollhed
33
author_profile: https://github.com/chriskollhed
4-
title: Virtualise Data from the Cloud to an On-Premise Database Using Smart Data Access
4+
title: Use Smart Data Access to Virtualise Data from the Cloud to an On-Premise Database
55
description: Create an SDA connection between SAP HANA Cloud, SAP HANA database and SAP HANA on-premise.
66
auto_validation: true
77
time: 10
@@ -17,7 +17,7 @@ primary_tag: products>sap-hana-cloud
1717

1818
## Details
1919
### You will learn
20-
- how to create a remote source to an SAP HANA Cloud, SAP HANA database instance in your SAP HANA on-premise system using Smart Data Access
20+
- How to create a remote source to an SAP HANA Cloud, SAP HANA database instance in your SAP HANA on-premise system using Smart Data Access
2121
- How to then virtualise data from SAP HANA Cloud to an SAP HANA on-premise database
2222

2323

tutorials/hana-cloud-mission-extend-06/hana-cloud-mission-extend-06.md

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -1,7 +1,7 @@
11
---
22
author_name: Christopher Kollhed
33
author_profile: https://github.com/chriskollhed
4-
title: Virtualize Data from On-Premise to the Cloud Using Smart Data Integration
4+
title: Use Smart Data Integration to Virtualise Data from On-Premise to the Cloud
55
description: Virtualize data from SAP HANA on-premise to SAP HANA Cloud, SAP HANA database using Smart Data Integration (SDI) and the Data Provisioning Agent.
66
auto_validation: true
77
time: 15
@@ -110,7 +110,7 @@ Watch this video to see all the steps needed to install and configure the Data P
110110

111111
[OPTION END]
112112

113-
Now that the DP Agent is configured, you can virtualise and replicate data from the on-premise database to the SAP HANA Cloud, SAP HANA database instance. You can either virtualise or replicate data using this connection. The next steps will describe how to create virtual objects. In the [next tutorial](hana-cloud-mission-extend-07), you will learn how to use this connection to create a replication service.
113+
Now that the DP Agent is configured, you can virtualise and replicate data from the on-premise database to the SAP HANA Cloud, SAP HANA database instance. You can either virtualise or replicate data using this connection. The next steps will describe how to create virtual objects.
114114

115115

116116

tutorials/hana-cloud-smart-multi-model-1/hana-cloud-smart-multi-model-1.md

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -62,7 +62,7 @@ These are the requirements to follow along:
6262

6363
3. Make sure your SAP HANA Cloud, SAP HANA database is running in your trial account.
6464

65-
4. Create a user and assign this user the privileges **CREATE SCHEMA** and **IMPORT**. If you are unsure how to create users and assign privileges, you can read more here.
65+
4. Create a user and assign this user the privileges **CREATE SCHEMA** and **IMPORT**. If you are unsure how to create users and assign privileges, [you can read more here](https://github.com/SAP-samples/teched2020-DAT260/tree/main/exercises/ex0#setup-sap-hana-cloud-trial-instance-).
6666

6767
5. From BTP cockpit or SAP HANA Cloud Central, open your trial instance in the SAP HANA Database Explorer and log in with this user's credentials.
6868

0 commit comments

Comments
 (0)