Cognos

Cognos is a business intelligence (BI) solution that integrates reporting, analysis, dashboards, stories, explorations, modeling, and other functionality. This document describes how to connect IBM watsonx Orchestrate to Cognos and use its skills on watsonx Orchestrate.

Connecting to Cognos

Connect to the app according to the credential type that you or your team want to use.

If you want to connect the app to the Orchestrate Agent skill set, skill sets from AI assistants, or the Team skill set with Team credentials, refer to Managing app connections.

If you want to connect to the app to the Personal skill set ot the Team skill set with Member credentials, refer to Connecting to apps.

Configuring the connection

To connect watsonx Orchestrate to Cognos, complete the following steps:

  1. Click Connect app.
  2. You are prompted to enter the following connection details:
    • API key: If the service instance uses legacy credentials for authentication, provide the API key.
  3. Click Connect app.
Note: The icon A green check icon appears to show that the app is connected. indicates that the connection was successfully established.

Retrieving the API key

To retrieve the API key:

  1. Log in to the Cognos portal.

  2. Click Profile and settings > My API keys.

  3. Click Generate API key.

  4. Enter a name and description for the key and then click Next.

  5. The encrypted key appears.

  6. Click Copy to clipboard and then paste the key into a text file. Click Done.

  7. Next, create a session key using the generated API key.

  8. Run the following API with login details as Authorization and then enter the generated API key in the CAMAPILoginKey field in the request body.

    curl --location --request PUT 'https://example.ca.analytics.ibm.com/api/v1/session' \
--header 'Content-Type: application/json' \
--header 'Authorization: Basic xxxexamplexx' \
--data-raw '{
    "parameters": [
        {
            "name": "CAMNamespace",
            "value": "LDAP"
        },
        {
            "name": "CAMUsername",
            "value": "rsxxxn.mxxxan@partner.ibm.com"
        },
        {
            "name": "CAMAPILoginKey",
            "value": "AWkyMENBREQ4QzZCM0I0NDc4QjJDN0FENkMyRDRBRjEyNwdZIKtlnYBr+L3gPm2R5dxKJMFG"
        }
    ]
}'

  9. Obtain the session_key from the API response and use it as the API key to connect to watsonx Orchestrate.

What to do next

After you connect to the app, you can use the Cognos skills. For more information see, Using the chat.

To learn about the available skills, see List of prebuilt apps, skills and skill flows.

Parent topic:

→ Connecting to apps