Create the data source connections to the sample databases
you restored. The data source information is used for connecting to
the sample databases, and running the sample reports or using the
sample package.
Before you begin
- Restore the backup files for the sample databases.
- Make sure that the Rational® Insight server is
running.
- Make sure you have execute permissions for the Data Source Connections
secured feature and traverse permissions for the Administration secured
function.
About this task
To create data source connections:
- Point your browser to http://host:port/insight,
where host is the IP address or domain name and port is
the port of the Rational Insight server.
- If you are authenticated by the server, enter your username
and password. If you are at the IBM® Cognos® Connection page, click . If you are at the Rational Insight
Welcome page, click the Administration link
in the banner.
- Click IBM Cognos Administration.
- Click Configuration.
- Click New data source.
- In the Name field, type great_outdoors_sales,
and click Next.
- In the Connection page, click the
type of database that you restored and want to connect to, select
an isolation level, and click Next. The connection
string page for the selected database is displayed. The user specified
in the great_outdoors_sales data source must have
select privileges on the tables in the GOSALES, GOSALESRT, GOSALESMR,
and GOSALESHR schemas.
- Set the connection string:
- Under Signons, select the Password and Create
a signon that the Everyone group can use check boxes.
- Type the user ID and password for the user that you
created when you restored the databases.
- Click Finish.
Note: To
test whether the parameters are correct, click Test the
connection.
- Click Finish.
- Repeat steps 5 through 9 for the GOSALESDW database
or schema and, in step 6, specify the name to be great_outdoors_warehouse.
Results
The Great Outdoors data source connections are displayed as
entries in Data Source Connections. You can now import the samples
into the Framework Manager application.