Business Intelligence Tutorial

Defining a relational warehouse source

In this exercise, you will define a relational warehouse source called the Tutorial Relational Source. It corresponds to the GEOGRAPHIES relational table that is provided in the DWCTBC database.

To define the Tutorial Relational Source:

  1. Right-click the Warehouse Sources folder.
  2. Click Define.

    The Define Warehouse Source notebook opens.

  3. In the Name field, type the business name for the warehouse source:
    Tutorial Relational Source
    

    You will use this name to refer to your warehouse source throughout the Data Warehouse Center.

  4. In the Administrator field, type your name as the contact for the warehouse source.
  5. In the Description field, type a short description of the data:
    Relational data for the TBC company
    
  6. In the Warehouse source type list, select the version of DB2 Universal Database for your operating system (such as DB2 UDB for Windows NT).
    The Define Warehouse Source notebook
  7. Click the Database tab.
  8. In the Database name field, select or type DWCTBC as the name of the physical database.
  9. In the User ID field, type a user ID that has access to the database.

    Use the user ID that you specified when you created the sample database in Lesson 2, Creating a warehouse database.

  10. In the Password field, type the password for the user ID that will access the database.
  11. In the Verify password field, type the password again.
    The Database page of the Define Warehouse Source notebook
  12. Click the Tables and Views tab.

    Because the tables are in a DB2 Universal Database database, you can import the table definitions from DB2 Universal Database rather than defining them manually.

  13. Expand the Tables folder.

    The Filter window opens.

  14. Click OK.

    The Data Warehouse Center displays a progress window. The import might take a while.

    After the import finishes, the Data Warehouse Center lists the imported objects in the Available tables and views list.

  15. From the Available tables and views list, select the SAMPLTBC.GEOGRAPHIES table.
  16. Click >.

    The SAMPLTBC.GEOGRAPHIES table is moved to the Selected tables and views list.
    Selected Table in the Tables and Views list

  17. Click the Security tab.
  18. Select the Tutorial Warehouse Group (which you created in Defining the warehouse group).
  19. Click >.

    Adding the source to the Selected warehouse groups list authorizes the users in the group (in this case, you) to define tables and views for the source.

    The Tutorial Warehouse Group moves to the Selected warehouse groups list.
    Selected Warehouse Group in the Tables and Views list

    Accept the rest of the values in the notebook. For more information about the values, see "Warehouse Source" in the online help.

  20. Click OK to save your changes and close the Define Warehouse Sources notebook.


[ Top of Page | Previous Page | Next Page | Table of Contents ]