Supported data sources for Cognos Dashboards

Cognos Dashboards supports various data sources.

Uploaded data files

CSV or Microsoft Excel file formats.

For more information about uploaded data files, see Supported local file formats.

For more information about adding connected data assets, including IBM services, see Adding data from a connection.

IBM Cloud® Databases for MySQL
IBM Cloud Data Engine
IBM Cloud Databases for PostgreSQL
IBM® Db2®
IBM Db2 (optimized)
IBM Db2 Big SQL
IBM Db2 for i
IBM Db2 on Cloud
IBM Db2 Warehouse
IBM Informix®
IBM Netezza® Performance Server
IBM Netezza Performance Server (optimized)
IBM Watson® Query
Cognos Dashboards uses Watson™ Query integration with IBM Knowledge Catalog so that you can create dashboards on governed virtual data that you published to governed catalogs. For more information, see Enabling dashboards to use governed virtual data. To take advantage of this integration, connect to Watson Query by creating virtual objects instead of adding data from a connection. For more information, see Creating virtual objects in Watson Query.

Specify the Watson Query data source credentials from within a project by selecting the data source itself or by selecting a table that references the data source. From the Authentication method field, select User credentials, then specify a username and password. If you are unable to specify a username and password, clear the Use my platform login credentials field.
IBM watsonx.data
To connect to data assets in IBM watsonx.data, use the Presto connection type.

For more information about adding connected data assets, including third-party services, see Adding data from a connection.