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.
Your Goal | Watch This Video |
---|---|
Learn more about how to use extracts to retrieve data from a viewpoint. |
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. |