Integrating with Cognos Analytics

You can connect Db2 Big SQL as a data source to Cognos Analytics and create reports in Cognos Analytics to analyze and visualize Db2 Big SQL data without having to write queries or scripts.

Connecting Db2 Big SQL to Cognos Analytics

You connect Db2 Big SQL to Cognos Analytics by creating a data server connection.

  1. In the Cognos Analytics portal, click Manage > Data server connections.
  2. Click the Add data server icon (+), and in the Select a type slideout pane, select BigSQL.
  3. In the Edit DB2 connection slideout pane, in the JDBC URL box, type the information to connect to the Db2 Big SQL server.
  4. In the New data server connection slideout pane, click the Settings tab, and under Authentication method, select the option that is needed to connect to the Db2 Big SQL server, and then specify the information that is required.

    For example, if you selected the Use the following signon radio button, click the Add Signon icon (+) and specify the user ID and password to connect to the Db2 Big SQL server.

  5. Click Save.
  6. Click the Schemas tab and select the schema that you want to use to build reports.
    IBM Cognos Analytics user interface for defining data server connections
  7. Click Manage again to close all slideout panes.

Creating a data module

After you are connected to the Db2 Big SQL server, create a data module that contains the tables that you want to use in reports.

  1. In the Cognos Analytics portal, click New > Data module.
  2. In the Sources slideout pane, click Data servers.
  3. In the Data servers slideout pane, select the data server connection that you previously created.
  4. In the data server connection slideout pane, select the check box of the schema that you previously selected.
  5. In the Selected sources slideout pane, click Done.

    A new data module is created.

  6. In the Sources slideout pane, expand the schema.
  7. Drag the tables that you want to use to create reports to the work area.
    User interface in Cognos Analytics for creating a data module
  8. Save the module.
Note: You can also create a data module from a package that was created in Framework Manager. For more information, see the Cognos Analytics documentation.

Creating a report

When you have created a data module, you can create reports by using data items from the tables in the data module.

  1. In the Cognos Analytics portal, click New > Report.
  2. Choose a template for the report and click OK.
  3. Click the Add report data icon (+), navigate to the data module that you previously saved, and select it.

    The data items that are available to you appear in the Source tab.

  4. In the work area, click the (+) icon and add a data container, such as a crosstab.
  5. Add data by dragging and dropping data items to the data container.
  6. Repeat steps 4 and 5 for other data containers that you added to the report.
  7. Save the report and then run it to see the results.
Cognos Analytics report showing a crosstab and chart

For more information about Cognos Analytics, see the Cognos Analytics documentation.