Setting up connectivity to relational data sources for the dynamic query mode

For the relational data sources, the dynamic query mode requires access to only the Type 4 Java Database Connectivity (JDBC) drivers and their appropriate license files. The JDBC drivers provide an API that is vendor-independent. This independence allows IBM Cognos web applications to connect to different data sources and retrieve and update data using standard SQL statements. The network protocol used by a particular database converts the JDBC calls directly.

To allow the reporting engine to connect to supported relational databases by using dynamic query mode, you must first install the required Java Database Connectivity (JDBC) driver files. You then copy the Java Archive (.jar) file of the JDBC driver to the directory that is accessible to the web page that will invoke the applet.

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.