Skip to main content


Customizing Extracts from Oracle Enterprise Data Management

digital data cloud

Oracle’s Enterprise Data Management (EDM) solution has been heavily focused on several areas over the past couple of years; data governance, data integrity, and out-of-box integrations, just to name a few. However, the latest updates have included enhancements geared towards user experience (in addition to a continued focus on the previously mentioned areas). One such enhancement is the flexibility in extracting data from EDM.

Extracts enable users to retrieve data from a viewpoint into a formatted file or a global connection. Users can extract from any viewpoint and for any properties. Extracts are similar to exports, but there are some differences between the two. The biggest difference being that extracts can be customized. Exports are based on application registration settings.

Customization options are plenty. Need a file with a delimiter other than a comma? Or a file without column headers? Or maybe certain records need to be filtered and excluded from the file? All can be easily accomplished via EDM’s extract feature. The below image displays all the available options that can be applied.

Oracle - Guide to Oracle Cloud: 5 Steps to Ensure a Successful Move to the Cloud
Guide to Oracle Cloud: 5 Steps to Ensure a Successful Move to the Cloud

Explore key considerations, integrating the cloud with legacy applications and challenges of current cloud implementations.

Get the Guide

2021 03 19 15 44 32 Clipboard

A few key considerations to keep in mind include:

  • Extract files are encoded in UTF-8
  • Only users with Owner permission on a dimension can create extracts
  • Users with Data Manager permission on a dimension can run extracts
  • Properties are added to the extract definition in the order selected. Therefore, be sure to select the properties in the order required for the file.

Have additional questions about extracts? Interested in exploring the benefits of Oracle Enterprise Data Management cloud? Contact us today!



Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Steve Bogner, Project Manager

Steve Bogner is Project Manager with 15+ years experience within Perficient’s Corporate Performance Management practice. He is certified in several technologies including Oracle Data Relationship Management and Oracle Enterprise Data Management. He is constantly striving to ensure successful experiences with CPM technologies for his clients.

More from this Author

Follow Us