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.
IBM Cognos Analytics 11
Supported content types
- Report (except Reports that require prompts)
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)
- Username and password.
- Anonymous access is supported if it is enabled on the server.
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 > 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. For more information, 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:
- Data Refinery (Watson Studio or IBM Knowledge Catalog)
- DataStage (DataStage service). See Connecting to a data source in DataStage.
- Notebooks (Watson 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 (Watson Studio)
Platform assets catalog
Other catalogs (IBM Knowledge Catalog)
Cognos Analytics setup
Instructions for setting up Cognos Analytics: Getting started in Cognos Analytics.
- 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.
Parent topic: Supported connections