0 / 0
IBM watsonx.data connection

IBM watsonx.data connection

To access your data in a database in IBM watsonx.data, create a connection asset for it.

IBM watsonx.data is an open, hybrid, and governed data lakehouse that is optimized by a query engine for all data and AI workloads.

Prerequisite

Set up an instance of watsonx.data. You can connect to an instance of watsonx.data on Cloud Pak for Data, IBM Cloud, or stand-alone watsonx.data:

Create a connection to watsonx.data

Connection details

To create the connection asset, you need these details for the watsonx.data instance:

Select Connect to watsonx.data on Cloud Pak for Data if you are connecting to an instance of watsonx.data that is deployed on Cloud Pak for Data.

  • Hostname or IP address: Find this information in the URL of the watsonx.data web console. https://<hostname-or-IPaddress>/watsonx-data/#/home?instanceId=<instance-id>

  • Port: The default port number is 443. If the connection has a different port, you can find this number in the URL of the watsonx.data web console.

  • Instance ID: Find this value in the watsonx.data console navigation menu. Click the Instance details link.

  • Instance name:

    • Cloud Pak for Data: Find the instance name in the Cloud Pak for Data web client home page at Services > Instances.
    • IBM Cloud or stand-alone watsonx.data: The default value is lh-default.
  • CRN: Cloud resource name: This field is needed only for connections to IBM Cloud. Find this information in the IBM Cloud resource list for the watsonx.data service.

Credentials

Username and password for the watsonx.data instance. The same credentials are used for the engine.

  • For watsonx.data that is deployed on Cloud Pak for Data, use the username and password that is used to access Cloud Pak for Data.
  • For watsonx.data that is deployed on IBM Cloud, the default username is ibmlhapikey_<cloud-account-email-address>. For example: [email protected]. The password is the user's API key.

Certificates

By default, SSL is enabled is selected. This setting is recommended for increased security. If you do not use SSL, the data might be subject to vulnerabilities such as data leakage. Although the database that is hosted in watsonx.data can also have an SSL certificate, the connection goes through the engine.

If SSL is enabled on a watsonx.data instance on Cloud Pak for Data and the certificate is a self-signed certificate, you must enter the certificate in the SSL certificate field.

For an instance on IBM Cloud, the certificate is optional.

The SSL certificate must be in PEM format for both a watsonx.data instance on Cloud Pak for Data or IBM Cloud.

Ask your watsonx.data administrator if SSL is set up. To obtain the certificate of an IBM watsonx.data instance on Cloud Pak for Data, run this command:

openssl s_client -showcerts -connect <cpd_hostname>:<cpd_port>

For example:
openssl s_client -showcerts -connect cpd.myserver.example.com:443

Engine connection details

  • Engine's hostname or IP address:

    • watsonx.data instance on Cloud Pak for Data:
      1. Expose the secure route to Presto server. This task is done by the administrator. See Exposing secure route to Presto server.
      2. In the watsonx.data console, open the Infrastructure manager and go to the Details page. Under Engine details, the hostname or IP address is the value of the External host.
    • watsonx.data instance on IBM Cloud: Find this information in the watsonx.data web console. Open the Infrastructure manager and go to the Details page. Under Engine details, the hostname or IP address is the value in the Host field before the colon (:).
  • Engine ID: Find this information in the watsonx.data web console. Go to the Infrastructure manager and click the engine's name.

  • Engine's port:

    • watsonx.data instance on Cloud Pak for Data: The port number is determined by which port is exposed by the administrator. See Exposing secure route to Presto server. The default port number is 443.
    • watsonx.data instance on IBM Cloud: Find this information in the watsonx.data web console. Open the Infrastructure manager and go to the Details page. Under Engine details, the port number is the value in the Host field after the colon (:).

Choose the method for creating a connection based on where you are in the platform

In a project
Click Assets > New asset > Data access tools > Connection. See Adding a connection to a project.

In a catalog
Click Add to catalog > Connection. See Adding a connection asset to a catalog.

In the Platform assets catalog
Click New connection. See Adding platform connections.

Next step: Add data assets from the connection

Where you can use this connection

You can use the watsonx.data connection in the following workspaces and tools:

Projects

Catalogs

  • Platform assets catalog
  • Other catalogs (IBM Knowledge Catalog)

Restrictions

  • Only the Presto engine is supported.
  • You can use this connection only for source data. You cannot write to data or export data with this connection.

watsonx.data web console

Learn more

Related connection: Presto connection

Parent topic: Supported connections

Generative AI search and answer
These answers are generated by a large language model in watsonx.ai based on content from the product documentation. Learn more