# Connect with IBM Cognos Analytics

You can load your SingleStore database in IBM Cognos Analytics and perform analytics and BI operations.

You need to add a [data server connection](https://www.ibm.com/docs/en/cognos-analytics/11.1.0?topic=sources-data-servers) to SingleStore in Cognos Analytics and load the metadata for one (or more) schema(s). Once you have added a data server, you can create data modules, reports, dashboards, create a new table using SQL etc. See [IBM Cognos Analytics documentation](https://www.ibm.com/docs/en/cognos-analytics/11.1.0).

## Prerequisites

* Access to IBM Cognos Analytics.
* Hands-on knowledge of Cognos Analytics application (see [IBM Cognos Analytics documentation](https://www.ibm.com/docs/en/cognos-analytics/11.2.0)).

## Add a Data Server Connection to SingleStore in Cognos Analytics

1. Sign in to [Cognos Analytics](https://www.ibm.com/products/cognos-analytics), and select **Manage** from the (collapsed) menu.

2. Select **Data server connections**, and then select the **Add data server** button.

3. On the **Create data server connection** dialog, change the connection name from the default to something else, for example, **SingleStore-test**.

4. From the **Connection type** list, select **SingleStoreDB**. Select **Next**.

   ![Create data server.connection for IBM Cognos graphic.](https://images.contentstack.io/v3/assets/bltac01ee6daa3a1e14/blt7f4e5b4eacca6c7c/6a2c435ef29ff558d1b649c5/cognos-1-R2Muvl.png)

5. Under **Connection**, in the **JDBC URL** box, enter the connection parameters for your cluster in the `jdbc:singlestore://<host>:<port>/database` format.
   > **📝 Note**: Your SingleStore cluster's endpoint (IP address) must be externally accessible to connect with IBM Cognos Analytics Cloud.
   ![Create data server connection for IBM Cognos graphic.](https://images.contentstack.io/v3/assets/bltac01ee6daa3a1e14/blt6e58b25a0a691cc0/6a2c42ce984050cd98a5c57c/cognos-2-9tpVhc.png)

6. Under **Authentication**, from the **Method** list, select **Use signon**.

7. Select the **Add Signon** button.

8. On the **User ID and password** dialog, enter the login credentials for your cluster. Select **Done** to save the credentials.

   ![Provide user ID and password for IBM Cognos graphic.](https://images.contentstack.io/v3/assets/bltac01ee6daa3a1e14/bltd82a26afbaa7d26d/6a2c42a6970cc72c2e446f4d/cognos-4-onprem-BD7IZe.png)

   To test connectivity to your cluster, select the **Test connection** button.

   ![](https://images.contentstack.io/v3/assets/bltac01ee6daa3a1e14/blt8c6e157289f57722/6a2c42b204f23b267a273a38/cognos-5-7dZxpF.png)

9. Select **Next**, and then select **Create** to save the connection configuration.

10. On the **Data server connections** screen, select the recently created connection. Select the vertical three-dot menu next to the connection, and select **Assets**.

    ![](https://images.contentstack.io/v3/assets/bltac01ee6daa3a1e14/blt9ff7fdba4107e96f/6a2c436d464cc20282852f14/cognos-6-zTzK7A.png)

11. On the **Assets** screen, select the vertical three-dot menu next to the asset (database) you want to import, and then select **Load metadata** to load metadata for your schema. Use **Load options** to modify **Load metadata** settings.

    ![](https://images.contentstack.io/v3/assets/bltac01ee6daa3a1e14/bltfb7d3f389d85fc72/6a2c4349a36d0aa016b8214b/cognos-7-scbLds.png)

## Create a New Data Module

To connect to a SingleStore database,

1. On the Cognos Analytics home page, select **New > Data module** (from the collapsed menu).

2. On the left navigation menu, select data servers and schemas.

3. Select the required server and database from the list. Select **OK**.

For more information, see [Creating a data module](https://www.ibm.com/docs/en/cognos-analytics/11.1.0?topic=sources-adding-tables-data-module).

Once the database is uploaded, you can view the tables in the selected database on the **Grid** tab. You can join the tables in the database on the **Relationships** tab. To create custom tables, use the **Custom tables** tab.

## Troubleshooting

**Issue: Cognos Analytics does not support zero values in date.**

**Solution:**&#x53;ingleStore supports zero values in dates (e.g. 0000-00-00), but Cognos Analytics does not. To solve this issue, you can,

1. Assign `NULL` values instead of zeroes.

2. Use extreme values for these dates, for example 1970-01-01 or 9999-12-31.

If you do not have access to the data, use the **SQL View** option and change zero values to `NULL` values.

**Issue: Cognos Analytics may not support cluster specific constructs when using custom SQL syntax.**

**Solution:** Use the Pass-Through SQL type to run queries in cluster. Pass-through SQL allows you to run queries without any restrictions that the data source imposes on the subqueries. See [Supported SQL types](https://www.ibm.com/docs/en/cognos-analytics/11.1.0?topic=analytics-supported-sql-types) for more information.

> **⚠️ Warning**: Pass-through SQL type allows a user to perform any SQL operation on the database. Hence, the database administrator must ensure that a database user has necessary permissions configured. For example, read-only permission ensures that a user does not accidentally delete data.

***

Modified at: May 11, 2026

Source: [/db/v9.1/query-data/connect-with-analytics-and-bi-tools/connect-with-ibm-cognos-analytics/](https://docs.singlestore.com/db/v9.1/query-data/connect-with-analytics-and-bi-tools/connect-with-ibm-cognos-analytics/)

(An index of the documentation is available at /llms.txt)