IBM Cognos 8 supports Oracle data sources.
You specify connection parameters when you create a data source or modify
a data source connection
.
Parameter | Description |
SQL*Net connect string | Enter the SQL*Net connect string. |
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 8 and a database. We recommend that you contact customer support before using a collation sequence. |
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 a signon that the Everyone group can use. Enter the User ID and then enter the password in the Password and Confirm password boxes. |