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:  

Working with an Informix data source in Cognos BI

In the previous section, you have installed, configured, and started the Cognos BI Server. It is now time to create an Informix data source and see it in action.

Creating an Informix data source in Cognos

Prerequisite:

If it is not already done, set up the client/server connectivity for the Informix data source by following the instructions given in the section titled Configuring client/server connectivity on the Cognos Server

Procedure:

  1. As shown in Figure 23, bring up the Cognos BI Administrator home page in a web browser and click the Administer IBM Cognos content link.

Figure 23. Administer IBM Cognos content
Administer IBM Cognos content
  1. As shown in Figure 24, click Configuration.

Figure 24. Data source configuration
Data Source configuration
  1. Click the New Data Source icon (cylinder icon) on the top right corner, as shown in Figure 25.

Figure 25. New data source selection
New data Source selection
  1. You will see the new data source wizard. Specify the name and description of the new data source, and then click Next.
  2. Choose IBM Informix as the type, and specify an isolation level (for example, cursor stability), and then click Next.
  3. You are asked to specify the following connection string related parameter values, also shown in Figure 26.
    • Informix database name: Name of your Informix database, for example gsdb.
    • Host name: Name or IP address of the database server host computer.
    • Server name: Name of your Informix server instance on the Informix server, for example cbiwin.
    • Collation sequence: Leave it blank
    • Service: Port number or service name of SQLI protocol (olsoctcp protocol) port for the database instance on the database server.

Figure 26. Connection string properties
Connection string properties
  1. As shown in figure 27, select the User ID and Password check boxes. If you prefer, also check Create a signon that Everyone group can use.
  2. Enter the database User ID and Password that you would like to use to connect to your Informix data source.
  3. Click Test the connection.
  4. Click Test again.

Figure 27. Testing the database connectivity
Testing the database connectivity

Recommended practice: It is not a good practice to use Informix user for this. You can create a separate account such as gsdbusr on the database server, grant necessary database and table-level privileges (such as connect, resource privileges), and use that database user account.

  1. As shown in Figure 28, if the database connection string parameters are valid, you should see that the database connection test was successful. Click Close.

Figure 28. Verify the connection test results
Verify the connection test results
  1. Click Close again, and then click Finish.
  2. You have successfully created an Informix data source connection. You can now use this data source connection to connect to the Informix database data mart.

The following are common reasons why the connection test would fail.

  • Not able to connect to the server (i.e. host) where the database is hosted. Check the connectivity with a ping command at the command prompt.
  • Source database is not a UTF8 database.
  • Not setting DB_LOCALE to en_us.utf8 while defining the SQLHOSTS information.
  • Incorrect database connection properties such as incorrect dbname, server, portnumber, and others.
  • Incorrect db username and/or password.
  • Dbuser doesn't have privileges to connect to the database
  • You have installed 64-bit CSDK or IConnect software on the Cognos BI Server. Client software has to be 32-bit.
  • You have installed 3.70 version of the CSDK / IConnect software. As of the date this tutorial was published version of CSDK / IConnect has to be 3.50.

Take the right action to correct the problem and try again.


Informix data source: See it in action

It is now time to see how an Informix data source can be used in Cognos BI. To demonstrate this, from Cognos Framework Manager, you are going to connect to the Informix data source that was created in the previous section. Cognos Framework Manager allows you to model data and publish packages.

Prerequisite:

Install IBM Cognos Framework Manager on the Cognos BI server. Installation of Cognos Framework Manager is very simple and it isn't covered in this tutorial.

See it in action:

  1. Bring up the Cognos Framework Manager user interface by clicking All Programs -> IBM Cognos 10 -> IBM Cognos Framework Manager.
  2. Click Create a new project using Model Design Accelerator.
  3. As shown in Figure 29, type the name of the new project and click OK.

Figure 29. Creating a new project
Creating a new project
  1. Select the design language for the project and click OK.
  2. Select the Informix data source that was previously created (gsdb) and click Next.
  3. As shown in Figure 30, select all the tables in the gosales schema and click Continue.

Figure 30. Selecting the tables
Selecting the tables
  1. The Framework Manager will import all the selected tables. You are presented with the Model Design Accelerator Info screen. Click Close.
  2. As shown in Figure 31, you will now see all the tables imported into the Model Design Accelerator. Save and close to exit.

Figure 31. List of tables
List of tables

5 of 10 | Previous | 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=