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. |