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
- Data Refinery (watsonx.ai Studio or IBM Knowledge Catalog)
- DataStage (DataStage service). See Connecting to a data source in DataStage.
- Notebooks (watsonx.ai Studio). Click Read data on the Code snippets pane to get the connection credentials and load the data into a data structure. See Load data from data source connections.
- SPSS Modeler (watsonx.ai Studio)
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