Skip to Content

SAP HANA Cloud, Data Lake IQ Client Interfaces Overview

test
0 %
SAP HANA Cloud, Data Lake IQ Client Interfaces Overview
Details

SAP HANA Cloud, Data Lake IQ Client Interfaces Overview

July 27, 2021
Created by
May 13, 2021
Learn about the data lake IQ, how to create a trial instance, how to install the data lake IQ client, and how to connect to the data lake IQ using the SAP HANA cockpit, SAP HANA database explorer, and Interactive SQL Client.

You will learn

  • Information about SAP HANA Cloud data lake IQ
  • How to install the data lake IQ client
  • How to create sample tables, views, and procedures
  • How to connect using SAP HANA cockpit, SAP HANA database explorer and the Interactive SQL Client
QR code

Prerequisites

  • A Microsoft Windows or Linux computer.

This tutorial group will provide guidance on setting up a trial instance of SAP HANA Cloud, data lake IQ so that it can then be connected to and queried using a few of the data lake IQ client interfaces as described in SAP HANA Cloud, Data Lake Developer Guide for Data Lake IQ.


Step 1: Overview of Data Lake IQ

SAP HANA Cloud is composed of multiple components, including data lake IQ.

For additional details see How & When to Use the New SAP HANA Cloud Database Instances.

Log on to answer question
Step 2: Create a data lake instance and connect to it

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.

There are multiple ways to create a data lake:

  • Create a data lake in the SAP HANA Database creation wizard.

    add a data lake
  • Add a data lake to an already created SAP HANA database that does not have a data lake already associated with it.

    add data lake

    When a data lake is created in either of the previous two methods, it is configured to be maximally compatible with an SAP HANA database.

  • Create a data lake that is independent (standalone) of a SAP HANA database if it is added via the Create | Data Lake menu item.

    independent data lake

    An independent data lake can be configured with additional options such a collation value of UTF8BIN and blank padding set to ON to be more compatible with an on-premise SAP IQ.

  1. Using the SAP BTP Cockpit within the SAP BTP Trial, navigate to subaccount, the space, and then to the SAP HANA Cloud section as shown below.

    SAP BTP Cockpit
  2. Click on Manage SAP HANA Cloud to open SAP HANA Cloud Central, which is used to create and configure SAP HANA Cloud instances.

    SAP BTP Cockpit
  3. If a data lake is not already present, add one using one of the three methods previously described, for example Create | SAP HANA Database.

    Create a HANA database

    Enable data lake.

    Enable a data lake

    Take note that the administration user is HDLADMIN.

    Note that it is also possible to create and manage data lake instances using the Cloud Foundry CLI.

  4. As this is a trial account, set allowed connections to Allow all IP addresses so that client applications can connect from any IP address.

    Allowed connections
  5. After a while, press the Refresh button and the status will change from CREATING to RUNNING.

    data lake running
Log on to answer question
Step 3: Open the SAP HANA cockpit
  1. Once the data lake has been created, use the actions menu (three dots) to open SAP HANA cockpit.

    Open in cockpit

    Input your credentials. These are stored by the SAP HANA cockpit and are shared with the SAP HANA database explorer in cockpit connections once entered into the following dialog.

    Credentials

    After you enter your credentials, should you wish to use a different set of credentials, the current credentials can be cleared using Clear Credentials and new credentials may be entered.

    Credentials
  2. The SAP HANA Cockpit can also be used to examine and configure users.

Log on to answer question
Step 4: Create tables with SAP HANA database explorer

