IBM watsonx.data connection

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. Cloud Pak for Data credentials that use an Identity Management Service (IAM), for example, LDAP or SSO, are not supported.
• 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

• See Add data from a connection in a project.

• See Add data from a connection in a catalog.