Oracle Data Integrator: FP&A Scenario for the Real World

Oracle’s recent release of Oracle Data Integrator (ODI) Enterprise Edition 11g delivers high-performance data movement and transformation among enterprise platforms.  It delivers an open architecture and built-in connectivity that provides for straightforward metadata and data loading into Oracle Enterprise Performance Management (EPM)

applications including the Oracle Essbase, Hyperion Planning, and Hyperion Financial Management (HFM)suite of products.  Not only is ODI product easy-to-use, it helps reduce development costs, improve productivity and it is bundled with Hyperion at no extra cost.  Furthermore, ODI is fully integrated with Oracle Fusion Middleware, Oracle Database, and Exadata and, due to its open, standard-based architecture works with 3rd party applications.

The new 11g release provides several new capabilities including faster and more efficient loading and transformation of real-time data into a data warehouse, better productivity with new mapping wizards, quick-editor, generated code simulation and enhanced error table management, and improved support for online analytical processing (OLAP), SAP and new APIs that can be embedded directly within new custom applications.  Although the release provides users a new tool to learn, my recent experience with clients to implement ODI has proven that the tool can be leveraged easily and provide an effective, high-performance architecture.

For instance, recently I worked with a client to utilize ODI for the data load of their Financial Planning and Analytics EPM application.  Client requirements were typical of any organization and included the need for metadata from their data warehouse (DW) to build the Planning application, direct data load from the General Ledger (GL) into an Aggregate Store Option (ASO) cube and from the DW into a Block Storage Option (BSO) cube.  Furthermore, data from both their Human Resource (HR) and GL needed to be brought together to load data into their Hyperion Workforce Planning application.  We were able to leverage ODI and create interfaces to load Planning Metadata sourced from the DW and Essbase data sourced from the GL, HR and DW.  The company now loads packaged metadata and interfaces via a scheduled, nightly scenario. Furthermore, after each nightly load, Essbase calculations and partition rebuild is executed with MXL directly from ODI.  ODI proved to be a powerful application that combines data integration, maintenance, and scheduling into a single tool.


Finally, the development tools of the new 11g version, including Topology Manager, Designer and Operator, provided strategic assistance to efficiently and effectively integrate data.  The Topology Manager, used to manage connections of logical and physical data sources and targets, organized and configured all drivers, created the physical architecture including servers, logins and drivers, and also created the logical architecture with the Logical Identifier that defined the physical architecture and import function to keep the import standard from Development to Test to Production environments.  Designer, used to create source to target connections, provided key items such as the ability to create models to define data structures and reverse data structures to directly read metadata fields, as well as the ability to create and import knowledge modules which were key to loading metadata and data into Essbase, Planning, and HFM.  The Operator tool, used to execute ODI data load packages, provided session lists to track completion of interfaces, packages and scenarios, packaged code or scenarios for execution, and the ability to schedule tasks through an ODI agent.

My experience with ODI has made me a believer in the new release.  This is a great tool that can be scaled with existing source and target hardware and is bundled with Hyperion at no extra cost.  My clients are cutting hardware costs and lowering total cost of ownership.  For more information on ODI, as well as additional examples of different ODI architectures, including a SOX compliant example, view my YouTube video: Oracle Data Integrator for Scalable Higher Performance Architecture.

 

RECENTLY
FROM THE BLOG

 

9/25

PCMCS Webinar