In this step, a sample HOTEL dataset will be created comprising tables, a view, and a stored procedure.

  1. In SAP HANA Cloud Central, use the actions menu to open the SAP HANA database explorer.

    open database explorer
  2. Execute a few queries.

    SELECT CURRENT USER FROM DUMMY;
    SELECT * FROM SYS.SYSINFO;
    SELECT * FROM sa_db_properties() WHERE UPPER(PropName) LIKE '%NAME%';
    SELECT * FROM SYS.SYSOPTIONS WHERE UPPER("option") LIKE '%VERIFY%';
    
    SAP HANA database explorer
  3. In the SAP HANA database explorer, execute the following SQL statements.

    -- DROP VIEW HOTEL.HOTEL_ROOMS_VIEW;
    -- DROP PROCEDURE HOTEL.SHOW_RESERVATIONS;
    -- DROP TABLE HOTEL.MAINTENANCE;
    -- DROP TABLE HOTEL.RESERVATION;
    -- DROP TABLE HOTEL.CUSTOMER;
    -- DROP TABLE HOTEL.ROOM;
    -- DROP TABLE HOTEL.HOTEL;
    -- DROP USER USER1;
    -- DROP ROLE HOTEL;
    
    --Create a role that will own the sample hotel dataset  
    CREATE ROLE HOTEL;
    
    --Create the objects in the HOTEL schema
    CREATE TABLE HOTEL.HOTEL(
        hno INTEGER PRIMARY KEY,
        name VARCHAR(50) NOT NULL,
        address VARCHAR(40) NOT NULL,
        city VARCHAR(30) NOT NULL,
        state VARCHAR(2) NOT NULL,
        zip VARCHAR(6)
    );
    
    CREATE TABLE HOTEL.ROOM(
        hno INTEGER,
        type VARCHAR(6),
        free NUMERIC(3),
        price NUMERIC(6, 2),
        PRIMARY KEY (hno, type),
        FOREIGN KEY (hno) REFERENCES HOTEL.HOTEL
    );
    
    CREATE TABLE HOTEL.CUSTOMER(
        cno INTEGER PRIMARY KEY,
        title VARCHAR(7),
        firstname VARCHAR(20),
        name VARCHAR(40) NOT NULL,
        address VARCHAR(40) NOT NULL,
        zip VARCHAR(6)
    );
    
    CREATE TABLE HOTEL.RESERVATION(
    resno INTEGER NOT NULL default autoincrement,
        rno INTEGER NOT NULL,
        cno INTEGER,
        hno INTEGER,
        type VARCHAR(6),
        arrival DATE NOT NULL,
        departure DATE NOT NULL,
        PRIMARY KEY (
            "RESNO", "ARRIVAL"
        ),
        FOREIGN KEY(hno) REFERENCES HOTEL.HOTEL,
        FOREIGN KEY(cno) REFERENCES HOTEL.CUSTOMER
    );
    
    CREATE TABLE HOTEL.MAINTENANCE(
        mno INTEGER PRIMARY KEY,
        hno INTEGER,
        description VARCHAR(100),
        date_performed DATE,
        performed_by VARCHAR(40),
        FOREIGN KEY(hno) REFERENCES HOTEL.HOTEL
    );
    
    CREATE OR REPLACE VIEW HOTEL.HOTEL_ROOMS_VIEW AS
      SELECT
        H.NAME AS HOTEL_NAME,
        R.TYPE,
        R.FREE,
        R.PRICE
      FROM HOTEL.ROOM R
        LEFT JOIN HOTEL.HOTEL H ON R.HNO = H.HNO
            ORDER BY H.NAME;
    
    CREATE OR REPLACE PROCEDURE HOTEL.SHOW_RESERVATIONS(
        IN IN_HNO INTEGER, IN IN_ARRIVAL DATE)
        RESULT (RESNO INTEGER, ARRIVAL DATE, NIGHTS INTEGER, HOTEL_NAME VARCHAR(50),TITLE VARCHAR(7), FIRST_NAME VARCHAR(20), LAST_NAME VARCHAR(40))
        BEGIN
            MESSAGE IN_HNO TO CLIENT;
            MESSAGE IN_ARRIVAL TO CLIENT;
          SELECT
            R.RESNO,
            R.ARRIVAL,
            DATEDIFF(DAY, R.ARRIVAL, R.DEPARTURE) as "Nights",
            H.NAME,
            CUS.TITLE,
            CUS.FIRSTNAME AS "FIRST NAME",
            CUS.NAME AS "LAST NAME"
          FROM
            HOTEL.RESERVATION AS R
            LEFT OUTER JOIN
            HOTEL.HOTEL AS H
            ON H.HNO = R.HNO
            LEFT OUTER JOIN
            HOTEL.CUSTOMER AS CUS
            ON CUS.CNO = R.CNO
            WHERE R.ARRIVAL = IN_ARRIVAL AND
            H.HNO = IN_HNO;
            -- ORDER BY H.NAME ASC, R.ARRIVAL DESC;  --order by ignored in views
    END;
    
    --Specify the privileges for the role HOTEL
    GRANT SELECT, UPDATE, INSERT, DELETE ON HOTEL.HOTEL, HOTEL.ROOM, HOTEL.CUSTOMER, HOTEL.RESERVATION, HOTEL.MAINTENANCE, HOTEL.HOTEL_ROOMS_VIEW TO HOTEL;
    GRANT EXECUTE ON HOTEL.SHOW_RESERVATIONS TO HOTEL;
    
    --Required permission for users that are connecting in the database explorer
    GRANT SET ANY CUSTOMER PUBLIC OPTION to HOTEL;
    
    --Create a user
    GRANT CONNECT TO USER1 IDENTIFIED BY 'Password1';
    
    -- Add USER1 to the HOTEL role
    GRANT ROLE HOTEL TO USER1;
    
    DBX Create

    Additional details on the SQL used above can be found at CREATE TABLE Statement for Data Lake IQ, CREATE VIEW Statement for Data Lake IQ, and CREATE PROCEDURE Statement for Data Lake IQ.

    Note that the identifiers such as the column names in a table are case-insensitive.

