Oracle

Customizing Extracts from Oracle Enterprise Data Management

IBM Cloud Pak for Automation is more than AI and ML.

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!

 

 

About the Author

Steve Bogner is a Project Manager within Perficient’s Corporate Performance Management practice. He is experienced in leading implementations across the Oracle EPM suite, both cloud and on-prem solutions.

More from this Author

Leave a Reply

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

Subscribe to the Weekly Blog Digest:

Sign Up
Categories