Merge pull request #23850 from danielva/master

rbrainey · web-flow · commit b49aa9a3cd0c · 2025-01-06T14:42:34.000-06:00
data lake client group updates
diff --git a/tutorials/hana-cloud-dl-clients-dot-net/hana-cloud-dl-clients-dot-net.md b/tutorials/hana-cloud-dl-clients-dot-net/hana-cloud-dl-clients-dot-net.md
@@ -81,6 +81,8 @@ In order for the shell to recognize that the .NET SDK is installed and for any `
       </Reference>
     </ItemGroup>
     ```
+
+    Note that if the developer licensed version of the data lake Client was installed for Linux, the path might be similar to /home/dan/sap/hdlclient/sdk/dotnet/Sap.Data.SQLAnywhere.Core.v2.1.dll
     
     ![dotNET.csproj code](dotNET-csproj-code.png)
 
diff --git a/tutorials/hana-cloud-dl-clients-golang/hana-cloud-dl-clients-golang.md b/tutorials/hana-cloud-dl-clients-golang/hana-cloud-dl-clients-golang.md
@@ -30,7 +30,7 @@ go version
 
 ![go version linux](version2.png)
 
-If Go is installed, then it will return the currently installed version, such as 1.21.5
+If Go is installed, then it will return the currently installed version, such as 1.23.4
 
 If it is not installed, download it from [Download Go](https://golang.org/dl/), run the installer, follow the provided instructions, and ensure that Go is in your path.
 
@@ -86,20 +86,23 @@ The Go driver loads the SQLDBC library  named `libdbcapiHDB` using [cgo](https:/
     >It is also possible on Microsoft Windows to set this using the SETX command from a shell.
 
 
-    On Linux, open the '.bash_profile' and add the following lines.
-
+    On Linux, open the '.bashrc' or '.bash_profile' and first check and if needed the following lines.  Note that the path may be different depending on the data lake client install used.
     
     ```Shell (Linux)
+    echo $LD_LIBRARY_PATH
+    echo $CGO_LDFLAGS
     pico .bash_profile 
     ```
 
     ```Shell (Linux)
+    export LD_LIBRARY_PATH=$HOME/sap/dlclient/IQ-17_1/lib64
+    export LD_LIBRARY_PATH=$HOME/sap/hdlclient/lib64
     export CGO_LDFLAGS=$HOME/sap/dlclient/IQ-17_1/lib64/libdbcapi_r.so
-    export LD_LIBRARY_PATH=$HOME/sap/dlclient/IQ-17_1/lib64 
+    export CGO_LDFLAGS=$HOME/sap/hdlclient/lib64/libdbcapi_r.so
     ```
     ![.bash_profile contents](bashProfileAfterCGO.png)
 
-4. Navigate to the driver folder and create a Go module.
+4. Navigate to the driver folder and create a Go module.  Note that the path may be different depending on the data lake client install used.
 
     ```Shell (Windows)
     cd %IQDIR17%\sdk\golang\SAP\go-hdlre\driver
@@ -109,6 +112,7 @@ The Go driver loads the SQLDBC library  named `libdbcapiHDB` using [cgo](https:/
     
     ```Shell (Linux)
     cd $IQDIR17/sdk/golang-hdlre/src/SAP/go-hdlre/driver
+    cd $IQDIR17/sdk/golang/SAP/go-hdlre/driver/
     go mod init "SAP/go-hdlre/driver"
     go mod tidy
     ```
@@ -195,7 +199,7 @@ The Go driver loads the SQLDBC library  named `libdbcapiHDB` using [cgo](https:/
     pico go.mod
     ```
 
-4. Add the code below to `go.mod` under the go 1.19 (version) line:
+4. Add the code below to `go.mod` under the go 1.23.4 (version) line:
     
     >Make any necessary changes to ensure the path to the driver folder is correct.
 
@@ -206,6 +210,7 @@ The Go driver loads the SQLDBC library  named `libdbcapiHDB` using [cgo](https:/
     
     ```Code (Linux)
     replace SAP/go-hdlre/driver v0.1.0 => /home/name/sap/dlclient/IQ-17_1/sdk/golang-hdlre/src/SAP/go-hdlre/driver 
+    replace SAP/go-hdlre/driver v0.1.0 => /home/name/sap/hdlclient/sdk/golang/SAP/go-hdlre/driver
     require SAP/go-hdlre/driver v0.1.0 
     ```
 
diff --git a/tutorials/hana-cloud-dl-clients-node/hana-cloud-dl-clients-node.md b/tutorials/hana-cloud-dl-clients-node/hana-cloud-dl-clients-node.md
@@ -81,6 +81,8 @@ The Node.js driver covered in this tutorial is `@sap\iq-client` which supports t
     npm install $IQDIR17/sdk/node
     ```
 
+    If the above command fails due to a permission error, either change the folder permission or run with sudo.
+
 4. The following command lists the Node.js modules that are now installed locally into the `DataLakeClientsTutorial\node` folder.
 
     ```Shell
diff --git a/tutorials/hana-cloud-dl-clients-odbc/hana-cloud-dl-clients-odbc.md b/tutorials/hana-cloud-dl-clients-odbc/hana-cloud-dl-clients-odbc.md
@@ -88,11 +88,12 @@ For additional details see [Connection Properties](https://help.sap.com/viewer/a
     pico .odbc.ini
     ```
 
-4. Configure the values of `driver` and `host` so that they conform with your setup.
+4. Configure the values of `driver` and `host` so that they conform with your setup.  Note that with the developer licensed version of the data lake client, the driver path below is slightly different.
 
     ```.odbc.ini
     [HC_DL]
     driver=/home/XXXXX/sap/dlclient/IQ-17_1/lib64/libdbodbc17.so
+    driver=/home/dan/sap/hdlclient/lib64/libdbodbc17.so
     encryption=TLS(trusted_certificates=*;direct=yes)
     host=XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX.iq.hdl.XXXX-XXXX.hanacloud.ondemand.com:443
     integrated=NO
diff --git a/tutorials/hana-cloud-dl-clients-overview/developmenttools.png b/tutorials/hana-cloud-dl-clients-overview/developmenttools.png
diff --git a/tutorials/hana-cloud-dl-clients-overview/hana-cloud-dl-clients-overview.md b/tutorials/hana-cloud-dl-clients-overview/hana-cloud-dl-clients-overview.md
@@ -32,16 +32,16 @@ SAP HANA Cloud is composed of multiple components.
 
   * SAP HANA is an in-memory, multi-model, column-based, relational database. For further details see [Introduction to SAP HANA Cloud](https://help.sap.com/docs/hana-cloud/sap-hana-cloud-getting-started-guide/introduction-to-sap-hana-cloud) and the tutorial mission [Use Clients to Query an SAP HANA Database](mission.hana-cloud-clients).
 
-  * SAP HANA Cloud, data lake is composed of two components:  data lake Relational Engine and data lake Files.    
+  * SAP HANA Cloud, data lake is composed of two components; a data lake Relational Engine and data lake Files.    
 
-    [Data Lake Relational Engine](https://help.sap.com/docs/hana-cloud-data-lake/welcome-guide/data-lake-relational-engine) is a disk-based, column-oriented relational database for storing and analyzing high volumes of infrequently updated data. It descends from [SAP IQ](https://help.sap.com/docs/SAP_IQ), which was previously named Sybase IQ. Because of its heritage, there are commonalities with other Sybase products. Some of the client interface drivers are shared with [SAP SQL Anywhere](https://help.sap.com/docs/SAP_SQL_Anywhere) and SAP Adaptive Server Enterprise.
+    [Data Lake Relational Engine](https://help.sap.com/docs/hana-cloud-data-lake/welcome-guide/data-lake-relational-engine) is a disk-based, column-oriented relational database for storing and analyzing large amounts of infrequently updated data. It descends from [SAP IQ](https://help.sap.com/docs/SAP_IQ), which was previously named Sybase IQ. Because of its heritage, there are commonalities with other Sybase products. Some of the client interface drivers are shared with [SAP SQL Anywhere](https://help.sap.com/docs/SAP_SQL_Anywhere) and SAP Adaptive Server Enterprise.
 
-    [Data Lake Files](https://help.sap.com/docs/hana-cloud-data-lake/welcome-guide/data-lake-files) can be used to store and access unstructured data such as trace files and structured files like CSV, Parquet, or ORC. Structured files can use [SQL on Files](https://help.sap.com/docs/hana-cloud-data-lake/welcome-guide/sql-on-files), which enables SQL queries to be performed on them.  
+    [Data Lake Files](https://help.sap.com/docs/hana-cloud-data-lake/welcome-guide/data-lake-files) can be used to store and access unstructured data such as trace files and structured files like CSV, Parquet, or delta tables.  Structured files can use [SQL on Files](https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-on-files-guide/sap-hana-cloud-sap-hana-database-sql-on-files-guide), which enables SQL queries to be performed on them.  
 
     >Note, that the data lake Files component, is currently not available in free tier or trial accounts.
 
 ### Choose where to deploy the database instances
-The SAP BTP platform provides multiple runtime environments such as Cloud Foundry and Kyma.  When a HANA Cloud or data lake instance is created, it can be created in a BTP subaccount or in a Cloud Foundry space.  SAP HANA Cloud Central can be used to provision and manage instances in the BTP subaccount or in a Cloud Foundry space.  In the screenshot below, there is an instance of a data lake that was provisioned in the BTP subaccount (Other Environments) and one that was provisioned into Cloud Foundry.
+The SAP BTP platform provides multiple runtime environments such as Cloud Foundry and Kyma.  When a SAP HANA Cloud or data lake instance is created, it can be created in a BTP subaccount or in a Cloud Foundry space.  SAP HANA Cloud Central can be used to provision and manage instances in the BTP subaccount or in a Cloud Foundry space.  In the screenshot below, there is an instance of a data lake that was provisioned in the BTP subaccount (Other Environments) and one that was provisioned into Cloud Foundry.
 
 ![Runtime Environments](runtime.png)
 
@@ -286,7 +286,70 @@ In this step, a sample HOTEL dataset will be created comprising tables, a view,
 For additional details on the SAP HANA database explorer, see the tutorial [Get Started with the SAP HANA Database Explorer](group.hana-cloud-get-started), which showcases many of its features.
 
 
+### Install the developer licensed version of the data lake client
+This version of the data lake client does not include cryptographic libraries as it makes use of the libraries that are available on the operating systems such as OpenSSL.  It is available for download after accepting SAP Developer License agreement.  Currently, this version is only available for Linux.  Either client can be used to complete the steps shown in this tutorial group.
+
+1.  Open the HANA tab of [SAP Development Tools](https://tools.hana.ondemand.com/#hanatools).
+
+2.  Download the SAP HANA Data Lake Client 1.0.
+
+    ![download](developmenttools.png)
+
+3.  Extract the archive.
+
+    ```Shell (Linux)
+    tar -zxvf hdlclient-latest-linux-x64.tar.gz
+    ```
+
+4.  Start the installer.
+
+    ```Shell (Linux)
+    cd ebf*
+    ./hdbinst
+    ```  
+
+    [run the installer](hdbinst.png)  
+
+5.  Configure the environment variables.  This can be done by calling hdlclienv.sh manually or it can be added to the Bash shell by referencing it in `.bashrc`.
+
+    Open the `.bashrc`.
+
+    ```Shell (Linux)
+    pico ~/.bashrc
+    ```
+
+    >This tutorial uses notepad and `pico` as default text editors, but any text editor will do.
+    >`Pico` can be installed on SUSE Linux with
+
+    >```Shell (Linux SUSE)
+    sudo zypper install pico
+    >```
+
+    Add the following line to point to the location where the SAP data lake client is installed.
+
+    ```Shell (Linux) .bash_profile
+    source ~/sap/hdlclient/bin64/hdlclienv.sh
+    ```
+
+    Test the change by running:
+
+    ```Shell (Linux)
+    source ~/.bashrc
+    ```
+
+    The following command should display the install location of the data lake client.
+
+    ```Shell (Linux)
+    echo $IQDIR17
+    ```
+
+    >In the case that the Data Lake Client needs to be uninstalled, run the `hdbuninst` file located in the directory `~/sap/hdlclient/install`.  
+
+    ---
+
+
 ### Install the data lake client
+This version of the data lake client is available from the SAP Software Download Center and requires an S-user ID and only shows software that you have purchased.  Additional details can be found at [Software Downloads FAQ](https://support.sap.com/content/dam/support/en_us/library/ssp/my-support/help-for-sap-support-applications/online_help-software_downloads.html#faq).  Either client can be used to complete the steps shown in this tutorial group.
 
 1.  Open [SAP for me](https://me.sap.com/softwarecenter) and navigate to **Support Packages & Patches** | **By Alphabetical Index (A-Z)**.
 
@@ -391,6 +454,38 @@ The data lake client install includes [dbisql Interactive SQL Utility](https://h
 
 1. Start the GUI version of DBISQL by searching from the Microsoft Windows Start menu. It can also be accessed by entering `dbisql` in the command prompt.
 
+    If the error "This file could not be found: java" occurs, follow the instructions below.
+
+    * Download and install [SAP JVM 8.0](https://tools.hana.ondemand.com/#cloud)
+
+        ```Shell (Linux)
+        unzip sapjvm-8.1.102-linux-x64.zip
+        mv ./sapjvm_8 ~/
+        ```
+
+    * Add the following to your bashrc. 
+
+        ```Shell (Linux)
+        export JAVA_HOME=~/sapjvm_8
+        export PATH=$PATH:$JAVA_HOME/bin
+        ```
+
+    * Apply and test the changes.
+        ```Shell (Linux)
+        source ~/.bashrc
+        java -version
+        dbisql
+        ```
+
+    If a further error occurs such as libXext.so.6: cannot open shared object file, install the missing components.
+
+        ```Shell (Linux)
+        sudo zypper install libXext6
+        sudo zypper install libXrender1
+        sudo zypper install libXtst6
+        sudo zypper install libXi6
+        ```
+
 2. Specify the connection type.
 
     ![Connection type](dbisql-connection-type.png)
diff --git a/tutorials/hana-cloud-dl-clients-overview/hdbinst.png b/tutorials/hana-cloud-dl-clients-overview/hdbinst.png
diff --git a/tutorials/hana-cloud-dl-clients-python/hana-cloud-dl-clients-python.md b/tutorials/hana-cloud-dl-clients-python/hana-cloud-dl-clients-python.md
@@ -1,4 +1,4 @@
----
+            ---
 parser: v2
 auto_validation: true
 time: 15
@@ -37,13 +37,18 @@ The first step is to check if Python and pip are installed.
 
     >In some Linux distributions, 'python' refers to Python 2, while 'python3' refers to Python 3. However, as Python 2 is now obsolete, 'python' may refer to Python 3 instead.
 
-
     If Python is not installed, it can be downloaded from [Python downloads](https://www.python.org/downloads/).
 
     On Microsoft Windows, check the box that says **Add Python 3.x to PATH** as shown below to ensure that the interpreter will be placed in your path.  The Microsoft Windows command prompt or shell will need to be reopened after Python is installed to pick up the path to python.   
 
     ![python-install](python-install.png)
 
+    On OpenSUSE Tumbleweed, yast can be used to install python313.  Once it has been installed its version can be seen with the below command.
+
+    ```Shell (Linux)
+    python3.13 --version
+    ```
+
 
 2. Enter the commands below.
 
@@ -86,9 +91,9 @@ The `sqlanydb` package is the python driver for the data lake Relational Engine
     ```
 
 
-    On Linux the rest of the steps will be executed in a virtual enviroment.
+    On Linux the rest of the steps will be executed in a virtual environment.
 
-    First make a project folder, and create a virtual environment inside it. To do so, open the terminal app, write the following command, and hit return, here pyvenv is the name of the folder that you wish to create the virtual enviroment in.
+    First make a project folder, and create a virtual environment inside it. To do so, open the terminal app, write the following command, and hit return, here pyvenv is the name of the folder that you wish to create the virtual environment in.
 
     ```Shell(Linux)
     mkdir $HOME/pyvenv
@@ -109,21 +114,20 @@ The `sqlanydb` package is the python driver for the data lake Relational Engine
 
     ![python-install](virtualenv.png)
 
-
-
-    Now execute :-
+    Depending on which install of the data lake client was used, execute
 
     
     ```Shell (Linux)
     cd $IQDIR17/sdk/python
     python3 setup.py install
     ```
 
+    or 
 
-
-
-
-
+    ```Shell (Linux)
+    cd $IQDIR17/sdk/python
+    pip install sqlanydb-1.0.14.tar.gz
+    ```
 
 2. On Microsoft Windows, create a user environment variable named `SQLANY_API_DLL` and set it to `%IQDIR17%\Bin64\dbcapi.dll`.
 
