Types of Extract

Standard extracts are used in a similar way to normal multi-write databases. In addition, the user will normally create Working Extracts for individual users: one working extract can be created from each database for each user.

Working extracts do not need to be added to Multiple Database (MDBs). When a user selects an MDB that includes databases for which that user has working extracts, data is actually written to the working extract.

The user cannot create other extracts from working extracts: they are always at the bottom of the extract tree. They are designed to be the databases which users actually write to; higher levels will normally be used for tasks such as checking and approval, probably in conjunction with Data Access Contro (DAC)l.

Variant Extracts allow different design solutions to be tried out without the need to claim elements to the extract: when one solution is selected, the data in the chosen variant extract can be issued back to the primary database.