Integrating NPSaaS with watsonx.data

Before you begin

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

1. Go to https://cloud.ibm.com/.

2. At the top of the page, from the Manage sub-menu, select Access (IAM).

3. Click Service IDs and Create.

4. Provide Create service ID details.

5. 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.

6. Click the API keys tab and click Create.

7. Provide Create API key details. You must name the API key as ibmlhapikey.

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-hms create -connection-name <your connection name> -hms-token <your API key obtained in the `Before you begin` section> -hms-user "ibmlhapikey" -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. You also must 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.
• 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.