Creating a Data Source Name

Typically, after installing the Simba Netezza ODBC Driver, you need to create a Data Source Name (DSN). A DSN is a data structure that stores connection information so that it can be used by the connector to connect to Netezza.

Alternatively, you can specify connection settings in a connection string or as connector-wide settings. Settings in the connection string take precedence over settings in the DSN, and settings in the DSN take precedence over connector-wide settings.

The following instructions describe how to create a DSN. For information about specifying settings in a connection string, see Using a Connection String. For information about connector-wide settings, see Setting Connector-Wide Configuration Options.

For detailed information about the options on this page, see General Driver Configuration Options.

To create a Data Source Name:

  1. From the Start menu, go to ODBC Data Sources.

    2. Note:

    Make sure to select the ODBC Data Source Administrator that has the same bitness as the client application that you are using to connect to Netezza.

  2. In the ODBC Data Source Administrator, click the Drivers tab, and then scroll down as needed to confirm that the Simba Netezza ODBC Driver appears in the alphabetical list of ODBC drivers that are installed on your system.
  3. Choose one:
    • To create a DSN that only the user currently logged into Windows can use, click the User DSN tab.
    • Or, to create a DSN that all users who log into Windows can use, click the System DSN tab.

    Note:

    It is recommended that you create a System DSN instead of a User DSN. Some applications load the data using a different user account, and might not be able to detect User DSNs that are created under another user account.

  4. Click Add.
  5. In the Create New Data Source dialog box, select Simba Netezza ODBC Driver and then click Finish. The Simba Netezza ODBC Driver DSN Setup dialog box opens.
  6. In the Data Source Name field, type a name for your DSN.
  7. Optionally, in the Description field, type relevant details about the DSN.
  1. In the Server field, type the name or IP address of the Netezza server.
  2. In the Port field, type the number of the TCP port that the server uses to listen for client connections.

    3. Note:

    The default port used by Netezza is 5480.

  3. In the Database field, type the service name of the Netezza database that you want to access.
  4. In the Schema field, type the name of the Netezza schema to use.
  5. Configure authentication by doing one of the following:
    • If your Netezza server is configured to authenticate the connection using Active Directory or MIT Kerberos, then in the User Name field, type your user name for accessing the database.
    • Or, if your Netezza server is configured to authenticate the connection using another authentication method, then in the User Name and Password fields, type your user name and password for accessing the database.

    Note:

    Kerberos authentication on Netezza must be configured on the server.

  6. To configure logging behavior for the connector, click Logging Options. For more information, see Configuring Logging Options.
  7. To configure additional connector options, select a tab:
  8. To test the connection, click Test. Review the results as needed, and then click OK.

    9. Note:

    If the connection fails, then confirm that the settings in the Simba Netezza ODBC Driver DSN Setup dialog box are correct. Contact your Netezza server administrator as needed.

  9. To save your settings and close the Simba Netezza ODBC Driver DSN Setup dialog box, click OK.
  10. To close the ODBC Data Source Administrator, click OK.

Related topics