The Access Definition governs the overall Extract Process.
An Access Definition specifies the tables, relationship traversal,
and selection criteria for the data you want to extract. You can select
a named Access Definition or create a new Access Definition for a
single Extract Request.
The Access Definition enables you to:
- Specify the set
of tables to be included in the Extract Process. You can specify the
name of a single table and request that Move provide the names of
all related tables. One table is identified as the Start Table, or
table from which data is first extracted.
- Select relationships to be traversed to extract
the data. Move has default rules for how relationships are traversed
between the specified tables. You can select from a list of all of
the relationships defined to the database and to the Optim™ Directory. (The relationships contained
in the Directory supplement the relationships contained in the database.)
- Define criteria for the rows to be extracted by
specifying:
- Selection criteria for any selected table using
SQL syntax.
- A selection of rows chosen while browsing the data
(Point and Shoot).
- A sampling of rows, accomplished by extracting every nth
row.
- A maximum number of rows for a single table.
- A maximum number of children per parent.
- Grouping (e.g., extract 20 customers from each of
the 50 states).
- Ensure that the desired data is extracted using
the Show Steps function to review how Move will traverse the database.