Select Page

Moving Large Datasets to Oracle EPM Cloud: How to Do It Right

Author: David Silverstrim | | April 22, 2021

From greater accessibility and flexibility to cheaper storage costs, migrating your financial data to Oracle EPM Cloud has many benefits—but the project needs careful handling. The challenges involved with moving large datasets to the cloud include:

  • Selecting the right storage methodology; files, objects, and databases need different handling methods.
  • Preparing and cleansing the data (e.g. removing scratch files and backups, or archiving and compressing large amounts of relatively small files).
  • Optimizing network transfer speeds and replicating data to multiple regions or cloud providers.
  • Scaling the data migration process and avoiding bottlenecks.
  • Validating data integrity by checking for corruption and usability after the migration.
  • Preparing the data for use once it’s in the cloud.


The good news is that moving large datasets to the cloud is eminently doable as long as you’re able to put in the time and effort—and if you work with the right cloud migration partner. Datavail recently helped one of our clients, a large operator of hundreds of gas stations and retail locations across North America, upgrade their aged Oracle Hyperion HFM deployment and migrate their enterprise performance management (EPM) data to the cloud.

The steps for managing migrations with datasets of this size can include (plan for adjustments based on organizational variety):

  1. Gathering requirements and performing in-depth analyses of the client’s IT systems.
  2. Identifying points of improvement while maintaining on-premises functionality. For example, Datavail decreased the number of custom dimensions from 4 down to 2, so that the client could use the standard-size Oracle Financial Consolidation and Close (FCCS) application.
  3. Building and converting the client’s metadata, including their alternate hierarchies. This included using the Oracle Smart View metadata feature, which is only available in the cloud, to build hierarchies much more quickly than on-premises.
  4. Discovering errors and inefficiencies within the client’s datasets and reporting functionality.


Datavail has helped more than 150 clients move their enterprise data to the cloud—whether it’s Oracle EPM Cloud like the client in this post, or Amazon Web Services, Microsoft Azure, OCI, or much more. To learn more about how our client saved hours of time during their financial consolidation processes, check out our case study Major Retailer Improves Productivity by Moving to Oracle EPM Cloud.”

Read This Next

4 Ways Datavail Prepares Companies for Oracle Hyperion EPM 11.1 End of Support

Staying on top of your enterprise software licenses and expiration dates is crucial—especially when it comes to mission-critical applications like Oracle Hyperion EPM. Download the paper to learn how to prepare for your EPM upgrade.

Oracle EPM Cloud Vs. On-Premises: What’s the Difference?

EPM applications help measure the business performance. This post will help you choose the best EPM solutions for your organization’s needs and objectives.

Bobby Ellis | April 10, 2018

EPM Cloud: Hyperion Planning vs. Oracle (E)PBCS

Moving to the cloud has a variety of advantages. Learn about the differences between Hyperion Planning & Oracle (E)PBCS; which solution is best for you?

Bobby Ellis | September 19, 2018

Oracle EBS 12.2.10 Hits the Stands: What You Need to Know

This blog post reviews what you need to know about the new Oracle EBS 12.2.10 release.

John Kaufling | October 8, 2020

Subscribe to Our Blog

Never miss a post! Stay up to date with the latest database, application and analytics tips and news. Delivered in a handy bi-weekly update straight to your inbox. You can unsubscribe at any time.

Work with Us

Let’s have a conversation about what you need to succeed and how we can help get you there.


Work for Us

Where do you want to take your career? Explore exciting opportunities to join our team.