IBM Cloud Docs
IBM watsonx.data

IBM watsonx.data

IBM watsonx.data is a governed data lakehouse optimized for data and AI workloads. Integrating IBM watsonx BI with watsonx.data lets you access structured, semi-structured, and unstructured data for AI and business intelligence, simplifying its use for data scientists and data analysts.

Watsonx BI and watsonx.data integration support the following connectors:

  • IBM watsonx.data Presto

  • Presto

Prerequisites

  • A working watsonx BI environment

  • A working watsonx.data environment

Connecting to watsonx.data from watsonx BI

You can add a connection from the Data and Metrics in watsonx BI when you create metrics.

  1. On the Data and Metrics, click Create metrics and give your semantic data model a name.

  2. On the Add data page, click New connection.

  3. Select IBM watsonx.data Presto or Presto from the list of data sources.

  4. Enter the connection information for the connector you chose:

    IBM watsonx.data Presto

    To use this connector, you need to set up service-to-service authorization between IBM watsonx.data intelligence and IBM watsonx.data. This configuration allows watsonx BI to run profiling and metadata enrichment jobs. For more information, see Service to service authorization.

    New connection with IBM watsonx.data Presto
    Field Description
    Name Enter the name of the connection.
    Description Enter a connection description.
    Select the environment Do not select the checkbox.
    Hostname or IP address Enter the watsonx.data instance URL. For information about retrieving the hostname, see Getting connection information.
    Port Enter the port number. For information about retrieving the Port, see Getting connection information.
    Instance ID Enter the instance ID. You can get the instance ID from the watsonx.data instance home page (information icon).
    Instance name Enter the watsonx.data instance name.
    CRN Enter the Cloud Resource Name. You can get the CRN from the watsonx.data instance home page (information icon).
    Username Enter your username (ibmlhapikey_<EMAIL_ID>).
    Password Enter your password or IAM API key. To create an API key, see Creating an API key.
    SSL is enabled Select the checkbox.
    SSL Certificate Download the certificate from the watsonx.data console by using a web browser and paste in this field.
    Engine's hostname or IP address Enter the engine hostname available in the watsonx.data console without port number and :.
    Engine ID Enter the engine ID available in the watsonx.data console.
    Engine's port Enter the engine port number available with the engine hostname.

    Presto

    New connection with Presto
    Field Description
    Name Enter the name of the connection.
    Description Enter a connection description.
    Select the environment Do not select the checkbox.
    Hostname or IP address Enter the watsonx.data instance URL. For information about retrieving the hostname, see Getting connection information.
    Port Enter the port number. For information about retrieving the Port, see Getting connection information.
    Username Enter your username (ibmlhapikey_<EMAIL_ID>).
    Password Enter your password or IAM API key. To create an API key, see Creating an API key.
    SSL is enabled Select the checkbox.
    SSL Certificate Download the certificate from the watsonx.data console by using a web browser and paste in this field.

  5. Test the connection, then click Create.

You can now select data from the newly created connection to watsonx.data and continue with the create metrics flow. For more information about creating metrics, see Overview of creating metrics.