Creating an access definition

In this exercise you will create an access definition. Use access definitions to specify the tables, relationship traversal, and selection criteria for the data you want to process.

Before creating an access definition, a data store alias must exist for the database that contains the start table.

To create an access definition:

  1. Expand the Tutorial folder in the Directory Explorer, right-click Access Definitions, and click New Access Definition. The New Access Definition wizard opens.
  2. On the Enter Access Definition Name page, enter SAMPLE.AD. Click Next.
  3. On the Select a Data Store Alias page, select the data store alias that contains the Optim™ sample data. Click Next.
  4. On the Select a Start Table page, do the following steps:
    1. In the Table Search Pattern field, enter the following search pattern: SCHEMA.OPTIM_CUSTOMERS, where SCHEMA is the schema that contains the Optim sample data. For example: SAMPLE.OPTIM_CUSTOMERS.
    2. Click Display Tables. The table list displays tables that match the pattern.
    3. Select the OPTIM_CUSTOMERS table.
    4. Click Next.
  5. On the Specify a Table Selection Method page, click Find related tables. Click Next.
  6. On the Display and Select Related Tables page, do the following steps:
    1. Click Display Tables. The table list displays tables related to OPTIM_CUSTOMERS.
    2. Click Select All.
    3. Click Finish.

The new access definition is displayed in the Access Definition Editor.



Feedback