Working With Extracts

Extracts enable you to retrieve data from a viewpoint within a dimension into a formatted file or a global connection. You can extract from any viewpoint and for any properties. The viewpoints and properties do not have to be bound to be included in an extract.

Extracts Versus Exports

Extracts are similar to exports in that they both retrieve data from dimensions. However, there are some key differences:

Extracts Exports
Can be run for any viewpoint or property regardless of binding status Limited to bound viewpoints and properties
Can output a full data set, a filtered subset of data, or incremental data changes for a viewpoint Can output a full data set for bound viewpoints or incremental changes to a bound list viewpoint
Created and customized by dimension owners or metadata managers (for public extracts) or by users with access to a view and at least Participant (Read) permission on a viewpoint (for private extracts). Created by the system based on registration settings
Formatting options are configurable by users. No constraints for external applications. Contains target-specific logic and formatting so that they can be imported by external applications
Dimensions support multiple extracts One export available per dimension
Extracts can be run for a single viewpoint at a time Depending on the application type, exports can be run across multiple viewpoints
Can be extracted to a global connection or a file (depending on your permissions). Can be exported to an application connection or a file.
Locale and time zone are fixed so that extracts always have the same output regardless of where they are run from Depending on the application type, the date and time formatting may vary based on the user's locale.