Bringing DRM and PeopleSoft Together

By | In Oracle Applications | October 09th, 2017

Datavail’s DRM PeopleSoft Adapter provides integration between Oracle Hyperion Data Relationship Management (DRM) and PeopleSoft Financials for Chart of Accounts and Trees. It helps streamline business user experience by providing more flexibility and better performance. This enables users to enjoy seamless integration in maintaining PeopleSoft Trees and managing chart-field creation.

 Challenges of Integrating DRM and PeopleSoft

  • Loss of time and money due to manual processes
  • Human errors arising from manual integration
  • Management of PeopleSoft Trees in DRM using Batch files and flash files
  • Custom Java APIs that are difficult to use and are not upgradeable

Datavail’s Oracle DRM to PeopleSoft Adapter

Datavail’s DRM PeopleSoft Adapter is a hierarchy management tool that helps manage operational and analytical master data, master data and analytical metadata, and data quality and integrity. The integration of Oracle DRM and PeopleSoft Financials, through the use of Datavail’s Adapter, allows these two applications to communicate and update using standard-based, real-time connectivity and powerful integration technologies. In turn, organizations are able to synchronize master data across Enterprise Performance Management applications such as transaction systems, BI platforms, and financial and analytic applications.

Product Features

  • Service Oriented Architecture (SOA), based on out-of-the-box functionality for integrating Chart-of-Accounts (COA) for PeopleSoft
  • Ability to build templates for configuring COA and Trees for PeopleSoft
  • Ability to promote hierarchies automatically from DRM into PeopleSoft
  • Unique web-based user interface
  • Scalable integration framework which can be extended to HR and other modules

 Product Benefits

  1. Solves problems with PeopleSoft Trees and allows direct and real-time access in DRM
  2. Dramatically improves and enhances referential integrity
  3. Allows data to be populated automatically through your systems, so the administrators have less to do in order to patch and maintain it
  4. Lets DRM act as a source for Chart of Accounts and PeopleSoft Trees by allowing it to:
    • Publish COA updates from DRM to PeopleSoft
    • Maintain and publish PeopleSoft trees from DRM
    • Lower the costs of implementation and long-term support
  1.       Removes the need to build custom processes for custom integration through:
    • The use of application templates for loading the properties, exports, validations, and queries
    • The use of a web-based user interface to maintain DRM and PeopleSoft configuration
    • Visibility of the changes published to PeopleSoft through DRM reports
    • The use of adaptor scheduler to publish the changes at required intervals

Leverage Datavail’s extensive experience with DRM across diverse industries and geographies. To learn more, check out some of our additional materials on DRM including our white paper, Stop the Manual Madness with Datavail’s DRM PeopleSoft Adapter.

As an Oracle Platinum Partner with 17 specializations, our EPM know-how and tight integration across consulting, development, support, and education puts our entire team behind your success. Contact us today to start solving your DRM and PeopleSoft integration challenges.

Contact Us
Vice President and Global Practice Director – EPM
Todd Rebner is the Vice President and Global Practice Director – EPM for Datavail, responsible for driving the company’s Enterprise Performance Management initiatives such as Balanced Scorecard and Executive Information System solutions to practical applications such as budgeting/planning and business modeling/process improvements. An acknowledged expert in implementing Oracle Hyperion EPM solutions, Todd brings over 20 years of Accounting, Information Systems, and Technology experience from his former role as CEO of AdvancedEPM Consulting, an Oracle Platinum Partner. His experience extends to multiple software solutions including Oracle/Hyperion, Cognos, Business Objects, Microsoft, and many others. Todd holds a bachelor’s degree from Kent State University of Cleveland, Ohio and an M.B.A from Case Western Reserve University of Cleveland, Ohio. He is well-known as a presenter on EPM topics at a variety of professional organizational meetings and universities.

Leave a Reply

Your email address will not be published.
Required fields are marked (*).