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.
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.
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.
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.
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.
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.
Alibaba Clouder - May 20, 2020
ApsaraDB - April 15, 2019
ApsaraDB - July 3, 2019
ApsaraDB - January 17, 2022
ApsaraDB - February 20, 2021
Michael Peng - September 24, 2019
More Posts by Alibaba Clouder