Select Page

Data Integration for the EPM Cloud

Author: Todd Rebner | 5 min read | May 11, 2017

As a prospective user of Oracle EPM Cloud you might fit any one of the following scenarios.

Currently Using Spreadsheets as a Planning Solution

Spreadsheets are a very flexible and useful tool if you want to organize, tabulate, and analyze financial, budgeting, and forecasting data at a departmental level. However, any effort to integrate LOB and department-level data contained in spreadsheets for a corporate perspective can prove to be tedious and error-prone. That may be one of the reasons you are considering using Oracle EPM Cloud.

Currently Using On-premises EPM

Alternatively, you may be using the Hyperion on-premises version of EPM and thinking of moving to the cloud, as it is a more affordable option, with fewer hassles in terms of maintaining servers and hardware resources.

Currently Using Third-Party SaaS Applications

Another possibility is that you want to link your existing SAP application with Oracle Enterprise Planning & Budgeting Cloud Service (EPBCS) and benefit from the paring of these two popular platforms.

Questions Related to Data Integration

Regardless of your background as a potential user of Oracle EPM, there are a number of questions centered around one critical element — your existing data. Those are:

  •        How will I port my data to Oracle EPM?
  •        Are there any technical complications in uploading my existing data?
  •        Will Oracle EPM work with my existing Oracle or third-party SaaS application data?
  •        How will I manage my metadata?

Your existing data will be the most critical element in any likely move to Oracle EPM Cloud. It would be surprising if you didn’t have any questions related to data interoperability and integration.

The simple answer is that Oracle EPM Cloud is backed and supported by a number of tools and technologies that can help you plan, implement, and resolve your data migration and integration issues. These tools are a part of Oracle’s well thought-out strategy not just for data integration and interoperability but also for creating and working with metadata repositories.

You may want to read our extensive white paper on Oracle EPM cloud data integration, titled Simple and Smooth Oracle EPM Cloud Data Integration. This paper describes the various possible approaches to integrating the various component modules of its Enterprise Performance Management (EPM) Cloud Service with software applications in a cloud, on-premises, or hybrid environment.

Let’s summarize a few of the tools for integrating data to the Oracle EPM Cloud.

Oracle Data Integrator Enterprise Edition (ODIEE)

Oracle Data Integrator Enterprise Edition is Oracle’s flagship ELT/ETL tool. ODIEE is a high-performance tool that can read data from sources as diverse as flat files, Excel files, SQL Server or Oracle databases, and transfer the data to any target database using either an ETL or an ELT-based approach. Using ODIEE requires that a sort of interface be built between the source and target data sources where data items from the source are mapped to data items in the target data destination.

Oracle Financial Data Quality Management, Enterprise Edition (FDMEE)

Oracle FDMEE is designed to work together with ODIEE. The product uses metadata definitions that ensure accuracy in the process through which financial data is collected, mapped, and verified within the Oracle EPM ecosystem. It helps in streamlining processes of data movement and ensures the integrity and veracity of data as it is moved between source and target systems.

Oracle Cloud Integration Service (OCIS)

As we know, Oracle EPM Cloud is a set of cloud-based applications that require very little time to deploy and are easy to run. In order to match the simplicity with which users can be up and running its EPM suite, Oracle has provided a cloud-based integration service known as Oracle Cloud Integration Service. OCIS uses an agile approach with which Oracle EPM users can integrate data from existing Oracle or third-party SaaS-based applications.

OCIS uses pre-built integrations for a host of Oracle and non-Oracle applications. This effectively means that the interfaces between well-known applications are pre-built into OCIS. In other words, there is no need for manual mapping between source and target systems.

Imagine the convenience of just selecting an application that you need to integrate with an EPM product — the service does the rest of the thinking for you. Did we mention that the list of supported applications is ever growing? Regardless of the form of the data that you need to integrate into its EPM suite, Oracle has a solution for you.

If you have any questions about data integration for the EMP Cloud or need help implementing and running Oracle EMP Cloud, download our white paper, Simple and Smooth Oracle EPM Cloud Data Integration, or contact Datavail today. In addition to a large library of white papers, slideshows and blog posts, Datavail offers implementation, migration, and managed services for a wide variety of EPM solutions. Datavail’s experts are available to assist with your analysis, planning, upgrading, migration, and training.

Datavail is a specialized IT services company focused on Data Management with solutions in BI/DW, analytics, database administration, custom application development, and enterprise applications. We provide both professional and managed services delivered via our global delivery model, focused on Microsoft, Oracle and other leading technologies.

How to Solve the Oracle Error ORA-12154: TNS:could not resolve the connect identifier specified

The “ORA-12154: TNS Oracle error message is very common for database administrators. Learn how to diagnose & resolve this common issue here today.

Vijay Muthu | February 4, 2021

Data Types: The Importance of Choosing the Correct Data Type

Most DBAs have struggled with the pros and cons of choosing one data type over another. This blog post discusses different situations.

Craig Mullins | October 11, 2017

Oracle RMAN Backup and Recovery with Restore Points

Oracle restore points are useful for benchmark testing. Find out how you can use Oracle’s Recovery Manager (RMAN) tool to create and use restore points.

Cindy Putnam | May 3, 2019

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.