Pre-requisites

• Tableau desktop: Download and install the latest desktop version of Tableau on your computer.

• Subscription to watsonx.data on IBM Cloud.

• Provision watsonx.data instance with Presto engine.

• Download the Presto JDBC driver from JDBC Driver. To download:

  a. Log in to Tableau.

  b. Access Resources > Support > Driver Download.

  c. Select Presto from the Data Source list.

  d. Select the Platform that you use. The list of drivers are available.

  c. Select the required JDBC driver. Follow the instructions in the section to download and install the driver (You need to download the .jar file and add it to the folder in your computer ~/Library/Tableau/Drivers).

Authentication

Tableau uses Lightweight Directory Access Protocol (LDAP) authentication mechanism to connect to Presto. You need the following sign-in credentials:

• Username: Username is ibmlhapikey_<watsonx.datauser_id>.
• Password: The API key of the watosnx.data user.

Connecting to Presto by configuring details manually

1. Open Tableau desktop.

2. Click More and select Presto. The Presto window opens.

3. In the General tab, provide the following details:

   • Server : Hostname of the Presto engine in watsonx.data that you want to connect to. For more information about retrieving the hostname, see Getting connection information.
   • Port : For more information about retrieving the port number, see Getting connection information.
   • Catalog : Enter the Iceberg catalog that is associated with the Presto engine in watsonx.data.
   • Schema (Optional) : Enter the name of the schema that is associated with your data.
   • Authentication : Select LDAP from the list.
   • Username : The username is ibmlhapikey_<watsonx.datauser_id>. For example, ibmlhapikey_joe@ibm.com.
   • Password : The API key of the watosnx.data user. For more information about retrieving the API key, see Generating the API key.

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.

Connecting to Presto by using TDS file

In this method, you can select the catalog that you want to analyse in Tableau from the watsonx.data console and watsonx.data generates a Data source files (TDS). This file can be used to access watsonx.data catalog directly in Tableau without any Presto configurations.

TDS files are shortcuts for quickly connecting to the original data that you use often. Data source files do not contain the actual data but rather the information necessary to connect to the actual data. For more information, see Save Data Sources.

1. Log in to the watsonx.data instance.
2. Go to Configurations.
3. Click Connection information page.
4. Expand BI Tools and select Tableau.
5. From the Connection Details section, expand the Presto engine.
6. Use the Edit catalog icon in the Catalog field to select the required catalog for data analysis.
7. Click the Export TDS link to download the data source file. Click the downloaded file. The Tableau desktop opens and the Catalog page is displayed. You can select the schemas and tables for analysis.
8. For more information about establishing a connection, see Tableau documentation.

Performing data analysis

1. From the Data Source page, you can view the Iceberg 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.