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. It also provides
parameters for Actions – user-defined SQL statements executed
at predefined points in an Extract or Insert Process. 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).
- Establish Actions to be executed when data is extracted
or inserted.
- Ensure that the desired data is extracted using
the Show Steps function to review how Move will traverse the database.