Creating data source connections for the Great Outdoors Company package

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
About this task
To create data source connections:
  1. 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.
  2. If you are authenticated by the server, enter your username and password. If you are at the IBM® Cognos® Connection page, click Launch > IBM Cognos Administration. If you are at the Rational Insight Welcome page, click the Administration link in the banner.
  3. Click IBM Cognos Administration.
  4. Click Configuration.
  5. Click New data source.
  6. In the Name field, type great_outdoors_sales, and click Next.
  7. 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.
    • If you are using DB2®, click DB2 database name, and type GS_DB (in uppercase). Click DB2 connect string, and type the DB2 connection string.
    • If you are using Microsoft® SQL Server, click Server Name, and type the name of the server where the restored databases are located. Click Database name and type GOSALES.

      The samples require TCP/IP connectivity with SQL Server. Make sure that SQL Server Security is set to SQL Server and Windows, instead of Windows Only. The samples use SQL Server security for authentication.

    • If you are using Oracle Server, click SQL*Net connect string, and type the Oracle connection string.
  8. Set the connection string:
    1. Under Signons, select the Password and Create a signon that the Everyone group can use check boxes.
    2. Type the user ID and password for the user that you created when you restored the databases.
    3. Click Finish.
      Note: To test whether the parameters are correct, click Test the connection.
  9. Click Finish.
  10. 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.

Feedback