Setting Up ODBC Connections to Sybase IQ or Netezza

If you are using an ODBC driver on UNIX or Linux to connect to a Sybase IQ or Netezza ODBC data source, you must configure the environment and define the data sources.

After setting up the ODBC connections, you must create connections to the data sources in Cognos Connection. For information, see the Cognos 8 Administration and Security Guide.

For UNIX, the open source iODBC driver manager provides ODBC connectivity to Sybase IQ or Netezza ODBC data sources. Cognos provides the binaries for this driver manager, which are automatically installed with Cognos 8.

On Linux, the unixODBC package provided with the operating system provides ODBC connectivity to Sybase IQ or Netezza ODBC data sources.

Steps

1. Verify that the ODBC connectivity software is properly installed:

   • On UNIX, verify that the binaries provided by Cognos for the iODBC installation are properly installed by typing the following at the command prompt:

     which iodbctest c8_location/bin/iodbctest

   • On Linux, verify that the unixODBC package provided with the operating system is properly installed by typing the following at the command prompt:

     odbcinst -version unixODBC version

     If problems occur when using this command, see the documentation provided by your Linux vendor.

2. Set the appropriate library path environment variable to specify the location of the ODBC libraries for your operating system.

   • For Linux, ensure that the variable specifies the /usr/lib directory that contains libodbc.so before any other database installation directories.

   • For UNIX, ensure that the variable includes the c8_location/bin directory before any other database installation directories.

   This table lists the environment variables for each operating system that must specify the location of the ODBC libraries.

   Operating system	Environment variable
   AIX	LIBPATH
   Solaris and Linux	LD_LIBRARY_PATH
   HP-UX	SHLIB_PATH

3. Copy the ODBC_location/lib/odbc.ini file to c8_location/bin.

4. Rename the odbc.ini file located in the c8_location/bin directory to .odbc.ini

5. In the [ODBC] section, specify the ODBC root directory and whether Driver Manager tracing is enabled.

   Here is an example:

   [ODBC]
   	InstallDir=/isvdb/sql/odbc
   	Trace =1
   	TraceFile = /uda/dev/boileaum/trace.log
   	TraceAutoStop=1

6. In the [ODBC Data Sources] section, define the name and driver for each data source.

   Here is an example:

   [ODBC Data Sources]dsn-name=
   driver-description

7. Create a copy of the [dsn-name] section for each data source defined in the [ODBC Data Sources] section.

8. For each data source defined in the [ODBC Data Sources] section, define additional details using a [dsn-name] section.

   Here is an example:

   [dsn-name]
   	Driver=driver_path	Keyword=value

9. If you want to define a data source that is used when no other data source is available, create a [Default] section, as shown here:

   [Default]
   	Driver=driver-path	Keyword=value

10. Save and close the odbc.ini file.

11. Test the connection to the data source by doing one of the following:

    • On UNIX, type the following command at a command prompt and then run a Select from a known table:

      iodbctest DSN=dns-name;UID=userID;PWD=password

    • On Linux, test the connection using the odbctest application.