Connect with IBM Cognos Analytics
On this page
You can load your SingleStoreDB database in IBM Cognos Analytics and perform analytics and BI operations.
You need to add a data server connection to SingleStoreDB in Cognos Analytics and load the metadata for one (or more) schema(s).
Access to IBM Cognos Analytics.
Hands-on knowledge of Cognos Analytics application (see IBM Cognos Analytics documentation).
Sign in to Cognos Analytics, and select Manage from the (collapsed) menu.
Select Data server connections, and then select the Add data server button.
On the Create data server connection dialog, change the connection name from the default to something else, for example, SingleStore-test.
From the Connection type list, select SingleStoreDB.
Under Connection, in the JDBC URL box, enter the connection parameters for your cluster in the
Your SingleStoreDB cluster's endpoint (IP address) must be externally accessible to connect with IBM Cognos Analytics Cloud.
Under Authentication, from the Method list, select Use signon.
Select the Add Signon button.
On the User ID and password dialog, enter the login credentials for your cluster.
Select Done to save the credentials.
To test connectivity to your cluster, select the Test connection button.
Select Next, and then select Create to save the connection configuration.
On the Data server connections screen, select the recently created connection.
Select the vertical three-dot menu next to the connection, and select Assets.
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.
To connect to a SingleStoreDB database,
On the Cognos Analytics home page, select New > Data module (from the collapsed menu).
On the left navigation menu, select data servers and schemas.
Select the required server and database from the list.
For more information, see Creating a data module.
Once the database is uploaded, you can view the tables in the selected database on the Grid tab.
Issue: Cognos Analytics does not support zero values in date.
Solution:SingleStoreDB supports zero values in dates (e.
NULLvalues instead of zeroes.
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
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 type allows a user to perform any SQL operation on the database.
Last modified: June 29, 2023