IBM Cloud Docs
Integrating NPSaaS with watsonx.data

Integrating NPSaaS with watsonx.data

You can integrate your IBM® Netezza® Performance Server for IBM Cloud Pak® for Data as a Service instance with watsonx.data.

Before you begin

Ensure that you obtained the IBM API key by following the steps:

  1. Login to the IBM SaaS Console.

  2. Select the account that is associated with your subscription. The Subscriptions page opens.

  3. From the Subscriptions page, find the subscription for the instance that you want to add a service ID to. Then, click View subscription details.

  4. Click the instance where you want to add a service ID. The Instance details tab opens.

  5. Select the Service IDs tab and click Create service ID. The Create service ID window opens.

  6. In the window, enter a name and choose a role for your service ID.

    • The Service admin role can view, create, update, and delete users, roles, and groups for an instance.
    • The Service owner role can take the same actions as the Service admin.
    • The Service user role can view the instance, but this role doesn't include permissions that are related to user management like adding more users.
    • Service level roles:
      • MetastoreAccess - External users with read access to the metadata through HMS REST APIs in watsonx.data.
      • DataAccess - Only supports IKC-watsonx.data service-to-service authorization to profile data in watsonx.data.

  7. Click Create. The service ID is created and appears in the table on the Service IDs tab.

  8. Click Options for the service ID and click View service ID details.

  9. From the Service ID page, click Generate key.

  10. In the Generate API key window, enter an API key name and the expiration date and click Generate key.

    You must name the API key as ibmlhapikey_Serviceid-<ID_OF_THE_NEW_SERVICE_ID_CREATED>. The ID_OF_THE_NEW_SERVICE_ID_CREATED can be obtained from the MCSP SaaS console. For example: ibmlhapikey_Serviceid-b8fd5bbf-a95e-4664-85f7-282047433195

  11. Copy the API key from the window.

Integrating NPSaaS instance or remote client with watsonx.data by using nzcli

  1. Download nz tool.

    curl -o nz -k <name of the API server URL from namespace provisioning page>/v2/download/nz-linux-amd64

  2. Set up the environment variables.

    export APISERVER_URL=<name of the API server URL from namespace provisioning page>
export NZ_USER=<admin user name>
export NZ_PASSWORD=<admin user password>

  3. Change the permissions on nzcli executable.

    chmod +x nz

  4. Set up HMS with nz tool.

     ./nz setup-ms create -connection-name <your connection name> -hms-token <your API key obtained in the `Before you begin` section> -hms-user `ibmlhapikey_Serviceid-<ID_OF_THE_NEW_SERVICE_ID_CREATED>` -url <thrift endpoint URL retrieved from watsonx.data instance>

Where:

  • url is the thrift endpoint URL, which you retrieve from watsonx.data instance. For more information, see Getting the HMS endpoint. Ensure that the url is in the following thrift://<host>:<port> format when you run nz setup-hms command.
  • hms-user is by default ibmlhapikey_Serviceid-<ID_OF_THE_NEW_SERVICE_ID_CREATED>.
  • hms-token is your API key obtained in the Before you begin section.

After you registered to watsonx.data, you can create a remote database.

  1. Log in to your NPSaaS web console or download nzsql command-line tool from here.
  2. Query your data from watsonx.data. For more information, see Querying data from watsonx.data.