Table of Contents

Search

  1. Preface
  2. Using Metadata Manager
  3. Configuring Metadata Manager
  4. Application Resources
  5. Business Glossary Resources
  6. Business Intelligence Resources
  7. Custom Resources
  8. Data Integration Resources
  9. Data Modeling Resources
  10. Database Management Resources
  11. Universal Resources
  12. Managing Resources
  13. Loading and Monitoring Resources
  14. Managing Permissions
  15. Resource Migration
  16. Repository Migration
  17. Appendix A: Metadata Manager Login
  18. Appendix B: Metadata Manager Properties Files
  19. Appendix C: Resource Configuration Files
  20. Appendix D: Glossary

Metadata Manager Administrator Guide

Metadata Manager Administrator Guide

Install the Netezza ODBC Driver and Create a DSN

Install the Netezza ODBC Driver and Create a DSN

To access a Netezza database, install the Netezza ODBC driver on the node where the PowerCenter Integration Service runs, and then create a DSN.
  1. Download and install the Netezza ODBC driver from the IBM web site.
  2. From the Microsoft Windows Control Panel, click
    Administrative Tools
    Data Sources (ODBC)
    .
  3. On the
    System DSN
    tab, Click
    Add
    .
    The
    Create New Data Source
    window appears.
  4. Select
    NetezzaSQL
    , and click
    Finish
    .
    The
    NetezzaSQL ODBC Datasource Connection
    dialog box appears.
  5. Enter the following information:
    Field
    Description
    Data Source
    Name for the data source. Metadata Manager uses the data source name as a connect string.
    Description
    Optional description.
    Database
    Name of the Netezza database.
    Server
    Host name of the Netezza database server.
    Port
    Port number of the Netezza database server.
    User name
    Netezza database user name. Metadata Manager uses this user name to access metadata in the Netezza database.
    Password
    Password for the Netezza database user name.
  6. Click
    OK
    .

0 COMMENTS

We’d like to hear from you!