Process an Extract Request

An Extract Request is run in several steps. The steps differ slightly if you schedule the Extract to run later, rather than immediately, as explained in this topic.

Note: You may encounter a logon prompt during processing, depending on how Optim™ is configured at your site. See the Common Elements Manual for information about the DB Alias Connection Logon and Optim Directory Connection Logon dialogs.

Validate the Access Definition

Optim validates the specifications in the Access Definition. If the Access Definition is valid, processing continues. If the Access Definition is invalid, processing proceeds as follows:

Locate the Extract File

Optim locates the Extract File. If the file does not exist, Optim creates it. If the Extract File does exist, processing proceeds as follows:

Validate Variable Value

Optim checks whether variables are defined in the Access Definition and, if so, verifies that valid values are provided for each variable.

Validate Point and Shoot

If a Point and Shoot list is specified, Optim verifies that the rows are valid.

Extract Data and Generate a Process Report

Optim performs the Extract for each table listed in the Access Definition and generates an Extract Process Report.