< Previous | Next >

Preparation: Set up the sample database

If you plan to use the sample database for the tutorials, you need to download and configure the database set. This topic contains the instructions to do so.
Make sure you have downloaded the sample Rational® ClearQuest® database.

To configure the sample database for the tutorials:

  1. On a system that has IBM® Rational Insight Data Service installed, create a directory called C:/insight/training/etl (henceforth referred to as [TUTORIAL DIR]).
  2. Unzip the etl_tutorial_cq_db.zip file to the [TUTORIAL DIR].
  3. Start ClearQuest Maintenance Tool (Click Start > IBM Rational ClearQuest > ClearQuest Maintenance Tool ).
  4. Click Connection > New.
  5. Specify the name to be InsightTraining.
  6. In the Vendor list, select MS_ACCESS.
  7. In the Physical Database Name field, click browse, and select [TUTORIAL DIR]/insight_training.mdb.
  8. Click Finish.
  9. Right-click the new InsightTraining connection and click Update.
  10. In the Physical Data Name section, click browse and select [TUTORIAL DIR]/insight_training.mdb.
  11. Click Next. If prompted, type admin as the user name and leave the password field blank.
  12. When the update action is over, click Next and click Done.
  13. Click Exit.
  14. Start ClearQuest Designer (Click Start > IBM Rational ClearQuest > ClearQuest Designer).
  15. Expand the InsightTraining schema. If prompted, type admin as the user name and leave the password field blank.
  16. Right-click InsightTraining and click Show > User Databases.
  17. In the ClearQuest Database Admin view, right click the ENTC1 database entry and click Show Properties.
  18. In the Physical Database Name field, select [TUTORIAL DIR]/enterprise_training.mdb.
  19. Close ClearQuest Designer.

You have now created a Rational ClearQuest user database that you can use for the tutorials. The URL through which you can access this database is in the following format: http://server name:port/DataServices/ClearQuest/InsightTraining/ENTC1. To verify the connection, point your Web browser to the URL.

< Previous | Next >

Feedback