Before you start
Before you begin this tutorial, read about what is covered in this tutorial, what the prerequisites are, and the system requirements.
This series has two parts. In the first part, the recommended practices for deploying Cognos Express software with Informix are covered. In the second part the recommended practices for deploying Cognos BI Server software with Informix as a content store and a data source are covered.
This tutorial walks you through the steps to install and configure IBM Cognos Express and IBM Informix Server, how to test connectivity between the two, and then tune Informix for optimal performance.
This tutorial is intended for system administrators and application administrators who are interested in deploying IBM Cognos Express version 9 with IBM Informix version 11.5 as an operational data mart on Windows Server 2003. You should have a general familiarity with installing software on Microsoft Windows.
To run the examples in this tutorial, you need a Windows 2003 server with at least 2 GB of memory, and local Administrator user access on the Windows box. You will also need access to Informix 11.5 server software, Informix Connect software, and Cognos Express 9 software.
IBM Cognos Express is a business intelligence and planning solution
that integrates the following IBM Cognos products with a central
application used for installation and administration.
- IBM Cognos Express Advisor - using the analysis features of IBM
Cognos Executive Viewer, IBM Cognos Express Advisor enables you to
quickly move from raw data to high-impact analysis and
visualizations. Conduct powerful 'what if' scenario modeling using
- IBM Cognos Express Xcelerator - using the performance management
capabilities of IBM Cognos Advisor, IBM Cognos Express Xcelerator
allows you to transform common spreadsheets for planning and
analysis, and optimize large, highly complex data sets with
real-time response. Gain more insight through multi-dimensional
analysis while retaining a familiar Excel
- IBM Cognos Express Reporter - using the querying and reporting
power of IBM Cognos 8, IBM Cognos Express Reporter empowers
business users to access, modify and author reports with complete
self-service reporting and ad hoc query capabilities. Access any
type of data, including relational, analytical OLAP, or desktop
files, and deliver your reports via the web, PDF, Microsoft Excel
spreadsheets, email, or portal.
- IBM Cognos Express Manager - provides the ability to install, configure and administer all IBM Cognos Express products. You can publish data sources, add users and secure business content in one central, easy-to-use application.
IBM Informix software has unmatched high availability, is deeply embedded, has blazing performance, zero administration, and data warehousing characteristics, which makes it a perfect relational database offering for any size business. Please see the Resources section to read the article by Carlton Doe for more information on IBM Informix 11 software editions.