Diagnosing The Problem

This document describes how to link the SQL Server to the Netezza server with no default catalog specified, and then reference catalogs/databases specifically through the single linked server.

1. Install the oledb driver on the system.
2. In MS SQL Server, created a linked server by filling in the following fields:

Linked server: HELIOS2
Provider: Netezza OLE DB Data Provider
Product name: NZ 
Data source: helios (or helios.netezza.com or ip address)

You can leave the following fields blank: Provider string, Location, and Catalog


3. Select the Security page (in the upper left pane).
4. Select Be made using this security context. 
5. Specify the remote login account. In this example, it is the admin account.
 
Note: The user account that you associate with the linked server must have the appropriate permissions for the databases/catalogs the account will access.


6. Specify the password for the remote login account and click OK.



7. Select New Query. Use the openquery function in SQL server and construct the query with the catalog.schema.object_name syntax.



This query is accessing the 'adam_test' database and the 'employees' table under the admin schema (which is the user account that was used for the connection). 

You can now construct similar queries against other databases without changing the linked server setup. The only requirement is that the user account associated with the linked server must have the appropriate permissions for the databases/catalogs that the account will access.