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 these connection details:
- Gateway URL
- SSL certificate (if required by the database server)
Credentials
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 one of three choices:
- Enter your username and password for the server manually.
- Use secrets from a vault.
- Select platform login credentials. This option is available only if the Cognos Analytics service is deployed on the instance of Cloud Pak for Data where you are creating the connection.
For Credentials and Certificates, you can use secrets if a vault is configured for the platform and the service supports vaults. For information, see Using secrets from vaults in connections.
Choose the method for creating a connection based on where you are in the platform
- In a project
- Click Assets > New asset > Data access tools > Connection. 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 Add to space > Connection. See Adding connections 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
-
Data Refinery (Watson Studio or Watson Knowledge Catalog)
-
DataStage (DataStage service). See Connecting to a data source in DataStage.
-
Notebooks (Watson Studio). Use the insert-to-code function to get the connection credentials and load the data into a data structure. See Load data from data source connections.
-
SPSS Modeler (SPSS Modeler service)
Catalogs
- Platform assets catalog
- Other catalogs (Watson 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