How to Manage Your Own Data Source Credentials

You may be prompted for your data source credentials when you perform the following actions:

view, run, or open an entry

use a schedule or a job

select the data sources that can be used to create a package

You may also be prompted for data source credentials when you use Framework Manager (see the Framework Manager User Guide).

You can save your data source credentials so that you are not prompted for them every time. You can also view and delete your data source credentials.

If you are an administrator, you can also create or modify data source signons , but if you have a lot of users, it can be unwieldy for data source configurations that require each user to have their own signon since the credentials for each user must be done individually. You can also view the data source credentials for other users.

Note that credentials are checked in the following order:

first, the signons that you create as an administrator are checked

if no credentials are found for the user, the user’s profile is checked to see if they have stored their own credentials

if no credentials for the user are found in either place, the user is prompted for credentials

This is important because if you create credentials after a user has saved their own credentials, they get data associated with the credentials that you created for them, which might not be what they are expecting.

If you are a user, your administrator must give you execute permissions for the Manage own data source signons capability and traverse permissions for its ancestors. You must also have read and traverse permissions on your account. You can then save credentials to your personal profile, as long as you do not have access to any predefined signons for the data source. You are not prompted for your credentials if you have permission to access an existing data source credential and you have saved the personal credential in your profile. You can view and delete your data source credentials from the My Preferences page.

To view another user’s credentials, you must have read and traverse permissions on the user’s account. To remove data source credentials, you must have read, write, and transverse permissions on the user’s account.

Save Your Data Source Credentials
When you are prompted to enter your data source credentials, enter your user ID and password.

Select the Remember my user ID and password when connecting to this data source check box.

Click OK.

The next time you perform an action that requires those data source credentials, you are not prompted for them unless they have been removed or deleted, or have expired.

View and Remove Your Data Source Credentials
In IBM® Cognos® Connection, in the upper-right corner, click My Area Options, My Preferences.

Click the Personal tab.

Your data source credentials are listed under Data source credentials. You can sort the list by Data Source Name or Data Source Connection Name.

To remove a data source credential, select the check box for it, then click Remove.