Create an Extract Request

To create an Extract Request, begin by clicking File > New > Extract from the main window to display the Extract Request Editor.

Use the Extract Request Editor to create and edit requests for extracting data from a database. The General tab is used to name the Extract File and open the Access Definition, in which you will list the tables that contain the desired data and define specifications for the data in the listed tables.

Specify a Description of the Extract Request to identify its purpose or function.

If the optional Optim™ Server component is installed, you can use the Server Name box to select a server on which to process the request, or select Local to process the request locally. For this scenario, select Local, which is the default.

Use the Extract Request Editor to specify the following parameters for the Extract Process:

Extract File
The Extract File contains a copy of the specified source data. The default file name extension for an Extract File is .xf. Type a name for the Extract File.
Access Definition Options
The Access Definition defines the set of data to be extracted. An Access Definition can be named and saved to be used again, or specified as Local and saved as an embedded part of the Extract Request. For this scenario, select the button labeled Local.
Note: For this scenario, all of the other Extract Process parameters are used at the default settings. For additional information about other parameters available in an Extract Request, see Using the Extract Request Editor.