Connecting Tableau to Presto in watsonx.data

This topic provides you with the procedure to connect Tableau to Presto. When you connect to the Presto engine in watsonx.data, you can access the various connected data sources and build compelling and interactive data visualizations.

Before you begin

  • Install watsonx.data.
  • Provision watsonx.data instance with Presto engine.
  • Tableau desktop: Download and install the latest desktop version of Tableau on your computer.
  • Download the Presto ODBC driver from ODBC Driver. Select the platform and follow the instructions in the section to download and install the driver.

Authentication

Tableau 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.datalogin_name> and API key.

Connecting to Presto

  1. Open Tableau desktop.
  2. Click More and select Presto. The Presto window opens.
  3. In the General tab, provide the following details:
    • Retrieve the Server, Port, and Catalog from the watsonx.data Connection information page. For more information, see Getting connection information.
    • Schema (Optional) : Enter the name of the schema that is associated with your data.
    • Authentication : Select LDAP from the list.
    • Username: Username is ibmlhapikey_<watsonx.datalogin_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 Tableau. For more information about how to embed the certificate, see Embed a certificate.

  4. In the Initial SQL tab (Optional), specify the initial SQL query that you want to run when a connection is made to Presto.

  5. Click Sign In. The Data Source page opens when connection is successful.

For more information about establishing connection, see Tableau documentation.

Performing data analysis

  1. From the Data Source page, you can view the catalog.
  2. Select a schema from the Schema drop-down list.
  3. Select a table from the Tables field.
  4. Drag the table to create the data model.

For more information, see Connect to a Custom SQL Query.