Question & Answer
Question
This document explains how to connect your Cognos Analytics installation to your MongoDB Database as a Data Source Connection, using the MongoDB Connector for BI
Answer
Cognos Analytics supports connecting to MongoDB given you use the Connector for BI component as a middleware. This is needed because MongoDB is a non-relational database and Cognos Analytics requires a relational database connection. The Connector for BI component allows Cognos to make a connection using fixed schemas and tabular data.
Learn more about the MongoDB Connector for BI:
JDBC Driver
The MongoDB Connector for BI requires Cognos Analytics to use the MySQL Connector JDBC driver to connect to connect to it. This driver can be downloaded through the following page:
If you require authentication on the MongoDB Database, then you will need the Mongo SQL Authenticator Plugin JDBC driver that will be used to authenticate to the database:
These drivers will need to be added to the /drivers folder in your Cognos installation.
Connecting to the MongoDB Connector for BI
To create the data source connection:
- Go to the IBM Cognos Administration Console > Configuration > Data Source Connections.
- Click on New Data Source.
- Enter a name and press Next.
- In Type, select JDBC and press Next.
- In this new page, select MongoDB Connector for B
The connection string:
The connection string should look something like the following:
jdbc:mysql://server:3428?useSSL=false&authenticationPlugins=org.mongodb.mongosql.auth.plugin.MongoSqlAuthenticationPlugin
If you are not using authentication, then remove the last section such that it is like the following:
jdbc:mysql://server:3428?useSSL=false
Related Information
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.0.x","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
27 November 2019
UID
ibm10873328