Rational® Common Reporting contains data sources for extracting and storing data
from a defined source during the ETL process. The data warehouse (RIDW)
data source must be configured with the correct connection string.
Also, two data warehouse data sources must be configured with the
credentials that allow the data to be stored.
About this task
Configure RCR with the proper data warehouse connection string
and signon credentials.
Procedure
- Create the RIDW (ETL) data source signon:
- Open the Cognos Web application at http://server:port/insight.
- Open the Cognos administration page by clicking .
- Click the Configuration tab.
- In the left pane, click Data Source Connections.
- Under the Name column, click RIDW (ETL).
- On the next page, click RIDW (ETL) again.
- To create the signon, click the New Signon (
) icon.
- In the Name field, type RIDW (ETL), and then click Next.
- In the User ID and Password fields, specify a username and password that
the necessary permissions to access the RIDW data warehouse, and then
click Next.
- In the Select the users page,
click Add in the lower, right corner.
- In the Available entries section,
click Cognos in the Name column.
- In the Name column, select Everyone, click the arrow (
) to add it to the Selected entries section, and then click OK.
- Click Finish.
- To test whether the created signon can connect successfully,
go up one folder to the directory path, .
- Under the Actions column, click
the Test the connection (
) icon.
- To check if the test is successful, click Test.
- Create the RIDW data source signon:
- Open the Cognos Web application at http://server:port/insight.
- Open the Cognos administration page by clicking .
- Click the Configuration tab.
- In the left pane, click Data Source Connections.
- Under the Name column, click RIDW.
- On the next page, click RIDW again.
- To create the signon, click the New Signon (
) icon.
- In the Name field, specify the
username of a user with the necessary permissions to access the RIDW
data warehouse, and then click Next.
- In the User ID and Password fields, specify the username and password for
the user mentioned in the previous step, and then click Next.
- On the Select the users page,
click Add in the lower, right corner.
- In the Available entries section,
click Cognos in the Name column.
- In the Name column, select Everyone, click the arrow (
) to add it to the Selected entries section, and then click OK.
- Click Finish.
- Configure the RIDW data source connection string to point
to the data warehouse:
- Open the Cognos Web application at http://server:port/insight.
- Open the Cognos administration page by clicking .
- Click the Configuration tab.
- In the left pane, click Data Source Connections.
- Under the Name column, click RIDW.
- Under the Actions column, click
the Set Properties (
) icon.
- Select the Connection tab.
- In the Type field, select the
database management system type, such as DB2, Oracle, or SQL Server,
that is consistent with the RIDW database. For example, if a RIDW
database is installed on DB2, then the type is DB2.
- Next to the Connection string field, click the Edit icon.
- Change the database name and connection string for your
database management system type. For example, if RIDW is installed
on DB2, type RIDW in the DB2 database
name field and jdbc:db2://localhost:50000/RIDW in the DB2 connect string field, and click OK.
- Click OK to save the changes.
- Test the RIDW connection by clicking Test
the connection (
) icon in the upper, right corner. In the Test
the connection page, click Test to ensure it is successful.
- Click Close, and then click Close again.
- Click OK.