Using the Extract Request Editor

Use the Extract Request Editorto create, modify, or delete Extract Requests stored in the Optim™ Directory.

Extract Request Editor

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.