You must create data source connections to the
samples databases that you restored.
IBM® Cognos® Business
Intelligence uses data source connections to the samples databases
to connect to the samples databases and run the sample reports or
use the sample package.
Before you begin
The DB2® database
name that you type must use uppercase letters. Also, in Framework
Manager, the schema names that you type for the DB2 data sources must use uppercase letters.
Before
you create the data source connections, you must restore the backup
files for the samples databases. Also, ensure that the IBM Cognos BI
service is running.
To create data sources, you
must have execute permissions for the Data Source Connections secured
feature and traverse permissions for the Administration secured function.
You must have write permissions for the Cognos namespace.
If
you have restored the sample databases on a different computer than
where you have installed the IBM Cognos BI Application Tier Components,
you may have to install the database client to access the sample databases.
For more information, see the topic on setting up database connectivity
for reporting databases in the IBM Cognos Business Intelligence
Installation and Configuration Guide.
Procedure
- Open IBM Cognos Administration by connecting
to the IBM Cognos BI portal and clicking Administer
IBM Cognos Content on the Welcome page.
- Click the Configuration tab.
- Click the new data source icon
.
- In the Name box, type great_outdoors_sales and
then click Next.
- In the connection page, click the type of database that
you restored and want to connect to, select an isolation level, and
then click Next.
The connection
string page for the selected database appears.
Tip: The
user specified in the great_outdoors_sales data source must have select
privileges on the tables in each of the GOSALES, GOSALESRT, GOSALESMR,
AND GOSALESHR schemas.
- Do one of the following:
- Under Signons, select the both 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, and then click Finish.
Tip: To test whether the parameters are correct,
click Test the connection....
- Click Finish.
- Repeat steps 4 to 9 for the GOSALESDW samples database
or schema, and type great_outdoors_warehouse in step 5.
- If the GOSALESW model will be used by
modelers in IBM Cognos Transformer, the connection string
must be manually added to the cs7g.ini file.
For more information, see the IBM Cognos Business
Intelligence Installation and Configuration Guide.
Results
The Great Outdoors data source connections appear as entries
in
Data Source Connections.
You can now import
the samples unless there is a syntax error in the connection string
or an incorrect parameter.