What is Oracle FDMEE?
All data integration is an extract, transform and load (ETL) activity. Data from a source – be it a flat file, a relational database, a web service or even the Oracle EPM suite of products – needs to be extracted, transformed and loaded. There are a variety of tools available to achieve this. Oracle Financial Data Quality Management, Enterprise Edition (FDMEE) is a purpose-built application for integrating data into the Oracle EPM suite of products – on-premises as well as the Oracle EPM Software as a Service (SaaS) cloud offerings. FDMEE is an on-premises application but has a cloud counterpart known as Data Management. This cloud component is embedded in each of the Oracle EPM Cloud Services as an integrated part of the subscription.
The FDMEE application was developed specifically for the EPM suite of products and includes a significant amount of prebuilt logic to streamline data integration within it. The application natively recognizes the target application metadata as well as settings that impact a data integration process.
As an example, FDMEE includes native functionality that recognizes that an intersection within the HFM application is not valid for data entry and will stop the integration cycle and prevent a data load that would otherwise result in an error. For integration to on-premises Hyperion Planning, and/or Oracle Essbase, FDMEE includes native functionality to execute calculation scripts before and after the data load process. This awareness of the target application ensures that the data integration cycle is efficient and easy. This is a key differentiator when comparing FDMEE to other data integration options.
FDMEE is a data management application. While it performs many of the same functions of a true ETL solution, it is not as flexible or as powerful (in terms of data volume processing) as a pure ETL solution. Conversely, FDMEE is far different to a traditional ETL due to its design. The application is architected to allow non-IT professionals to manage and execute the data integration process. Finance and accounting professionals can build integrations using an intuitive web interface. The application includes prebuilt logic and frameworks for extracting data from a variety of sources. Transformation logic is managed through the web application in a simple grid interface – no coding logic is required. The loading of transformed data to the EPM suite of products is a simple click of a button – again within the web interface. The ease of use of the application makes it an attractive option for organizations that seek to reduce their reliance on complex toolsets and the professionals required to administer them.
On-Premises and Cloud
Within this volume, when referring to FDMEE, we will be referring to the on-premises deployment of the software. When referring to the cloud counterpart – Data Management – we will refer to this as Cloud Data Management (CDM). This acronym should not be confused with the Oracle master data management solution, Customer Data Management, which is also often referred to as CDM. While this overlap can potentially be confusing, this volume is purpose-written to highlight the data integration products (FDMEE and Cloud Data Management) so we are comfortable leveraging the CDM acronym in this context.
The base code line that
constitutes CDM is entirely the same as that of FDMEE; however, CDM has certain
functionality disabled, the largest of which is scripting which we discuss in
great detail in Chapters 6-9. It should be fairly obvious given the amount of
this book dedicated to the topic that scripting is an important feature of the
FDMEE application. This volume is not intended to function as an analysis of
FDMEE versus CDM capabilities to determine which is right for an organization. I
have published a white paper on this specific topic that is updated
periodically as the software continues to evolve. This white paper  should serve as a tool in your organization’s analysis of the data
integration toolset that is best for your organization’s needs. That said, we
will endeavor to highlight, throughout this volume, FDMEE functionality that is
not available in CDM to avoid any confusion of CDM capabilities.