Skip to main content

By clicking Submit, you agree to the developerWorks terms of use.

The first time you sign into developerWorks, a profile is created for you. Select information in your profile (name, country/region, and company) is displayed to the public and will accompany any content you post. You may update your IBM account at any time.

All information submitted is secure.

  • Close [x]

The first time you sign in to developerWorks, a profile is created for you, so you need to choose a display name. Your display name accompanies the content you post on developerworks.

Please choose a display name between 3-31 characters. Your display name must be unique in the developerWorks community and should not be your email address for privacy reasons.

By clicking Submit, you agree to the developerWorks terms of use.

All information submitted is secure.

  • Close [x]

developerWorks Community:

  • Close [x]

Recommended practices for using Cognos with Informix, Part 2: Deploy Informix with IBM Cognos BI Server 10

Install and get up and running

Sreeni Paidi, Enablement Consultant, IBM
Sreeni Paidi photo
Sreeni Paidi is an Enablement Consultant with the IBM Information Management Technology Ecosystem organization. Sreeni has about 15 years of experience working on DB2, Informix, Oracle, PostgreSQL, and SQL Server database servers as a Database Programmer, DBA and an Integration Architect. Sreeni is part of a worldwide team that provides technical skills and consulting services to help business partners and customers accelerate the integration of IBM data management software with their applications.
Jeffrey Williamson (jeffrey.williamson@jcbpartners.com), Senior Consultant, JCB Partners
A picture of the author Jeffrey Williamson
Jeffrey Williamson is a Senior Consultant and Southern California Market Lead for JCB Partners. Jeffrey has 4 years of experience implementing IBM Cognos Analyst, IBM Cognos Contributor and IBM Cognos TM1 as both a builder and a design architect. He has worked with clients in a wide range of industries including pharmaceutics, gaming and hospitality, retail, and restaurants. He is part of a team that helps organizations optimize the resources they have and better align their time and skills with the value of the organization.

Summary:  Connecting your Informix® databases to Cognos® Business Intelligence software gives you a way to unleash the power of your data with expanded query, reporting, and analysis capabilities. If you're ready to take that step, this two-part tutorial series gives you the information you need to install, configure, and deploy the necessary components to achieve the best results. Part 1 showed how to get started with using IBM Cognos Express V9 together with IBM® Informix V11.5 as a content store and data source. Now in Part 2, you'll find the same level of detail for deploying Informix with IBM Cognos BI Server V10. The tutorials include recommended practices for each step along the way, based on lessons learned from real-world deployments on the Microsoft® Windows® operating system.

View more content in this series

Date:  07 Jul 2011
Level:  Intermediate PDF:  A4 and Letter (2044 KB | 40 pages)Get Adobe® Reader®

Activity:  20739 views
Comments:  

Before you start

Before you start, read about what is covered in this tutorial, prerequisites, and system requirements.

About this series

This series has two parts. The first part covered the recommended practices for deploying Cognos Express software with Informix. This second part covers the recommended practices for deploying Cognos BI Server software with Informix as a content store and a data source.

About this tutorial

This tutorial uses a two-server approach, where one server is used for hosting the Informix data sources and the other server is used for hosting Cognos BI software and the content store database.

The following topics are covered in this tutorial:

  • Planning for hardware and software
  • Setting up the server that is planned for hosing Informix data sources by:
    • Installing Informix server software
    • Creating a sample Informix database as a Cognos data source
    • Tuning Informix database instance
  • Setting up the server that is planned for hosting Cognos BI components by doing the following:
    • Installing Cognos BI Server software
    • Installing Informix server software for the content store
    • Creating a content store database
    • Installing 32-bit Informix client software
    • Installing IBM Data Server Driver for JDBC and SQLJ software
    • Configuring client/server connectivity between Cognos BI and Informix server
    • Cognos BI Server configuration
    • Creating an Informix data source
    • Using Informix data source in Cognos Framework Manager

At the time when this tutorial was written, IBM Cognos BI version 10.1 wasn't certified on IBM Informix version 11.70. However you shouldn't have any problems using Informix 11.70 database as a data source or a content store database as long as you install 32-bit Informix-Connect version 3.50 on the Cognos BI Server. More details to follow.


Prerequisites

This tutorial is intended for system administrators and application administrators who are interested in deploying IBM Cognos BI Server version 10.1 with IBM Informix version 11.5 as a content store and an operational data mart on Windows Server 2003. You should have a general familiarity with installing software on Microsoft Windows.

System requirements

To run the examples in this tutorial, you need a Windows 2003 server with at least 2 GB 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 BI Server 10.1 software.

About IBM Cognos BI software

IBM Cognos Business Intelligence is a Web-based business intelligence solution with integrated reporting, analysis, score-carding, and event management features. IBM Cognos BI consists of server and modeling components, which are described in the following section.

  • Server components provide the user interfaces for reporting, analysis, score-carding, event management, as well as the server functionality for routing and processing user requests. Server components are further classified into the following categories:
    • Gateway is an extension of a Web server program that transfers information from the Web server to another server. It provides Web Communication in Cognos BI. Gateways are often CGI programs but may follow other standards such as ISAPI, Apache Module etc.
    • Application Tier Components that include IBM Cognos Administration, Cognos Viewer, Report Studio, Query Studio, Analysis Studio, Event Studio, Metric Studio, IBM Cognos Business Insight and IBM Cognos for Microsoft Office.
    • Content Manager manages the storage of data related to security, configuration, models, metrics, report specifications, and report output.
  • Modeling components are used to model data within data sources to structure and present data in a way that is meaningful to end users. Modeling components include the following tools:
    • Framework Manager for creating a business view of the data.
    • Metric Designer for extracting data for score-carding.
    • IBM Cognos Transformer for multidimensional modeling.
    • Series 7 IQD Bridge that contains the connection information that IBM Cognos BI requires to use IBM Cognos Series 7 Impromptu IQD data sources.
    • Map Manager for importing and managing maps.

Please see the Resources section for a link to visit the IBM Cognos landing page for more information about Cognos BI solution offerings.


About IBM Informix software

IBM Informix software's unmatched high availability, deep embed, blazing performance, zero administration, and data warehousing characteristics 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.

1 of 10 | Next

Comments



static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Business analytics, Information Management
ArticleID=696949
TutorialTitle=Recommended practices for using Cognos with Informix, Part 2: Deploy Informix with IBM Cognos BI Server 10
publish-date=07072011
author1-email=spaidi@us.ibm.com
author1-email-cc=
author2-email=jeffrey.williamson@jcbpartners.com
author2-email-cc=