You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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).
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.
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.
33
40
34
41
[ACCORDION-BEGIN [Step 1: ](Create a new user)]
35
42
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,
56
63
[ACCORDION-END]
57
64
58
65
[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
+
59
68
Now it's time to create tables. In this example, you will create the following tables:
60
69
61
70
>* customer
@@ -69,7 +78,7 @@ Let's get started. Follow these steps:
69
78
70
79
1. In SAP HANA Database Explorer, make sure your SQL Console is open.
71
80
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).
@@ -166,7 +175,7 @@ You can create tables using Interactive SQL connected to your data lake instance
166
175
167
176
Let's get started. Follow these steps:
168
177
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).
@@ -263,6 +272,8 @@ Let's get started. Follow these steps:
263
272
[ACCORDION-END]
264
273
265
274
[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
+
266
277
[OPTION BEGIN [AWS S3 bucket]]
267
278
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:
268
279
@@ -320,10 +331,12 @@ After all the mentioned files are uploaded completely, you can exit the Azure po
320
331
[ACCORDION-END]
321
332
322
333
[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
+
323
336
[OPTION BEGIN [AWS S3 bucket]]
324
337
Now it's time to load the data from the S3 bucket into your data lake.
325
338
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**.
327
340
328
341
```SQL
329
342
/* 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
459
472
460
473
Now it's time to load the data from the Azure container into your data lake.
461
474
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**.
Copy file name to clipboardExpand all lines: tutorials/hana-cloud-hdl-getting-started-5/hana-cloud-hdl-getting-started-5.md
+2Lines changed: 2 additions & 0 deletions
Display the source diff
Display the rich diff
Original file line number
Diff line number
Diff line change
@@ -87,6 +87,8 @@ When creating a service request for data lake recovery, be sure to complete the
87
87
88
88
>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.
89
89
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!
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.
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).
Copy file name to clipboardExpand all lines: tutorials/hana-cloud-mission-extend-06/hana-cloud-mission-extend-06.md
+2-2Lines changed: 2 additions & 2 deletions
Display the source diff
Display the rich diff
Original file line number
Diff line number
Diff line change
@@ -1,7 +1,7 @@
1
1
---
2
2
author_name: Christopher Kollhed
3
3
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
5
5
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.
6
6
auto_validation: true
7
7
time: 15
@@ -110,7 +110,7 @@ Watch this video to see all the steps needed to install and configure the Data P
110
110
111
111
[OPTION END]
112
112
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.
Copy file name to clipboardExpand all lines: tutorials/hana-cloud-smart-multi-model-1/hana-cloud-smart-multi-model-1.md
+1-1Lines changed: 1 addition & 1 deletion
Display the source diff
Display the rich diff
Original file line number
Diff line number
Diff line change
@@ -62,7 +62,7 @@ These are the requirements to follow along:
62
62
63
63
3. Make sure your SAP HANA Cloud, SAP HANA database is running in your trial account.
64
64
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-).
66
66
67
67
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.
0 commit comments