getting the most out of existing fdmee, drm and odi with
TRANSCRIPT
Session ID:
Prepared by:
Remember to complete your evaluation for this session within the app!
11111
Getting the Most Out of Existing FDMEE, DRM and ODI with Cloud E/PBCS
04:30 PM - 05:30 PM Apr. 9, 2019
Sanjay Purohit (Sr. Solution Architect)
Tejas Patel (Sr. Solution Architect)
Applications Software Technology
Focus on
12Industries
Oracle Industry Specializations
Pillar Partner
Go-To Partner
Cloud Marketplace
Strong Oracle
Partnership
Oracle UniversityPartner
24Years of Experience
400+Cloud-
CertifiedEmployees
Six Time Oracle
Excellence
Award
Winner
GlobalPresence
Off-shore Delivery24x7 Support
30+ Specializations/CEI▪Cloud ERP ▪Cloud HCM▪Cloud SCM▪CPQ▪Database
▪Cloud EPM▪Analytics▪PaaS▪ IDM▪WebCenter
Autonomous
Cloud
TesterAutomated testing solution
Straight
Talk
Real
Results
Agenda
➢ Overview of -
➢ Oracle Financial Data Quality Management Enterprise Edition (FDMEE)
➢ Oracle Data Integrator (ODI)
➢ Oracle Data Relationship Management (DRM)
➢ Cloud Data Management
➢ Cloud Enterprise Planning and Budgeting Could Services E/PBCS Application
➢ What is a business case?
➢ Solution Foot Print
➢ High Level Data Flow Diagram
➢ Integration Live Demo
➢ Q & A
Oracle Financial Data Quality Management (FDMEE)
➢ FDQMEE is enterprise-class system for managing quality of data
➢ Combines the platform strength of ODI, with time tested process and methodology of FDM
➢ Key benefits for finance teams➢ Streamlines data collection and
transformation with end to end automation
➢ Audit trails, web based guided workflow
➢ Prepackaged adapters to connect EPM applications with transaction systems
➢ New Customers may only license FDMEE
➢ All new implementations are recommended to occur in FDMEE
Oracle Data Integrator (ODI)➢ Leading ELT tool to consolidate
disperse data
➢ Support almost all technologies
➢ Legacy
➢ OLTP
➢ Prebuilt Knowledge Modules (KM)
➢ Customizable and Flexible KM
➢ Local and WebLogic Agents
➢ Multiple contexts
➢ DRM Automate Context
➢ DRM Context
Data Relationship Management (DRM)
➢ A finest tool for hierarchy management
➢ Integrates with multiple target systems
➢ ERP (GL & Projects)
➢ EPM & BI
➢ Streamline Master Metadata
➢ Configurable and can be managed by
business users
➢ User friendly platform to manage data
governance and compliance reporting
➢ Real time execution or batch load
Oracle Data Management Cloud
➢ Common issue with Legacy DM
system
➢ Expensive but not flexible
➢ Inefficient and Fragmented
➢ Integration with existing
infrastructure
➢ Scalable
➢ Compatible and quickly
deployable
➢ Single Platform for all needs
➢ Cloud to could and On-Prem
Plugins
Enterprise Planning and Budgeting Cloud (E/PBCS)
➢ Low cost and time to deploy
➢ Offered as stand-alone service or with
Oracle ERP Financials Cloud Service
➢ Implementation services are available
from Oracle Consulting and partner
network
➢ Comes with prebuild modules
➢ Financial Statement Planning
➢ Workforce Planning
➢ Capital Asset Planning
➢ Project Financial Planning
➢ Strategic Modeling
What is a business case ?
➢ Leveraging existing
➢ Software licenses and tools
➢ Infrastructure
➢ IT Staff
➢ Multiple providers and services
➢ Seamless Integration
➢ OnPrem <> Cloud EPM
➢ Hybrid support
➢ Easy to manage
➢ Process automation
Courtesy :- https://itbizadvisor.com/2016/12/a-roadmap-for-hybrid-cloud/
Solution Foot Print
Data Flow
FDMEE
DRM
ODI
High Level Data Flow
➢ Two Sections
➢ Source Systems
➢ EPM Systems
➢ Integration Tools
➢ ODI
➢ FDMEE
➢ DRM
➢ Required Data
➢ Rev & Exp
➢ Airport
➢ Lease
➢ Contracts
➢ Rentals
➢ Invoices Actuals
DRM Integration
➢ On Prem Components
➢ DRM
➢ Oracle EBS
➢GL
➢HRMS
➢ Projects
➢ Cloud Components
➢ Oracle E/PBCS
➢ Oracle EPRCS
ODI Integration
➢ On Prem Components
➢ ODI
➢ Oracle EBS
➢HRMS- 8 Interfaces
➢ PropWorks - 6 interface
➢ ODI package executes
➢ Meta/data
➢ Execute Could Backup
➢ Nightly Automation
➢ Business rules
➢Data maps
FDMEE Integration➢ On Prem Components
➢ FDMEE
➢ Oracle EBS
➢ Cloud Components
➢ Oracle EPBCS
➢ Oracle EPRCS
➢ Seamless & Secure
Integration
➢ Supports
➢ Drill-Through
➢ SSO
➢ Writeback
Integration Live Demo
FDMEE to E/PBCS
ODI to E/PBCS
Running Automation
DRM to E/PBCS
Challenges
➢ Enabling Single Sign On (SSO)
➢ FDMEE
➢ Oracle eBS
➢ E/PBCS
➢ DRM
➢ Firewall setup and SSL ports
➢ FDMEE and EPM Automate
➢ Drill-Through from Could PBCS to on-
Prem eBS
➢ Budget writeback from Could E/PBCS
to On-Prem GL
Source:-panalyticsco.com/wp-content/uploads/2016/03/challeges.png
Session ID:
Remember to complete your evaluation for this session within the app!
11111