Use the Extract Request Editorto create,
modify, or delete Extract Requests stored in the Optim™ Directory.
Description
Enter
text to describe the purpose of the Extract Request (up to 40 characters).
Server Name
If
the optional Optim Server component
is installed on your network, you can delegate resource-intensive
Extract Request processing (for example, when extracting a large number
of tables or rows) to a machine hosting Optim Server.
Click the down arrow to select a machine hosting Optim Server, or select Local to
process the request on the local workstation.
Note: If the Optim Server option is not enabled
at your site, the Server Name box is unavailable.
Tabs
The Extract
Request Editor displays tabs that enable you to specify
extract parameters and select options for running Extract Requests.
Each tab in the editor serves a unique purpose:
- General
- Provide parameters for the Extract Process, including
the Extract File name, Access Definition, items to extract, and a
limit for the number of rows to extract. The General tab
is shown first.
- Objects
- Indicate the type of objects to extract. When you
open the Extract Request Editor for the first
time, all objects are selected by default. The Objects tab
appears only when you select Objects or Both in
the Items to Extract box on the General tab.
- Point and Shoot
- Specify options to override the Point and Shoot
specification in the Access Definition.
- Variables
- Define values for substitution variables. (This
tab appears only if variables are specified in the Access Definition.)
- Object List
- Specify other non-related objects for extraction.
- Notify
- Specify options for automatic email notification
of the success or failure of the process.
- Convert
- Specify parameters for an optional Convert Process
following the Extract Process. (This tab appears only when you select Run
Convert After Extract on the General tab.)
Menu Commands
In addition
to the standard File and Edit menu
commands, you can select the following commands from the Tools menu:
- Edit Access Definition
- Opens the Access Definition Editor.
Edit the list of tables, select relationships, and define selection
criteria in the Access Definition used to select the data to extract.
See the Common Elements Manual for
further information.
- Edit Point and Shoot
- Opens the Point and Shoot Editor.
Create a list of Start Table rows to extract. See the Common Elements Manual for
further information.
- Edit Convert Request
- Opens the Convert Request Editor.
You can specify parameters for converting the Extract File at the
completion of the Extract Process. See Convert Process for
further information.