Set up for HP Neoview Tables and Netezza Tables

To access HP Neoview tables or Netezza tables in SAS Data Integration Studio, administrators must first register the appropriate servers and libraries. Before registering servers and libraries for Neoview or Netezza, administrators must add resource templates for these databases.

To add resource templates for Neoview and Netezza, follow these steps once per metadata server. Repeat for all metadata servers that SAS Data Integration Studio users access.

1. Open SAS Management Console.

2. In the Repository box, select Foundation.

3. In the Plugins tab, expand the Metadata Manager.

4. Right-click the Resource Templates folder and select Add Resource Template.

5. In the Add Resource Template Wizard, select Custom, and then click Next.

6. To find the folder that contains the resource templates for HP Neoview and Netezza, click Add. A window displays the file system where SAS Management Console 9.2 is installed.

7. Navigate to the folder where SAS Management Console 9.2 is installed. Expand that folder, and then expand the 9.2 subfolder.

8. In the 9.2 subfolder, expand the Resource Templates subfolder. You should see the following templates: Neoview_Library.zip, Neoview_Server.zip, Netezza_Library.zip, and Netezza_Server.zip. Install both the library template and the server template for each new database that you want to access.

9. Select a template (such as Neoview_Library.zip) and click OK. The template is added to the window in the wizard. Repeat Steps 6, 7, and 8 for each template that you want to add. When all of the desired templates have been added to the window, click Next.

10. Review the templates to be installed, and then click Finish. The templates are installed in the Resource Templates folder in SAS Management Console.

Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.