Sample Session

In this session, you:

Setting Your Workspace

Data Builder lets you set your workspace as part of the Data Inventory process. You must specify your workspace to organize and sort data on the basis of a logical model:

  1. From Data Builder, open the Work with Machine IDs window (click or access it through Environment > Work with Machine IDs) to create a new Machine ID.
  2. Click New.
  3. Specify your name as the name of the machine ID in the Machine ID box. For this tutorial, type: ALLIE.

  4. Type a description of your machine ID in the Description box. For this tutorial, type: ALLIE'S ENVIRONMENT.
  5. Specify additional information if appropriate. For this tutorial, the additional fields have been left blank. Click Apply.
  6. Click OK to save your specification and to close the window.

  7. From Data Builder, open the Work with Companies window (click or access it through Environment > Work with Companies) to create a new company code:
  8. Click New.
  9. Select the ALLIE Machine ID you just created.
  10. Specify DXPROJ as the name of your company code in the Company Code box.
  11. In the Company Description box, type: DX GETTING STARTED GUIDE.
  12. By default, the Life Cycle is activated. Leave this box selected.
  13. By default, the Is a Backup Company checkbox is not selected. Leave this box unselected.

    During the definition of a company, the backup company associated with it can also be defined.

    A Backup Company is useful when all the information concerning the files that undergo the Life Cycle procedure needs to be preserved.

    Note: Only one version for each file is stored in the backup company.
  14. Click Apply.

    The company you just created appears in the List of Companies.

  15. Click OK to save your specification and to close the window.

  16. Continue to the next section.

Loading your Data Store Information into the Knowledge Base

Perform this procedure to map and load the definitions from your data store into the XDB Knowledge Base. The information from your data store will be mapped to your workspace.

Load data store information into the Knowledge Base:

  1. Open the Distributed Loader window by clicking .
  2. Verify that the Machine ID ALLIE and the Company DXPROJ are selected.
    Note: If this is your first time using the Distributed Loader, ALLIE and DXPROJ will be automatically selected.
  3. For this tutorial, leave the load option Skip selected.
  4. In the Source database list, select GSDEMO.
  5. In the Schema box, type: SRC.
  6. In the User name box, type: install.
  7. In the Password box, type: 1.
    Note: This is the number one.
  8. Click Preview Tables to view all the available tables in the source database.
  9. Check the desired tables to load.
    Note: If you would like to limit the tables displayed by schema, in the Schema box, type the full schema name for the tables you want to view, and then click Preview Tables again.

    By default, all tables are selected. You can deselect tables as appropriate.

  10. Click Load to begin the export of the metadata into the Knowledge Base.
  11. Click Yes. An Insert tables window appears, followed by an Information window. After the metadata has fully loaded, an Information window appears that displays data store information including the number of data stores.
  12. Click OK.
  13. Click Yes to display the log file in a text format.
  14. Close the notepad view of the log file.
  15. Click Close to close the Distributed Loader.

    The list of Data Stores in the [Work with Data Stores] window is updated automatically.

  16. 16. If you're planning to go straight on to the next session, you can keep Data Builder open. Otherwise, either Click File > Exit or click the button, and then click Yes.