For additional details on the SAP HANA database explorer, see the tutorial Get Started with the SAP HANA Database Explorer, which showcases many of its features.

Log on to answer question
Step 5: Install the data lake IQ client
  1. In SAP Software Downloads, under Support Packages & Patches, search for HANA DATALAKE CLIENT 1.0. Select the platform (Windows or Linux) and download the archive.

    data lake software downloads

    Note access to the client install is currently limited to S-user IDs

  2. Extract the archive and start the installer.

    • On Microsoft Windows extract the zip and run setup.exe.

      data lake client
    • On Linux, extract the archive.

      tar -zxvf HANADLCLIENT10000_0*.TGZ
      

      Run setup.bin which will start either the GUI installer or text based installer.

      cd ebf*
      ./setup.bin
      
  3. Specify an install folder and install all the features.

    GUI Installer

    Console mode installer

    Product Features

    Follow the remaining prompts to finish the installation.

  4. The installation location can be referenced after the installation is complete by the following environment variable.

    ECHO %IQDIR17%
    

    Note that this tutorial uses notepad and nano as default text editors, but any text editor will do.
    nano can be installed on SUSE Linux with

    sudo zypper nano
    

    On Linux, this environment variable and others are set in a file named IQ.sh. Configure it to be run each time the Bash shell is started by referencing it in .bash_profile or possibly .bashrc.

    Open the .bash_profile.

    nano ~/.bash_profile
    

    Add the following line to point to the location where the SAP data lake client is installed.

    source /path-to-data-lake-install/IQ.sh
    

    Test the change by running:

    source ~/.bash_profile
    

    Once the shell is closed and re-opened the following command should display the install location of the data lake client.

    echo $IQDIR17
    
Log on to answer question
Step 6: Connect with the Interactive SQL Client (DBISQL)

The data lake IQ client install includes Interactive SQL (DBISQL), which can be used to connect and query a data lake IQ. The following steps will provide instructions on how to connect to the data lake IQ using DBISQL and then populate the previously created tables with sample data.

  1. Start GUI version of DBISQL from the Microsoft Windows Start menu, by double clicking on it, or on Linux by entering dbisql.

    start dbisql
  2. Specify the connection type.

    Connection type
  3. Provide the connection details.

    instance ID and landscape

    The BTP cockpit or SAP HANA Cloud Central can be used to get the instance ID and landscape values, as they are part of the SQL endpoint.

    copy sql endpoint

    A failure to connect could be caused by the allowed connections list, which is editable in SAP HANA Cloud Central.

    DBISQL Connected

    DBISQL can also be started without a GUI.

    dbisql -hdl -c "uid=USER1;pwd=Password1;host=XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX.hana.trial-XXXX.hanacloud.ondemand.com:443;ENC=TLS(tls_type=rsa;direct=yes)" -nogui
    

    Note that in a Bash shell, strings in double quotes versus single quotes are treated differently.

    dbisql -hdl -c 'uid=USER1;pwd=Password1;host=XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX.hana.trial-XXXX.hanacloud.ondemand.com:443;ENC=TLS(tls_type=rsa;direct=yes)' -nogui
    
    DBISQL connected nogui
