How to Connect IBM Cognos to AnalyticDB

By Jeffrey Gao, Solutions Architect

There are several popular BI tools, such as QuickBI, Tableau, Qlikview and IBM Cognos, that customers are using to gain the insights into their properties of data. In this tutorial, we will demonstrate how to connect IBM Cognos to Alibaba Cloud’s AnalyticDB. That is, IBM Cognos can take AnalyticDB as the data source.

About IBM Cognos

IBM Cognos Business Intelligence is a web-based integrated business intelligence suite by IBM. It provides a toolset for reporting, analytics, scorecarding, and monitoring of events and metrics. The software consists of several components designed to meet the different information requirements in a company.

About Alibaba Cloud AnalyticDB (ADB).

Alibaba Cloud AnalyticDB (ADB) is a PB level real-time data warehousing with high concurrency and low latency, and provide the capability of real-time multi-dimension data insight. At the time of writing, ADB is only available for Mainland China accounts.

Connecting Cognos to AnalyticDB

After the installation of IBM Cognos server (here we will use the Linux edition), and the activation of ADB instance, we need to provision on Cognos, to enable it to use ADB as the data source. Here we assume the network connectivity between IBM Cognos and ADB is ready.

  1. IBM Cognos can work on the database of IBM DB2, Oracle, MySQL, etc. If we use MySQL, we need to add MySQL connector to Cognos.
  2. Move mysql-connector-java-5.1.47.jar to / v5dataserver/lib/ and /webapps/p2pd/WEB-INF/lib/.
  3. Go to /bin64, and run ./cogconfig.sh. Then restart Cognos service.
Image for post
Image for post

Add data source to Cognos.
a) Go to IBM Cognos Administration. You can login through IBM Cognos Connection portal. Suggest use the browser of Safari or Internet Explorer, since in Google Chrome you may not find the menu as below.

Image for post
Image for post

b) Go to Configuration->Data Source Connections->New Data source,

c) In the New Data Source Wizard, input the Name of data source and Description (if any), and click Next.

Image for post
Image for post

d) Select the Type as JDBC, and click Next.

Image for post
Image for post

e) In the JDBC connection page, select the Type as MySQL, since ADB is highly compatible with MySQL and SQL:2003 protocol, and input the JDBC URL of ADB instance as well. The connection string will be generated correspondingly. Besides, input Sign on User ID and Password.

Image for post
Image for post

When provision is done, we can test the connection. If succeed, the go back to provision page and click Finish.

f) Go to Query Studio, and select a package to do query.

Image for post
Image for post

Reference:https://www.alibabacloud.com/blog/how-to-connect-ibm-cognos-to-analyticdb_594548?spm=a2c41.12636909.0.0

Written by

Follow me to keep abreast with the latest technology news, industry insights, and developer trends.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store