Oracle Connection Parameters

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.

Parameter	Description
SQL*Net connect string	Note: 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® software 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 signon that the Everyone group can use. Enter the User ID and then enter the password in the Password and Confirm password boxes.

Parameter

Description

SQL*Net connect string

Note: 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® software 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 signon that the Everyone group can use. Enter the User ID and then enter the password in the Password and Confirm password boxes.