Log on to answer question
Step 7: Insert data with Interactive SQL Client (DBISQL)
  1. Execute the following insert statements to provide some sample data.

    If you are using the nogui option, paste the insert statements into a file first and then run dbisql -hdl -c "uid..." sql.sql.

    INSERT INTO HOTEL.HOTEL VALUES(10, 'Congress', '155 Beechwood St.', 'Seattle', 'WA', '20005');
    INSERT INTO HOTEL.HOTEL VALUES(11, 'Regency', '477 17th Avenue', 'Seattle', 'WA', '20037');
    INSERT INTO HOTEL.HOTEL VALUES(12, 'Long Island', '1499 Grove Street', 'Long Island', 'NY', '11788');
    INSERT INTO HOTEL.HOTEL VALUES(13, 'Empire State', '65 Yellowstone Dr.', 'Albany', 'NY', '12203');
    INSERT INTO HOTEL.HOTEL VALUES(14, 'Midtown', '12 Barnard St.', 'New York', 'NY', '10019');
    INSERT INTO HOTEL.HOTEL VALUES(15, 'Eighth Avenue', '112 8th Avenue', 'New York', 'NY', '10019');
    INSERT INTO HOTEL.HOTEL VALUES(16, 'Lake Michigan', '354 OAK Terrace', 'Chicago', 'IL', '60601');
    INSERT INTO HOTEL.HOTEL VALUES(17, 'Airport', '650 C Parkway', 'Rosemont', 'IL', '60018');
    INSERT INTO HOTEL.HOTEL VALUES(18, 'Sunshine', '200 Yellowstone Dr.', 'Clearwater', 'FL', '33575');
    INSERT INTO HOTEL.HOTEL VALUES(19, 'Beach', '1980 34th St.', 'Daytona Beach', 'FL', '32018');
    INSERT INTO HOTEL.HOTEL VALUES(20, 'Atlantic', '111 78th St.', 'Deerfield Beach', 'FL', '33441');
    INSERT INTO HOTEL.HOTEL VALUES(21, 'Long Beach', '35 Broadway', 'Long Beach', 'CA', '90804');
    INSERT INTO HOTEL.HOTEL VALUES(22, 'Indian Horse', '16 MAIN STREET', 'Palm Springs', 'CA', '92262');
    INSERT INTO HOTEL.HOTEL VALUES(23, 'Star', '13 Beechwood Place', 'Hollywood', 'CA', '90029');
    INSERT INTO HOTEL.HOTEL VALUES(24, 'River Boat', '788 MAIN STREET', 'New Orleans', 'LA', '70112');
    INSERT INTO HOTEL.HOTEL VALUES(25, 'Ocean Star', '45 Pacific Avenue', 'Atlantic City', 'NJ', '08401');
    INSERT INTO HOTEL.HOTEL VALUES(26, 'Bella Ciente', '1407 Marshall Ave', 'Longview', 'TX', '75601');
    
    INSERT INTO HOTEL.ROOM VALUES(10, 'single', 20, 135.00);
    INSERT INTO HOTEL.ROOM VALUES(10, 'double', 45, 200.00);
    INSERT INTO HOTEL.ROOM VALUES(12, 'single', 10, 70.00);
    INSERT INTO HOTEL.ROOM VALUES(12, 'double', 13, 100.00);
    INSERT INTO HOTEL.ROOM VALUES(13, 'single', 12, 45.00);
    INSERT INTO HOTEL.ROOM VALUES(13, 'double', 15, 80.00);
    INSERT INTO HOTEL.ROOM VALUES(14, 'single', 20, 85.00);
    INSERT INTO HOTEL.ROOM VALUES(14, 'double', 35, 140.00);
    INSERT INTO HOTEL.ROOM VALUES(15, 'single', 50, 105.00);
    INSERT INTO HOTEL.ROOM VALUES(15, 'double', 230, 180.00);
    INSERT INTO HOTEL.ROOM VALUES(15, 'suite', 12, 500.00);
    INSERT INTO HOTEL.ROOM VALUES(16, 'single', 10, 120.00);
    INSERT INTO HOTEL.ROOM VALUES(16, 'double', 39, 200.00);
    INSERT INTO HOTEL.ROOM VALUES(16, 'suite', 20, 500.00);
    INSERT INTO HOTEL.ROOM VALUES(17, 'single', 4, 115.00);
    INSERT INTO HOTEL.ROOM VALUES(17, 'double', 11, 180.00);
    INSERT INTO HOTEL.ROOM VALUES(18, 'single', 15, 90.00);
    INSERT INTO HOTEL.ROOM VALUES(18, 'double', 19, 150.00);
    INSERT INTO HOTEL.ROOM VALUES(18, 'suite', 5, 400.00);
    INSERT INTO HOTEL.ROOM VALUES(19, 'single', 45, 90.00);
    INSERT INTO HOTEL.ROOM VALUES(19, 'double', 145, 150.00);
    INSERT INTO HOTEL.ROOM VALUES(19, 'suite', 60, 300.00);
    INSERT INTO HOTEL.ROOM VALUES(20, 'single', 11, 60.00);
    INSERT INTO HOTEL.ROOM VALUES(20, 'double', 24, 100.00);
    INSERT INTO HOTEL.ROOM VALUES(21, 'single', 2, 70.00);
    INSERT INTO HOTEL.ROOM VALUES(21, 'double', 10, 130.00);
    INSERT INTO HOTEL.ROOM VALUES(22, 'single', 34, 80.00);
    INSERT INTO HOTEL.ROOM VALUES(22, 'double', 78, 140.00);
    INSERT INTO HOTEL.ROOM VALUES(22, 'suite', 55, 350.00);
    INSERT INTO HOTEL.ROOM VALUES(23, 'single', 89, 160.00);
    INSERT INTO HOTEL.ROOM VALUES(23, 'double', 300, 270.00);
    INSERT INTO HOTEL.ROOM VALUES(23, 'suite', 100, 700.00);
    INSERT INTO HOTEL.ROOM VALUES(24, 'single', 10, 125.00);
    INSERT INTO HOTEL.ROOM VALUES(24, 'double', 9, 200.00);
    INSERT INTO HOTEL.ROOM VALUES(24, 'suite', 78, 600.00);
    INSERT INTO HOTEL.ROOM VALUES(25, 'single', 44, 100.00);
    INSERT INTO HOTEL.ROOM VALUES(25, 'double', 115, 190.00);
    INSERT INTO HOTEL.ROOM VALUES(25, 'suite', 6, 450.00);
    
    INSERT INTO HOTEL.CUSTOMER VALUES(1000, 'Mrs', 'Jenny', 'Porter', '1340 N. Ash Street, #3', '10580');
    INSERT INTO HOTEL.CUSTOMER VALUES(1001, 'Mr', 'Peter', 'Brown', '1001 34th St., APT.3', '48226');
    INSERT INTO HOTEL.CUSTOMER VALUES(1002, 'Company', NULL, 'Datasoft', '486 Maple St.', '90018');
    INSERT INTO HOTEL.CUSTOMER VALUES(1003, 'Mrs', 'Rose', 'Brian', '500 Yellowstone Drive, #2', '75243');
    INSERT INTO HOTEL.CUSTOMER VALUES(1004, 'Mrs', 'Mary', 'Griffith', '3401 Elder Lane', '20005');
    INSERT INTO HOTEL.CUSTOMER VALUES(1005, 'Mr', 'Martin', 'Randolph', '340 MAIN STREET, #7', '60615');
    INSERT INTO HOTEL.CUSTOMER VALUES(1006, 'Mrs', 'Sally', 'Smith', '250 Curtis Street', '75243');
    INSERT INTO HOTEL.CUSTOMER VALUES(1007, 'Mr', 'Mike', 'Jackson', '133 BROADWAY APT. 1', '45211');
    INSERT INTO HOTEL.CUSTOMER VALUES(1008, 'Mrs', 'Rita', 'Doe', '2000 Humboldt St., #6', '97213');
    INSERT INTO HOTEL.CUSTOMER VALUES(1009, 'Mr', 'George', 'Howe', '111 B Parkway, #23', '75243');
    INSERT INTO HOTEL.CUSTOMER VALUES(1010, 'Mr', 'Frank', 'Miller', '27 5th St., 76', '95054');
    INSERT INTO HOTEL.CUSTOMER VALUES(1011, 'Mrs', 'Susan', 'Baker', '200 MAIN STREET, #94', '90018');
    INSERT INTO HOTEL.CUSTOMER VALUES(1012, 'Mr', 'Joseph', 'Peters', '700 S. Ash St., APT.12', '92714');
    INSERT INTO HOTEL.CUSTOMER VALUES(1013, 'Company', NULL, 'TOOLware', '410 Mariposa St., #10', '20019');
    INSERT INTO HOTEL.CUSTOMER VALUES(1014, 'Mr', 'Antony', 'Jenkins', '55 A Parkway, #15', '20903');
    
    INSERT INTO HOTEL.RESERVATION(rno, cno, hno, type, arrival, departure) VALUES(100, 1000, 11, 'single', '2020-12-24', '2020-12-27');
    INSERT INTO HOTEL.RESERVATION(rno, cno, hno, type, arrival, departure) VALUES(110, 1001, 11, 'double', '2020-12-24', '2021-01-03');
    INSERT INTO HOTEL.RESERVATION(rno, cno, hno, type, arrival, departure) VALUES(120, 1002, 15, 'suite', '2020-11-14', '2020-11-18');
    INSERT INTO HOTEL.RESERVATION(rno, cno, hno, type, arrival, departure) VALUES(130, 1009, 21, 'single', '2019-02-01', '2019-02-03');
    INSERT INTO HOTEL.RESERVATION(rno, cno, hno, type, arrival, departure) VALUES(150, 1006, 17, 'double', '2019-03-14', '2019-03-24');
    INSERT INTO HOTEL.RESERVATION(rno, cno, hno, type, arrival, departure) VALUES(140, 1013, 20, 'double', '2020-04-12', '2020-04-30');
    INSERT INTO HOTEL.RESERVATION(rno, cno, hno, type, arrival, departure) VALUES(160, 1011, 17, 'single', '2020-04-12', '2020-04-15');
    INSERT INTO HOTEL.RESERVATION(rno, cno, hno, type, arrival, departure) VALUES(170, 1014, 25, 'suite', '2020-09-01', '2020-09-03');
    INSERT INTO HOTEL.RESERVATION(rno, cno, hno, type, arrival, departure) VALUES(180, 1001, 22, 'double', '2020-12-23', '2021-01-08');
    INSERT INTO HOTEL.RESERVATION(rno, cno, hno, type, arrival, departure) VALUES(190, 1013, 24, 'double', '2020-11-14', '2020-11-17');
    
    INSERT INTO HOTEL.MAINTENANCE VALUES(10, 24, 'Replace pool liner and pump', '2019-03-21', 'Discount Pool Supplies');
    INSERT INTO HOTEL.MAINTENANCE VALUES(11, 25, 'Renovate the bar area.  Replace TV and speakers', '2020-11-29', 'TV and Audio Superstore');
    INSERT INTO HOTEL.MAINTENANCE VALUES(12, 26, 'Roof repair due to storm', null, null);
    

    Additional details on the SQL used above can be found at INSERT Statement for Data Lake IQ.

    Note that autocommit is set to on in the SQL Console of the database explorer, while in DBISQL it is set to off. A series of insert statements will run quicker in the SQL Console if they are surrounded with begin and end or if autocommit is set to off.

    begin
    INSERT INTO HOTEL.ROOM VALUES(11, 'single', 13, 135.00);
    INSERT INTO HOTEL.ROOM VALUES(11, 'double', 15, 175.00);
    end;
    
    set temporary option auto_commit= 'off';
    INSERT INTO HOTEL.ROOM VALUES(11, 'triple', 7, 235.00);
    INSERT INTO HOTEL.ROOM VALUES(11, 'quad', 5, 275.00);
    set temporary option auto_commit= 'on';
    
  2. Notice that pressing ctrl-space brings up auto complete (GUI mode only).

    auto complete

    Execute a stored procedure and query a table.

    CALL HOTEL.SHOW_RESERVATIONS(11, '2020-12-24');
    SELECT * FROM HOTEL.HOTEL;
    
    Query in DBISQL
  3. DBISQL can also execute SQL from the command line or from a provided file. A few examples are shown below.

    dbisql -hdl -c "uid=USER1;pwd=Password1;host=XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX.hana.trial-XXXX.hanacloud.ondemand.com:443;ENC=TLS(tls_type=rsa;direct=yes)" "select * from HOTEL.CUSTOMER;"
    dbisql -hdl -c "uid=USER1;pwd=Password1;host=XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX.hana.trial-XXXX.hanacloud.ondemand.com:443;ENC=TLS(tls_type=rsa;direct=yes)" sql.sql
    
    DBISQL in batch mode

    See Connection Parameters for additional documentation on the parameters used to connect.

Congratulations! You have created and connected to a data lake IQ. In the following tutorials, the client interfaces will be used to connect from ODBC, JDBC and Node.js.

Which of the following are true for data lake IQ?
×

Next Steps

Back to top