Use this roadmap to guide you through the extract process with Optim™ on distributed platforms.
To extract data, do the following:
Use an access definition to define data to archive. When you create an access definition, you select the tables and columns to archive and define selection criteria for the data to archive. You can create an access definition for reuse, or create a local access definition when you create an archive request.
Use the extract request editor to define parameters for processing the archive request. These parameters include the extract file, access definition, and row limit.
Use the extract request editor to run the extract process. The extract process selects a precisely defined set of related rows from a database and saves the rows to an external extract file.