---
name: netezza-integrating_watsonx
title: Integrating NPSaaS with watsonx.data
description: ''
last-updated: 2026-2-24
---

> ## Documentation Index
> The table of contents for this documentation set is at https://cloud.ibm.com/docs/netezza?format=markdown
> The index for all IBM Cloud docs is at: https://cloud.ibm.com/docs/llms.txt
> Use these files to discover more information as needed.

{:new_window: target="_blank"}
{:shortdesc: .shortdesc}
{:screen: .screen}
{:pre: .pre}
{:table: .aria-labeledby="caption"}
{:codeblock: .codeblock}
{:tip: .tip}
{:download: .download}
{:important: .important}
{:caption: .caption}
{:note: .note}

# Integrating NPSaaS with watsonx.data
{: #integratenps_watsonx.data}

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

NPSaaS provides support for the Metastore Thrift endpoint in watsonx.data SaaS version 2.3 and earlier.
{: note}

## Before you begin
{: #prereqswatsonx.data}

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

1. Go to https://cloud.ibm.com/.
1. At the top of the page, from the **Manage** sub-menu, select **Access (IAM)**.
1. Click **Service IDs** and **Create**.
1. Provide **Create service ID** details.
1. On the **Access** tab, perform the following actions:

   a. Click **Assign access**.

   b. In the **Service** search field, type watsonx.data and click it. Click **Next**.

   c. In the **Resources** section, ensure that **All resources** is selected. Click **Next**.

   d. In the **Roles and actions** section, select **MetastoreAccess** and **Administrator**, and click **Next**.

   e. Click **Add** and **Assign**.

1.	At the top of the page, from the Manage sub-menu, select Access (IAM). Click the **API keys** tab and click **Create**.
1. Provide **Create API key** details.
   You can give any name to the API key.

## Integrating NPSaaS instance or remote client with watsonx.data by using `nzcli`.
{: #integratesteps_watsonx.data}

1. Download `nz` tool.

   ```sql
   curl -o nz -k <name of the API server URL from namespace provisioning page>/v2/download/nz-linux-amd64
   ```
   {: codeblock}

1. Set up the environment variables.

   ```sql
   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>
   ```
   {: codeblock}

1. Change the permissions on `nzcli` executable.

   ```sql
   chmod +x nz
   ```
   {: codeblock}

1. Set up HMS with `nz` tool.

   ```sql
    ./nz setup-hms create -connection-name <your connection name> -hms-token <your API key obtained in the `Before you begin` section> -hms-user "ibmlhapikey_<user ID>" -url <thrift endpoint URL retrieved from watsonx.data instance>
   ```
   {: codeblock}

Where:

- `url` is the thrift endpoint URL which you retrieve from watsonx.data instance. For more information, see [Getting the HMS endpoint](https://cloud.ibm.com/docs/watsonxdata?topic=watsonxdata-hms&format=markdown#hms_url). You also must ensure that the `url` is in the following `thrift://<host>:<port>` format when you run `nz setup-hms` command.
- `User ID` can be obtained from the `ibmcloud` profile page.
- `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](https://www.ibm.com/support/fixcentral/swg/downloadFixes?parent=ibm%7EWebSphere&product=ibm/WebSphere/IBM+Cloud+Private+for+Data+System&release=NPS_11.2&platform=All&function=fixId&fixids=11.2.2.7-WS-ICPDS-NPS-Clients-fp20684&includeRequisites=1&includeSupersedes=0&downloadMethod=http&login=true&login=true).
1. Query your data from watsonx.data. For more information, see [Querying data from watsonx.data](https://cloud.ibm.com/docs/netezza?topic=netezza-querying_watsonx.data&format=markdown).