Informix Data Sources

IBM® Cognos® software provides support for Informix® data sources.

You specify connection parameters when you create a data source or modify a data source connection. For more information, see Data Source Creation and Add or Modify a Data Source Connection.

Table 1. Informix data source connection parameters

Parameter

Description

Informix database name

Enter the database name.

Host name

Enter the host name.

Server name

Enter the server name.

Collation sequence

Enter the collation sequence to be included in the database connection string.

Collation sequences are required only in rare cases where there may be sorting discrepancies between IBM Cognos software and a database.

Service

Select or enter the service name that the remote database server uses for incoming requests.

Signon

For more information on signon, see Securing data sources.

If a user ID or password are required in the connection string, select the User ID check box.

If a password is required, select the Password check box and enter the password in the Password and Confirm password boxes.

To create a user ID and password that automatically connects to the data source, select Create a signon that the Everyone group can use. Enter the User ID and then enter the password in the Password and Confirm password boxes.