Configuring the ODBC data source and driver (Windows)
When you install an IBM® Netezza® ODBC driver, the installation program
creates an entry for a system data source called NZSQL. You then configure that data source to
connect to a Netezza appliance data
source. You can also configure a user data source.
A system DSN defines a data source
that is available to all users of the client system. A user DSN defines a data source that is
available only to the user who defined it.
Before you begin
Get the following configuration information from your Netezza system administrator:
- The name of the database (and schema, if the database supports multiple schemas) on the Netezza appliance
- The server host name or IP address of your Netezza appliance
- A valid user ID for accessing the system or user data source
- A valid password for accessing the system or user data source