Connecting Qlik to Presto in watsonx.data

This topic provides you the procedure to connect Qlik to Presto. When you connect to the Presto engine in watsonx.data, you can access the various connected data sources and perform data integration and analytics solutions that support your AI strategy.

Before you begin

  • Install Qlik on your computer.
  • Install watsonx.data.
  • Provision watsonx.data instance with Presto engine.
  • Download the Presto ODBC driver from ODBC Driver. Follow the instructions in the section to download and install the driver.

Authentication

Qlik uses Lightweight Directory Access Protocol (LDAP) authentication mechanism to connect to Presto. You can use the username and password of the watsonx.data console login, or use the ibmlhapikey_<watsonx.data_login_name> and API key.

Connecting to Presto

  1. Log in to Qlik.

  2. From the Home page, click Create > Analytics App. The Create a new app page opens.

  3. Provide a name for the integration and click Create.

  4. To add data to the app, click Files and other sources.

  5. Search for Presto in the Connect to a new data source section.

  6. In the Create new connection (Presto) window, provide the following details:

    • Retrieve the Server, Port, and Catalog from the watsonx.data Connection information page. For more information, see Getting connection information.
    • Authentication : Select LDAP from the list.
    • Username: Username is ibmlhapikey_<watsonx.data_login_name>.
    • Password: The API key of the watsonx.data user. To generate API key, log in into the watsonx.data console and navigate to Profile > Profile and Settings > API Keys and generate a new API key.
      Important: Generating new API key will revoke the existing one, and will impact the services that uses the old key.
      Note: You can also provide the watsonx.data console credentials as the Username and Password.
    • Require SSL : Select the check box. To setup the SSL connection, copy the SSL Certificate from watsonx.data > Connection information > IBM products > Instance Details > SSL Certificate. For more information about retrieving the SSL certificate, see Getting connection information. Embed the copied SSL certificate in Qlik. For more information, see Setting SSL options.

  7. Click Test connection to verify that the connection is successful.

  8. You can click Create when your test connection is successful. The Data Source page opens when connection is successful.

Performing data analysis

  1. In the Data Source page, from the Database list, select the catalog.
  2. Select the schema from the Owner field. The tables are listed.
  3. Select the required table and click Preview.
  4. Click Next. The Catalog page opens. The page lists the tables available in the schema.