Establish Connectivity to IBM Cognos

This article describes how to connect to IBM Cognos server in order to use its reports as Data Sources in Metric Insights.

General instructions on setting up data sources based on plug-ins can be found here.

PREREQUISITES

  • The default port for Cognos is 19300. Make sure you open port 19300 to access the Cognos server from Metric Insights server.

1. Access Admin > Data Sources

At the bottom of the screen click [+ New Data Source].

The Select the Type of New Data Source pop-up opens.

2. Select "Other" Data Source Type and choose "IBM Cognos" from the drop-down list

Select "Other" Data Source Type and choose "IBM Cognos" from the drop-down list

Move to the Next step

3. Provide Required Beckon Parameters

  1. Server: Define the server protocol (http or https) and a hostname
  2. A path to finding  the Namespace value is defined in Step 3.1
  3. Cognos URL: provide an endpoint for reaching a login page at the Cognos server
  4. Username / Password: Note that your Username must be in the same format that your IBM Cognos server uses for authentication
  5. Save your entries and Test Connection

If your connection is successful, you may move on to Advanced settings.

3.1. About Namespace

At the Cognos server go to My Preferences > Set Preferences screen opens > Personal tab.

4. Advanced Settings

  1. External Reports fetch method: This setting influences options available in the IBM Cognos Report List tab:
    • automatically: just click Refresh list and all Reports are going to be fetched by the system
    • manually: Reports may be added one-by-one or via CSV file
  2. Optionally, specify the maximum number of concurrent Threads per Trigger execution to be used in background processing when the system updates Metrics and Reports for this Data Source.  If you do not specify any value for this setting, batch data collection processing will be single-threaded.

5. Other Settings

  1. You can create elements or Datasets directly from the respective tabs
  2. Click Permissions to assign them to Groups or Power Users

0 Comments

Add your comment

E-Mail me when someone replies to this comment