Configuring the ODBC data source (UNIX and Linux®)

Configuring the data source requires configuring the .odbc.ini configuration file.

1. Do the initial setup for the .odbc.ini configuration file.
   As with the .obdcinst.ini file, you normally place the .odbc.ini configuration file in your home directory while logged in as an ordinary user. In some cases, you might want to place the .odbc.ini file in another location, and you might want to do the configuration as the superuser rather than as an ordinary user. In this step, it is assumed that you are logged in as an ordinary user and are using your home directory for the .odbc.ini file. What you do in this step depends on whether the .odbc.ini file already exists in your home directory:
   • The configuration file exists.

     If the .odbc.ini configuration file exists in your home directory, use a text editor to examine the contents of the file to see whether it contains entries for the Netezza Performance Server system data sources to access. If it does not, copy the contents of the odbc.ini.sample file to the end of your .odbc.ini file. Do not modify any existing entries in the file.

   • The configuration file does not exist.

     If the .odbc.ini configuration file does not yet exist in your home directory, copy the entire odbc.ini.sample file into your home directory, and rename it .odbc.ini.

2. Use a text editor to modify entries in the file to describe the Netezza Performance Server system data sources that you want to access, as described in Data source configuration file (UNIX and Linux).
   To access additional Netezza Performance Server appliance data sources, supply a set of configuration entries, similar to that found in the odbc.ini.sample file, for each data source that you want to access.