Oracle Connection Parameters

You specify connection parameters when you create a data source or modify a data source connection.

Table 1. Oracle connection parameters
Parameter	Description
SQL*Net connect string	Type the instance name of the Oracle database as it is entered in the tnsnames.ora file.
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.
Signon	For more information on signon, see Securing data sources. If a user ID is required in the connection string, type the user ID in the User ID 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.