Connecting Domo to Presto in watsonx.data

This topic provides you with the procedure to connect Domo 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

  • Download Domo Workbench.
  • Log in to your Domo account and configure Domo Workbench.
  • Install watsonx.data.
  • Provision watsonx.data instance with Presto engine.
  • Download the Presto ODBC driver from trusted sources. For example: Simba. Setup the system SDN. For more information about setting up SDN, see Power BI Simba.

Authentication

ODBC Data Source Name(DSN) uses Lightweight Directory Access Protocol (LDAP) authentication mechanism to connect to Presto. You need the following sign-in credentials:
  • Username: Username is ibmlhapikey_admin.
  • 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.

Connecting to Presto

  1. Open Domo Workbench.
  2. In the overview section, enter the Domo account details in the Domain name field.
  3. Provide the authentication details, verification code and click Submit.
  4. From the navigation menu, select DataSet Jobs. Configure the Presto account and provide the following connection details:
    • Job name: Provide a name for the connection.
    • Transportation Type: Select ODBC Connection Provider as the type.
    • Reader Type: Select Database Query from the list.
    • Click Create.
    • Select the Configure tab. Click Edit from the Source field. The ODBC Connection Provider Editor page opens.
    • Select Presto from the System DSN list.
    • Select Requires Credentials check box.
    • 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.
    • Click Apply.
    • In the Configure tab, you can select the Edit option in the Processing field to provide a database query that you want to perform. For example, SELECT * FROM "<DB_NAME>"."<CATALOG_NAME"."<TABLE_NAME>"
    Note: You can configure additional details, to do that, see Domo documentation.
  5. Open your Domo account. Click Data and select Data Sets from the navigation menu. In this page, you can view the table data from the DATA tab, create visualization, share the dataset, and cleanup the data set.