Skip to content

Commit 6ca3322

Browse files
danielvadanielva
authored
Latest updates to data lake client, autopilot, and dbx tutorials (#18447)
* Automatic commit: Move 'hana-cloud-alerts-autopilot', 'hana-cloud-dl-clients-node', 'hana-cloud-dl-clients-odbc', 'hana-cloud-dl-clients-overview', 'hana-cloud-dl-clients-python', 'hana-dbx-connections', 'hana-dbx-create-schema', 'hana-dbx-export-import', 'hana-dbx-remote-sources' from QA to Production * Automatic commit: Move 'hana-cloud-dl-clients-overview' from QA to Production
1 parent 1c53c46 commit 6ca3322

23 files changed

Lines changed: 28 additions & 16 deletions

‎tutorials/hana-cloud-alerts-autopilot/hana-cloud-alerts-autopilot.md‎

Lines changed: 2 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -311,7 +311,8 @@ This step will configure the SAP Alert Notification Service to invoke the previo
311311

312312
>---
313313

314-
>Note, that multiple alerts will be triggered. For example, alerts are sent with a status of CREATE, UPDATE, or CLOSE. Some alerts also have different thresholds or severity values such as ERROR, WARNING, or NOTICE. See also [Alerts in SAP HANA Cloud](https://help.sap.com/viewer/f9c5015e72e04fffa14d7d4f7267d897/Cloud/en-US/8eca57e7e82e4b788246b6d9db020937.html).
314+
>Note, that multiple alerts will be triggered. For example, alerts are sent with a status of CREATE, UPDATE, or CLOSE. Some alerts also have different thresholds or severity values such as ERROR, WARNING, or NOTICE. See also [Alerts in SAP HANA Cloud](https://help.sap.com/docs/HANA_CLOUD_DATABASE/f9c5015e72e04fffa14d7d4f7267d897/8eca57e7e82e4b788246b6d9db020937.html).
315+
315316

316317
6. In the SAP HANA database explorer, trigger the test alert.
317318

‎tutorials/hana-cloud-dl-clients-node/npm-list.png‎

-4.53 KB
Loading

‎tutorials/hana-cloud-dl-clients-odbc/Excel-choose-table.png‎

9.78 KB
Loading

‎tutorials/hana-cloud-dl-clients-odbc/ExcelDSN.png‎

22 Bytes
Loading

‎tutorials/hana-cloud-dl-clients-odbc/data-source1.png‎

11 Bytes
Loading

‎tutorials/hana-cloud-dl-clients-odbc/data-source4.png‎

-326 Bytes
Loading

‎tutorials/hana-cloud-dl-clients-odbc/hana-cloud-dl-clients-odbc.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -137,7 +137,7 @@ For additional details see [Connection Properties](https://help.sap.com/viewer/a
137137
[DONE]
138138
[ACCORDION-END]
139139
140-
[ACCORDION-BEGIN [Step 3: ](Use data lake data source from Microsoft Excel)]
140+
[ACCORDION-BEGIN [Step 3: ](Use a data lake data source from Microsoft Excel)]
141141
142142
An application that supports ODBC can now make use of the created data source. One example on Windows is Microsoft Excel.
143143

‎tutorials/hana-cloud-dl-clients-overview/data-lake-client-install.png‎

1.93 KB
Loading

‎tutorials/hana-cloud-dl-clients-overview/dbisql-connection-type.png‎

1.87 KB
Loading

‎tutorials/hana-cloud-dl-clients-overview/hana-cloud-dl-clients-overview.md‎

Lines changed: 8 additions & 8 deletions
Original file line numberDiff line numberDiff line change
@@ -9,7 +9,6 @@ primary_tag: software-product-function>sap-hana-cloud\,-data-lake
99

1010
## Prerequisites
1111
- A Microsoft Windows or Linux computer.
12-
- An SAP HANA Cloud trial or free tier.
1312

1413
## Details
1514
### You will learn
@@ -38,15 +37,14 @@ SAP HANA Cloud is composed of multiple components.
3837

3938
>Note, that the data lake Files component is currently not available in trial accounts.
4039
41-
For additional details see [How & When to Use the New SAP HANA Cloud Database Instances](https://saphanajourney.com/hana-cloud/resources/sap-hana-cloud-new-services-adaptive-server-enterprise-and-data-lake/).
4240

4341
[DONE]
4442
[ACCORDION-END]
4543

4644

4745
[ACCORDION-BEGIN [Step 2: ](Create a data lake instance and connect to it)]
4846

49-
>To complete the tutorials in this group, an SAP HANA Cloud, data lake instance is needed. There are two different free options including SAP HANA Cloud free tier and free trial. For instructions on registering, see [Set Up Your SAP HANA Cloud, SAP HANA Database (free tier or trial) and Understand the Basics](group.hana-cloud-get-started-1-trial).
47+
>To complete the tutorials in this group, a SAP HANA Cloud, data lake instance is needed, which is created within the SAP Business Technology Platform (BTP). There are two different free options available, which are the SAP BTP free-tier and SAP BTP trial. For instructions on registering, see [Start Using SAP HANA Cloud Free Tier Model or Trial in SAP BTP Cockpit](hana-cloud-mission-trial-1).
5048
5149
The following steps provide instructions on how to create a data lake instance in the SAP Business Technology Platform (BTP) trial. Additional content on this topic is available at [Quick Start Tutorial for Data Lake](https://help.sap.com/viewer/a89a80f984f21015b2b2c84d2498d36d/latest/en-US/b62bc948ad684e3a94b9e14b68318f2a.html).
5250

@@ -267,6 +265,8 @@ In this step, a sample HOTEL dataset will be created comprising tables, a view,
267265
GRANT ROLE HOTEL TO USER1;
268266
```
269267

268+
Select **Tables**, and set the schema filter to be **HOTEL** to limit the returned tables to be those that were just created in the HOTEL schema.
269+
270270
![DBX Create](sql-commands.png)
271271

272272
Additional details on the SQL used above can be found at [CREATE TABLE Statement for Data Lake Relational Engine](https://help.sap.com/viewer/19b3964099384f178ad08f2d348232a9/latest/en-US/a619764084f21015b8039a8346dc622c.html), [CREATE VIEW Statement for Data Lake Relational Engine](https://help.sap.com/viewer/19b3964099384f178ad08f2d348232a9/latest/en-US/a61a051684f210158cced2d83231bd8a.html), and [CREATE PROCEDURE Statement for Data Lake Relational Engine](https://help.sap.com/viewer/19b3964099384f178ad08f2d348232a9/latest/en-US/a6185b2184f21015b2419a5444b55609.html).
@@ -391,13 +391,13 @@ The data lake client install includes [Interactive SQL Client (DBISQL)](https://
391391
>DBISQL can also be started without a GUI.
392392
>
393393
>```Shell (Windows)
394-
dbisql -hdl -c "uid=USER1;pwd=Password1;host=XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX.iq.hdl.trial-XXXX.hanacloud.ondemand.com:443;ENC=TLS(tls_type=rsa;direct=yes)" -nogui
394+
dbisql -c "uid=USER1;pwd=Password1;host=XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX.iq.hdl.trial-XXXX.hanacloud.ondemand.com:443;ENC=TLS(tls_type=rsa;direct=yes)" -nogui
395395
>```
396396
>
397397
> Note that in a Bash shell, strings in double quotes versus single quotes are treated [differently](https://stackoverflow.com/questions/6697753/difference-between-single-and-double-quotes-in-bash).
398398
>
399399
>```Shell (Linux)
400-
dbisql -hdl -c 'uid=USER1;pwd=Password1;host=XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX.iq.hdl.trial-XXXX.hanacloud.ondemand.com:443;ENC=TLS(tls_type=rsa;direct=yes)' -nogui
400+
dbisql -c 'uid=USER1;pwd=Password1;host=XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX.iq.hdl.trial-XXXX.hanacloud.ondemand.com:443;ENC=TLS(tls_type=rsa;direct=yes)' -nogui
401401
>```
402402

403403
>![DBISQL connected nogui](dbisql-nogui.png)
@@ -421,7 +421,7 @@ The data lake client install includes [Interactive SQL Client (DBISQL)](https://
421421

422422
1. Execute the following insert statements to provide some sample data.
423423

424-
>If you do not wish to use the GUI mode, paste the insert statements into a file first and then run `dbisql -hdl -c "uid..." sql.sql`.
424+
>If you do not wish to use the GUI mode, paste the insert statements into a file first and then run `dbisql -c "uid..." sql.sql`.
425425

426426
```SQL
427427
INSERT INTO HOTEL.HOTEL VALUES(10, 'Congress', '155 Beechwood St.', 'Seattle', 'WA', '20005');
@@ -550,8 +550,8 @@ The data lake client install includes [Interactive SQL Client (DBISQL)](https://
550550
3. DBISQL can also execute SQL from the command line or from a provided file. A few examples are shown below.
551551

552552
```Shell
553-
dbisql -hdl -c "uid=USER1;pwd=Password1;host=XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX.iq.hdl.trial-XXXX.hanacloud.ondemand.com:443;ENC=TLS(tls_type=rsa;direct=yes)" "select * from HOTEL.CUSTOMER;"
554-
dbisql -hdl -c "uid=USER1;pwd=Password1;host=XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX.iq.hdl.trial-XXXX.hanacloud.ondemand.com:443;ENC=TLS(tls_type=rsa;direct=yes)" sql.sql
553+
dbisql -c "uid=USER1;pwd=Password1;host=XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX.iq.hdl.trial-XXXX.hanacloud.ondemand.com:443;ENC=TLS(tls_type=rsa;direct=yes)" "select * from HOTEL.CUSTOMER;"
554+
dbisql -c "uid=USER1;pwd=Password1;host=XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX.iq.hdl.trial-XXXX.hanacloud.ondemand.com:443;ENC=TLS(tls_type=rsa;direct=yes)" sql.sql
555555
```
556556

557557
![DBISQL in batch mode](dbisql-batch.png)

0 commit comments

Comments
 (0)