0 / 0
IBM Cognos Analytics connection

IBM Cognos Analytics connection

To access your data in Cognos Analytics, create a connection asset for it.

Cognos Analytics is an AI-fueled business intelligence platform that supports the entire analytics cycle, from discovery to operationalization.

Supported versions

IBM Cognos Analytics 11

Supported content types

  • Report (except Reports that require prompts)
  • Query

Create a connection to Cognos Analytics

To create the connection asset, you need the following connection details:

  • Gateway URL
  • SSL certificate (if required by the database server)

Credentials

  • Username and password.
  • Anonymous access is supported if it is enabled on the server.

If you select Shared, enter your username and password for the server.
Anonymous access is supported if it is enabled on the server.

If you select Personal, you have two choices:

  • Enter your username and password for the server.
  • Select platform login credentials.
    You can use this option only if the Cognos Analytics service is hosted on the instance of Cloud Pak for Data that you are connecting to.

For Private connectivity, to connect to a database that is not externalized to the internet (for example, behind a firewall), you must set up a secure connection.

Choose the method for creating a connection based on where you are in the platform

In a project
Click Assets > New asset > Connect to a data source. See Adding a connection to a project.
In a catalog
Click Add to catalog > Connection. See Adding a connection asset to a catalog.
In a deployment space
Click Import assets > Data access > Connection. See Adding data assets to a deployment space.
In the Platform assets catalog
Click New connection. See Adding platform connections.

Next step: Add data assets from the connection

Where you can use this connection

You can use Cognos Analytics connections in the following workspaces and tools:

Projects

Catalogs

  • Platform assets catalog

  • Other catalogs (IBM Knowledge Catalog)

Cognos Analytics setup

Instructions for setting up Cognos Analytics: Getting started in Cognos Analytics.

Restrictions

  • You can use this connection only for source data. You cannot write to data or export data with this connection.
  • Notebooks: Self-signed certificates are not supported for notebooks. The SSL certificate that is imported into the Cognos Analytics server must be signed by a trusted root authority. To confirm that the certificate is signed by a trusted root authority, enter the Cognos Analytics URL into a browser and verify that there is a padlock to the left of the URL. If the certificate is self-signed, the Cognos Analytics server administrator must replace it with a trusted TLS certificate.

Running SQL statements

To ensure that your SQL statements run correctly, refer to Working with Queries in SQL in the Cognos Analytics documentation for the correct syntax.

Learn more

Cognos Analytics documentation

Parent topic: Supported connections

Generative AI search and answer
These answers are generated by a large language model in watsonx.ai based on content from the product documentation. Learn more