Establish Connectivity to IBM Cognos

This article describes how to connect to the IBM Cognos server.

PREREQUISITES:

  • Port 9300 must be open to be able to access the Cognos server from the Metric Insights server.

VERSION SUPPORTED:

  • Cognos 11.1.7

NOTE: Versions outside of this list may be supported but are not actively tested. If you have an older or newer version, please work with support@metricinsights.com so that we understand your requirements.

1. Create New Data Source

Access Admin > Collection & Storage > Data Sources

  1. [+New Data Source]
  2. Choose "IBM Cognos" from the Other drop-down list
  3. [Next Step]

2. Provide the Required Parameters

  1. Enter a descriptive phrase in Data Source Name
  2. Select the required Auth Type
    • For Password, use the IBM Cognos credentials as shown on the screen
    • For Identity Profile, select the existing Identity Profile in the Identity Profile field
  3. Provide an endpoint for reaching the login page at a Cognos server
  4. Specify Cognos Namespace ID
    • NOTE: Make sure you are using Namespace ID but not Namespace Name (Cognos API requirement); otherwise, the connection won't be established.
    • A path to finding the Namespace ID value is defined in the following section
  5. Define the server protocol (http or https) and hostname
  6. Input Cognos Username
  7. Provide Cognos Plugin Password

Optionally, toggle on Enable On-Demand Element Creation and Enable Content Auto Synchronization

2.1. Finding Namespace ID in IBM Cognos

On the Cognos server, go to Manage > People > Accounts > Cognos Users > Account > Advanced tab.

3. Configure Optional Parameters


Description
1 Specify a Folder filter Value that will be used for filtering IBM Cognos Objects
2 List object types to use in report listing

4. Proceed with Advanced Configuration

Advanced Configuration settings can be set to default values unless Data Source requires more precise tuning. For more details on how to proceed, refer to Advanced Data Source Configuration.

[Test Connection] in the upper right corner