Understanding Extract Types

The extract type enables you to extract all data from a viewpoint, or the changes to data over time in a viewpoint.

Full Extracts

Full extracts enable you to extract all data from a viewpoint for the current time period. The viewpoint can be bound or unbound, and the extract can include bound or unbound properties.

Incremental Extracts

Incremental extracts enable you to extract changes in a viewpoint between two time periods. The From and To time periods are compared, and the incremental differences are output in the extract file.

Considerations

  • To establish the time period for the incremental extract, you can specify From and To dates, a date offset (number of days prior to the current date), or you can extract all changes made since the last time an extract was run. See Editing Extracts.
  • You can extract all actions, or you can specify the actions that you want to extract. For example, you can extract only nodes that were added or deleted, but not updated or renamed. See Specifying Incremental Options.
  • Properties can be added to an extract more than once. This enables you to configure extract columns to display From and To values for nodes. See Selecting Extract Columns.
  • You can create an expression to use as an inclusion or exclusion filter for the nodes in the extract. For example, you can extract all nodes with an ancestor of "A", or all nodes except those with an ancestor of "A". See Specifying Extract Options.
  • The following extract options are not available for incremental extracts:
    • Pivot columns
    • Primary Key columns
    • Inverted Level specialty column