EPM Data Integration

Track sponsored by:

EPM Data Integration at the ODTUG Kscope17 Conference

EPM Data Integration can help save time, development costs, and reduce process execution times. You’ll learn how to move high-volume and batch data while maintaining quality. You’ll learn how to integrate and manage data using Oracle Data Governance and Data Relationship Management (DRM). 

Data Management/Integration:  

Moving data can be a meticulous process. Our experts will show you best practices for moving data to cloud or on-premises using EPM products with FDM/FDMEE and ODI.

Metadata Management Integration:  

We said meticulous, right? We’ll also show you best practices for moving metadata to cloud or on-premises EPM products and how to manage metadata using DRM, DRG, and how to master other data management tools.

Check out the presentations listed below.



Black Belt Techniques for FDMEE Admins and Developers
Francisco Amores , Infratects
Topic: EPM Data Integration - Subtopic: Data management/integration

Willing to take your application to the next level?

FDMEE is a product that can be easily customized to meet any requirement, regardless of its complexity. You may know what you want to do but can't find the right approach.

What about adding a creativeness layer on top of your FDMEE knowledge? The solution may be closer than you think, either using standard functionality or scripting.

In this session, we will cover some nice techniques, tips, and tricks that will give you a helping hand to get the most out of FDMEE.

Using locations for admin purposes, enhancing batch management with custom scripts, or using lookup dimensions and SQL map scripts to define standard multi-dim maps based on target dimensions are just some of the techniques we will talk about.

Don't miss this session, regardless of your level, if you want to see how standard functionality can turn into simple and powerful solutions.

Back to Top
A DRM Journey: A N00b's Perspective
Kris Calabro , JCI
Co-presenter(s): Natalie Delemar, Ernst & Young
Topic: EPM Data Integration - Subtopic: Metadata management/integration

Not all that long ago, DRM was a mystery: No one really could agree on what the acronym DRM spelled out – was it Data Relationship Management or maybe Dimension Relational Manager or maybe something else – or understand how the tool worked or even appreciate DRM's role in the EPM ecosystem. Today we know what DRM means (Data Relationship Management); have mastered (sort of) its features, functions, and intricacies; and can truly understand the value it brings in managing metadata across an Oracle EPM implementation's many tools and applications. Join Tyco EPM administrators as they review the transformative role of DRM, the challenges faced and solutions derived, and why every new Tyco application has DRM at its core.

Back to Top
On-Prem to EPM Cloud (Hybrid) and Cloud-Only-Based Integration Solutions
Michael Casey , Oracle Corporation
Topic: EPM Data Integration - Subtopic: Data management/integration

This session will explain the integration options for EPM cloud services, when source data resides on-premise or in the cloud. Examples of hybrid integration will be shown where data from on-prem sources such as an ERP or data warehouse can be loaded to the cloud, drilled from the cloud back to on-prem, and extracted from the cloud for use in other on-prem applications. In addition, solutions to move data between EPM Cloud services and between the Fusion GL Cloud and EPM services will be explained. Details related to current features and product roadmap will also be provided.

Back to Top
Velcro and FDMEE: One Data Management Solution for EPM Cloud and On-Prem Systems
Doug Correa , Peloton Group
Co-presenter(s): Michael True, Velcro Group Corp.
Topic: EPM Data Integration - Subtopic: Data management/integration

When Velcro embarked on its EPM journey, it elected a hybrid approach, using Oracle’s cloud and on-premises applications PBCS and HFM.

Next, Velcro needed a data management solution that could support integrations to both cloud and on-prem EPM applications, pull data directly from ERP systems, and easily transfer data between EPM apps. Velcro chose FDMEE 11.1.2.4.

This customer success story will focus on how Velcro used FDMEE’s advanced features to simplify and enhance its EPM planning and reporting processes

Back to Top
DRG: Creating Workflows in DRM
Steven Davis , TopDown Consulting
Topic: EPM Data Integration - Subtopic: Metadata management/integration

Data governance continues to be a big topic. Regardless of company size, at some point a growing organization decides to implement workflow in order to capture the changes you need to make to the master data. This is where DRG comes in. In this session, Steven Davis, DRM and DRG expert, will show you how to create collaborative workflows in DRG. He will look at workflow models, requests, paths, tags, worklists, tasks, models, filters, and users. He will show you how to:
• Create models and tasks
• Build workflow objects
• Auto number your new accounts and create validations on the workflow
• Assign security to the users and hierarchies
• Separate duties and do conditional workflows
• Filter nodes
• And more
The session will include real-world examples as well as tips, tricks, and best practices for working collaboratively with DRG to make sure all users have the necessary change management and data quality remediation workflows to effectively do their jobs. NOTE: Attendees should have a good understanding of DRM. They should understand what workflow is and how it is used.

Back to Top
Data Warehouse 2.0: Master Techniques for EPM Guys (Powered by ODI)
Co-presenter(s): Ricardo Zoldan Giampaoli, Sr, TeraCorp
Topic: EPM Data Integration - Subtopic: Other EPM Data Integration

EPM environments are generally supported by a Data Warehouse; however, we often see that those DWs are not optimized for the EPM tools. During the years, we have witnessed that modeling a DW thinking about the EPM tools may greatly increase the overall architecture performance.

The most common situation found in several projects is that the people that develops the data warehouse does not have a great knowledge about EPM tools and vice-versa. This may create a big gap between those two concepts which may severally impact performance.

This session will show a lot of techniques to model the right Data Warehouse for EPM tools. We will discuss how to improve performance using partitioned tables, create hierarchical queries with “Connect by Prior”, the correct way to use Multi-Period tables for block data load using Pivot/Unpivot and more. And if you want to go ever further, we will show you how to leverage all those techniques using ODI, which will create the perfect mix to perform any process between your DW and EPM environments.

