Setting up connectivity to Netezza data sources

The IBM® Cognos® dynamic query mode uses the Type 4 JDBC driver to connect to the Netezza® databases. You must copy the Netezza JDBC driver file to the appropriate directory on the file system.

Procedure

  1. Within the Netezza client installation directory, locate and copy the nzjdbc.jar file to the cognos_analytics_server_install_location\drivers directory.
  2. For changes to take effect, stop and restart the IBM Cognos service.

What to do next

After you copy the driver files for your data source, users can create dynamic cubes. For more information, see the Dynamic cube modeling chapter of the IBM Cognos Dynamic Cubes User Guide.