Add or Modify a Data Source Connection

You can add new data source connections or edit string parameters for existing connections.

You can also add multiple connections to an existing data source. For example, you want a data source to have two or more connections to the same database that have different properties, such as different timeout values or access permissions.

You can also add connections to a data source that point to different databases, but the databases must contain the same schema.

When you create a data source connection, you can create a signon that the Everyone group can use to access the database. Later, you can modify who can use this signon or create more signons. For example, you can control access to data by setting the permissions for each data source connection. For more information, see Set Access Permissions for an Entry.

To add or modify a data source connection, you must have access to the required capabilities to administer data sources .

If you are creating an Oracle, DB2, or Microsoft SQL Server data source, you can include database commands in the connection information. For more information, see Using Database Commands for Oracle, DB2, and Microsoft SQL Server.

If you select Microsoft Analysis Services 2005 as the connection type, you can have more than one instance on the same server.

For information about setting the maximum number of data source connections available to the report server, see Manage Data Source Connections.

Steps to Create a New Connection

1. In IBM Cognos Connection, in the upper-right corner, click Launch, IBM Cognos Administration.

2. On the Configuration tab, click Data Source Connections.

3. Click the data source for which you want to add a new connection.

   Tip: To remove a data source connection, select its check box and click the delete button.

4. Click the new connection button .

5. In the name and description page, type a unique name for the connection and, optionally, a description and screen tip, and then click Next.

6. Proceed with steps 5 to 10 for creating a data source.

If you created a signon, you can now modify or add more signons .

Steps to Modify a Connection

1. In IBM Cognos Connection, in the upper-right corner, click Launch, IBM Cognos Administration.

2. On the Configuration tab, click Data Source Connections.

3. Click the data source for which you want to modify the connection.

4. Click the set properties button  for the connection you want to modify.

5. Click the Connection tab.

6. If you want to change the data source type, click an item in the Type drop-down list.

7. Click the edit icon  to modify the connection string.

8. Proceed with steps 5 to 10 for creating a data source.