Back to Top
ASO Plan Type: To Seek Out New Integrations with ODI
Michael Hansen , Leidos
Co-presenter(s): Trina Nguyen, Leidos, Inc
Topic: EPM Data Integration - Subtopic: Other EPM Data Integration

Be prepared to be beamed up! In this session, you will embark on a voyage that an enterprise took utilizing ODI as its warp core to improve data integrity and efficiency, and reduce the cost of ownership of their EPM Planning and Essbase solution. There will be a brief overview of the ODI use case and how ODI was instrumental in achieving a self-service ASO Plan Type Solution. Discover how Leidos creatively utilized ODI for more than just metadata and data integration, including assisting with procedure calculations, dynamically generating business rules, launching calculations, building alt hierarchies from forms, data validations, and much more.

Back to Top
Best Practices of the Design and Delivery of Master Data from DRM to Downstream Applications for Large Implementations
Kate Helmer , Huron Consulting Group
Co-presenter(s): Joe Davis, Huron Consulting Group
Topic: EPM Data Integration - Subtopic: Metadata management/integration

Minimize maintenance and make delivering master data to your customers a breeze with the right design and methodology. Consuming master data from Oracle Data Relationship Management can be a convoluted mess of flat files (yuck!), tables, and technologies in a large enterprise; simplify and standardize by utilizing these design tips to creating a master data repository that can deliver and scale with ease. Join Joe Davis and Kate Helmer as they detail design considerations of master data repositories, the pros and cons of the methodology, and how to standardize the technical integrations to downstream systems.

Back to Top
The PBCS REST API Demystified
Jason Jones , Applied OLAP, Inc.
Co-presenter(s): Jon Harvey, eCapital Advisors
Topic: EPM Data Integration - Subtopic: Cloud Integration

Oracle's Planning and Budgeting Cloud Service (PBCS) offers a REST API, but how does it work and what can it do? This presentation for administrators and developers will give an approachable overview of how the API works, what its capabilities are, and how it can be practically used in automation and data integration scenarios.

Back to Top
How to Best Manage Your Relationships…With Data: Building a Strong Foundation for PAREXEL Using Oracle Data Relationship Management Best Practices
Julia Radovani , Peloton Group
Co-presenter(s): David Harter, Peloton Group
Topic: EPM Data Integration - Subtopic: Metadata management/integration

With the wide-spread popularity of integrated enterprise systems, a need has emerged for data management technology that drives the timely synchronization and alignment of metadata and transactional data. Leading organizations are positioning purpose-built Oracle data management and integration technologies as strategic pillars for achieving analytical and reporting systems expansion.
This presentation will discuss how PAREXEL, a leading clinical research organization, leveraged Oracle Data Relationship Management (DRM) to achieve data alignment and automation efficiency across changing operational ERP and EPM systems. At PAREXEL, DRM was used to consolidate hierarchies, automate the alignment of common metadata structures in target EPM systems, and promote shared data stewardship across Finance and IT functions. Particularly for non-financial master data, DRM enabled critical Project-Client data remediation processes and Organizational modeling capabilities.
In this presentation we will share some industry best practices around data management when integrating Oracle DRM with Financial Data Quality Management, Hyperion Planning, Hyperion Financial Management, and Account Reconciliation Manager. Some of the topics include:
• Mastering financial and non-financial data sets in DRM (Chart of Accounts, Capital Assets, Project, Client).
• Consolidating maintenance of data mapping rules in DRM to guarantee referential integrity and alignment across ERP and EPM data sets.
• Rationalizing data specification errors and re-mediating data quality issues from external applications in DRM.

Back to Top
Ask the Experts - An Informal Panel for FDMEE Integrations
Anthony Scalese , Edgewater Ranzal
Co-presenter(s): Francisco Amores
Topic: EPM Data Integration - Subtopic: Data management/integration

Tired of trying to get your FDMEE questions answered in other panels that span all the EPM technologies? Perhaps you are considering an upgrade to FDMEE, maybe you have already upgraded and are missing key functionality, maybe you are trying to understand your options for cloud integration with FDMEE, or maybe you just want to learn more about what you can do with FDMEE.

In this session, two of the industry's foremost experts in data integration - Tony Scalese and Francisco Amores Torres - will host an interactive panel with the audience. Tony and Francisco will share their knowledge drawing on their vast experience implementing and upgrading FDMEE. This session is vital to anyone that wants to learn more about FDMEE.

Back to Top
FDMEE Scripting - Cloud and On-Premises - It Ain't Groovy, But It's My Bread and Butter
Anthony Scalese , Edgewater Ranzal
Topic: EPM Data Integration - Subtopic: Data management/integration

So you've made the transition to FDMEE and now you want more. FDMEE scripting is what empowers you to do more with the application. In this session, we will explore how to use FDMEE scripting to enhance and streamline your integrations. We'll explore how to use Jython and the various APIs within the EPM stack to take your application to the next level. Have a hybrid FDMEE cloud deployment? That's cool, let's look at Groovy and EPMAutomate and see how FDMEE can function as your automation hub.

This session will be most useful for those with a solid FDMEE foundation and some familiarity with scripting languages.

Back to Top
Introduction to the EPM REST APIs
Jake Turrell , Turrell Consulting
Topic: EPM Data Integration - Subtopic: Cloud Integration

Oracle's EPM REST APIs allow developers to automate and integrate their environments using any programming language with an HTTP client library. This session will provide attendees with a tour of the EPM REST API landscape and will give developers concrete examples they can build upon themselves. Users will leave this session with an understanding of basic REST concepts and the confidence to develop their own REST API integrations for Planning, Migrations and Data Management.

Back to Top