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.
- 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.
- Move mysql-connector-java-5.1.47.jar to / v5dataserver/lib/ and /webapps/p2pd/WEB-INF/lib/.
- Go to /bin64, and run ./cogconfig.sh. Then restart Cognos service.
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.
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.
d) Select the Type as JDBC, and click Next.
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.
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.